• DOCUMENTATION
  • WORKATO BLOG
  • PRODUCT BLOG
  • Return to Workato
  • Log in
  • ☰
  • Community/Discussions
New Topic
Discussions Recipe Building Applications Questions
S

Saul Macht

started a topic about 4 years ago

QuickBase: How to combine AND & OR operators in Scheduled trigger QuickBase query?

How to combine AND & OR operators in the QuickBase query?


I have tried {'11'.EX.'Product'} OR {'11'.EX.'Services'} AND {'124'.EX.'52'} but that did not pick up the correct set of records

Amanda Wong

said about 4 years ago

Hi Saul, assuming you wish to retrieve records with FID_11 == Product or Services AND FID_124 == 52,


please use ({'11'.EX.'Product'} OR {'11'.EX.'Services'}) AND {'124'.EX.'52'}. You can combine them using brackets.

Login to post a comment

Still can't find your solution?

Send us a ticket, we will try our best to assist you with your problem

Documentation
Developer's Library
Tutorials
eBooks
Product Hour
Product Blog
Workato Blog
Product updates
Customer Stories
© Workato 2020   Privacy   Terms   +1 (844) 469-6752
  • Documentation
  • Workato Blog
  • Product Blog
  • Solutions
  • Forums
  • Tickets
  • Log in
  • Return to Workato