I need to look up data from 2 different tables to match the person ID from the PersonID table with the peripheral number from the agent table.
Here is my query which works fine in SSMS
SELECT t_Person.LoginName, Agent.PeripheralNumber
FROM Agent INNER JOIN
t_Person ON Agent.PersonID = t_Person.PersonID
WHERE t_Person.LoginName = 'bstepp'
this query returns my peripheral number which I need to send to a queue to agent node.
I am getting the login name from CVP on PV4 and in ICM need to translate that to my peripheral number to ring the agent phone.
What is the best way to do this? DBLookup node? Set PV?