cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

282
Views
0
Helpful
1
Replies
Warren Tolentino
Beginner

Query To Locate Action Variable Being Called From


we have this "M011 - 0" action variable that resets the value back to 0. i can't seems to find where this action variable is being called from the tidal. i looked at every places and failed to locate it. does anyone have a SQL query to find where this piece of info can be located?

thank you,
warren

1 REPLY 1
Marc Clasby
Beginner

Try the Query that joins events and actions to find your event... then you can do a similar query to find jobs

Marc

 

SELECT dbo.tskmst.tskmst_name AS [Action Name], dbo.trgmst.trgmst_name AS [Event Name]

FROM dbo.trgmst INNER JOIN

dbo.trgtsk ON dbo.trgmst.trgmst_id = dbo.trgtsk.trgmst_id RIGHT OUTER JOIN

dbo.tskmst ON dbo.trgtsk.tskmst_id = dbo.tskmst.tskmst_id

WHERE (dbo.tskmst.tskmst_name LIKE '%M011%')

Content for Community-Ad
This widget could not be displayed.