Notifications
Clear all
Topic starter
Can anyone tell me how you can identify from the problem table what is an active/inactive problem.
There seems to be no fields to identify that.
Posted : May 9, 2017 8:25 am
There should be a table called VACTIVEPROBLEM under "Views". Hope this helps.
Posted : May 9, 2017 8:35 am
You can use the view reference by wsc27, it should accomplish what you want. To answer the question though, use below. XID marks active row in the chain, stopdate filter, and change for not filed in error.
XID = 1000000000000000000
stopdate > today (crystal) stopdate > getdate() (sql)
change < 10
Posted : May 9, 2017 11:49 pm
We are on CPS (SQL). The method we use for active problems is:
WHERE CHANGE IN (2,6) AND STOPDATE > GETDATE()
Posted : May 15, 2017 2:28 am
@wsc27 I spent about 2 days trying to figure this out. Thanks for the tip!!!
Posted : January 30, 2018 4:30 am
