Forum Discussion

PushpakumarGna1's avatar
PushpakumarGna1
Qrew Assistant Captain
7 years ago

Multiple search options includes ""and"" condition

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

1 Reply

  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    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.