What is COQL syntax for LIKE in a compound where clause?
This works:
queryMap.put({"select_query":"select In_Production, GS_Due, Stage from Production_Orders where ((Stage = 'Preparing Order') or (Stage = 'Order In Production')) limit " + offset + ", 100"});
When I add the like condition it fails.
queryMap.put({"select_query":"select In_Production, GS_Due, Stage from Production_Orders where ((Stage = 'Preparing Order') or (Stage = 'Order In Production') or (Stage like '%Tracking%')) limit " + offset + ", 100"});
What's wrong with my syntax?