Project

General

Profile

Actions

Bug #7569

closed

Age searching not allowing for exact age

Added by krileon over 5 years ago. Updated almost 5 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Target version:
Start date:
03 June 2019
Due date:
% Done:

100%

Estimated time:

Description

Currently if you select a minimum and maximum same age (e.g. 30) it won't find a user with that age. This could be due to search SQL using > and < instead of >= and <= as it should.

https://www.joomlapolis.com/forum/255-developer-members-support/240992-age-in-code-field

Actions #1

Updated by krileon over 5 years ago

  • Description updated (diff)
Actions #2

Updated by krileon over 5 years ago

Confirmed query is using >= and <=, but it should be >= 30 and < 31. It's currently doing >= 30 <= 30 which won't make any sense when doing this with raw dates.

Actions #3

Updated by krileon over 5 years ago

Technically the user should've selected 30 to 31 range instead of 30 to 30, but in this case it should just treat 30 to 30 as 30 to 31 under the hood.

Actions #4

Updated by krileon over 5 years ago

  • Status changed from Assigned to Resolved
  • % Done changed from 0 to 100

Fixed in MR !1476

Actions #5

Updated by beat almost 5 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF