Multiple search options includes "and" condition

  • 0
  • 1
  • Question
  • Updated 6 months 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 6 months ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 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.