How to use LIKE operator in Active Objects query

Max Madjarov

Hallo :-)

i would like to fetch all records in DB that have similar titles with LIKE operator. My query looks like:

import com.atlassian.activeobjects.external.ActiveObjects;
...
private final ActiveObjects ao;
...
int queryResult0 = ao.find(CategoryEntity.class,
                Query.select().where("CATEGORY_TITLE LIKE ?", categoryTitle)).length;

but i allways get an empty set!!! only if the category title exactly matches, like MyTitle -> MyTitle (TRUE) i get some results if not, like MyTitle - mytitle (FALSE) i get no results!

Please help :-)

Thanks

Max

Max Madjarov

it was very easy... CATEGORY_TITLE and "query" string should be casted to lower or upper case:

int queryResult0 = ao.find(CategoryEntity.class,
                Query.select().where("LOWER(CATEGORY_TITLE) LIKE LOWER(?)", "%" + categoryTitle + "%")).length;

because like- query is case sensetive and you should have two strings in same, lower or upper case to compare....

Thanks!