How to pass specific DB row into BarTender 2016?

Luke Reynolds

• 4 de abril de 2017 21:20

Hello everyone! I'm trying to set up an integration with Epicor so that users can select a job ID and print a label for every part involved with that job ID all at once. My problem is that I don't know how to pass the user's selected job ID to the Bartender label. My most recent attempt was to copy a similar query from Epicor into the BarTender label's database source, but that ended up printing a label for every part involved with any Job ID ever. I feel like I have all the ingredients I need to make this work, I just don't know how to combine them properly. Does anyone have experience with this kind of integration?

0

• 

  Seb Atkins

  ★ BarTender Hero ★

  • 2 de junio de 2017 10:00

  Hi Luke,

   

  You need to create a query prompt to allow the user to input the Job ID, then in your query add a where statement like " WHERE Db.JobID = '?query prompt name'

  Hope this helps

  0

Iniciar sesión para dejar un comentario.