Multiple search options includes "and" condition

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
  • (Edited)
Hi Team, I need to add combination search box. i.e i need to enter the state and the city and i should get the result for both searches. like where state='GA' and city='ATLANTA' in the sql format
Photo of Pushpakumar Gnanadurai

Posted 1 year ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,758 Points 20k badge 2x thumb
If you are using any of the QB native search boxes (home page or on reports) you can include the word OR to find multiple options.

ga OR atlanta

will give you any records that have either of those in the available fields.