Multiple Query Options

Legacy Poster

• January 10, 2015 14:21

hey guys new here to the site and the software as well. I'm currently running Bartender 10.1 automation and been trying to make things easier for our employees. I have a sql database for our back office software containing 10,000+ grocery and alcohol items that is connected to Bartender. I made a query prompt for searching the database based on description which is working perfectly, but some people have asked if they can search by department number as well 30=grocery, 50=wine, 60=beer etc. etc......

 

my question is can i create a prompt that would allow a user to search by either product description or department number?

 

Thanks for any help. I watched all the videos and found nothing so far

0

• 

  Shotaro Ito

  ★ BarTender Hero ★

  • January 22, 2015 09:20

  You can create two query prompts and connect by OR condition. 

   

  (description = queryprompt1 ) OR

  (department = queryprompt2 )

  [attachment=1388:ORcondition.png]

  In that query, if only one condition is input, that condition is used.

  Note that if you input both conditions, it will return all records which matches either description or department.

  (all records which has description of "sweet" + all records which has department of "50" etc).

   

  At print dialog, specify [Select at print time] in queried records, so you can see which records going to be printed.

  [attachment=1389:selectedAtPrintTime.png]

   

   

  0

Please sign in to leave a comment.