Added by nant almost 15 years ago. Updated over 14 years ago.
Description
As described here:
it looks like the filtering does not work on the Last Online field.
Files
| 2337.patch (3.92 KB) 2337.patch | krileon, 27 April 2011 21:57 |
Updated by krileon over 14 years ago
Actions
#1
Confirmed, "is not" returns the same results as "is".
Updated by krileon over 14 years ago
Actions
#2
Reviewing further if the "Between" date is specified and not the "and" date then it'll find everyone with a date GREATER than specified. If the "and" date is specified and NOT the "Between" date then it'll find everyone with a date LESS than specified. This can be reversed with an IF statement to change the search operator based off search mode, which seams best approach (making "Between" the less than and "and" the greater than).
Updated by krileon over 14 years ago
Actions
#3
Seams cbSqlQueryPart needs to be expanded to handle ranges. Example query below with current usage of isnot.
WHERE ((u.`lastvisitDate` >= '2011-01-26')
AND (u.`lastvisitDate` <= '2011-01-28'))
If expanded to handle ranges would be as follows.
WHERE ((u.`lastvisitDate` NOT BETWEEN '2011-01-26' AND '2011-01-28'))
Updated by krileon over 14 years ago
Actions
#4
Appears can be resolved using OR instead of AND in those scenarios, which API certainly supports.
Updated by krileon over 14 years ago
Actions
#5
Completely rewrote the code responsible for search query criteria. Using addChildren method when necessary was able to provide an AND/OR scenario.
Updated by beat over 14 years ago
Actions
#6
Updated by beat over 14 years ago
Actions
#7
Updated by beat over 14 years ago
Actions
#8
Fixed in r1487 by implementing the proposed patch. Thank you Kyle.