How to pass specific DB row into BarTender 2016?

Luke Reynolds

• 2017年04月04日 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 ★

  • 2017年06月02日 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

請登入寫評論。