How to pass specific DB row into BarTender 2016? 追蹤

Luke Reynolds

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?

1 意見

Seb Atkins
評論操作 永久連結

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