Hi All,
I need a SQL query to get the corresponding tags from a running process's session ID from the Work Queue. ( I am just looking to check if a certain tag is in the Queue for the current active process)
I am getting the list of active session ID's from the below query.
Select distinct CAST(S.sessionid AS CHAR(100))
AS sessionid, CAST(R.name AS CHAR(100)) AS resourcename,
CAST(P.name AS CHAR(100)) AS processname from
[dbo].[BPASession] AS S, [dbo].[BPAResource]
AS R, [dbo].[BPAProcess] AS P where
runningresourceid = resourceid and S.processid = P.processid and S.statusid =1
Thanks in advance
Regards,
Gary
I need a SQL query to get the corresponding tags from a running process's session ID from the Work Queue. ( I am just looking to check if a certain tag is in the Queue for the current active process)
I am getting the list of active session ID's from the below query.
Select distinct CAST(S.sessionid AS CHAR(100))
AS sessionid, CAST(R.name AS CHAR(100)) AS resourcename,
CAST(P.name AS CHAR(100)) AS processname from
[dbo].[BPASession] AS S, [dbo].[BPAResource]
AS R, [dbo].[BPAProcess] AS P where
runningresourceid = resourceid and S.processid = P.processid and S.statusid =1
Thanks in advance
Regards,
Gary