Live Lookups against SQL Database

#1
I have a few sessions that have 10 fields, One field being an asset tag that populates when scanned. Currently, I have the other 9 fields doing lookups against the local device on a master asset list table. That master asset list is populated via Connect and it comes from a SQL database. The end users have to update the database and then have that master asset list session updated.

What I want to do is eliminate the need for that asset list table and have those 9 fields do live looks up against the SQL database once an asset tag is scanned. I'm finding some material but I haven't found anything that shows how to configure this setup. Is it possible to make fields do live lookups against a SQL database once an item is scanned? Is so, is there an example or step-by-step process for that?

Thanks,
Joel
 

Dan Peluso

Member
Staff member
#2
Hi,

I believe you also asked about this via our support channel. For the benefit of the group here, I will answer here as well.

When you set up a live session in TracerPlus to connect to a data table in TracerPlus Connect, there is not much you need to do on the TP Desktop side aside from enabling Live mode in the Project-->Connect-->Live Sessions configuration area.

For the lookups themselves, there is no setting that needs to be made in the field lookup configuration since it is just going to get the data from wherever the 'source' table is. If this is a local device table or if it resolves to a live connection via TracerPlus Connect, the lookup config itself is identical and no specific settings need to be made.

Let me know if that helps.