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?
Topic Participants
Ken Florian
Praveen Sankar
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Zoho Orchestly Resources
Zoho Creator Resources
Zoho WorkDrive Resources
Zoho Campaigns Resources
Zoho CRM Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー