CB

Confirmed, "is not" returns the same results as "is".

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'))

Appears can be resolved using OR instead of AND in those scenarios, which API certainly supports.

Completely rewrote the code responsible for search query criteria. Using addChildren method when necessary was able to provide an AND/OR scenario.

Fixed in r1487 by implementing the proposed patch. Thank you Kyle.