i need to find the work items which is available longer than 10 mins in the quque....
is there any code availble for that.
Please guide me
This topic has been locked.
1 reply Latest Post - 2012-07-31T19:20:04Z by drdamour
Pinned topic Find work items
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-07-31T19:20:04Z at 2012-07-31T19:20:04Z by drdamour
drdamour 0600029F9D40 PostsACCEPTED ANSWER
Re: Find work items2012-07-31T19:20:04Z in response to LennyECMYou want to query the queues using F_EnqueueTime as part of your filter clause
time types are stored as epoch int's so you have to use the function for the given DB type. IE GETDATE() for SQL server alas;
F_EnqueueTime > DATEDIFF(s, '1970-01-01 00:00:00', GETUTCDATE()) - 60*10
would be anything in there longer than 10 minutes
different dbs are different statements, http://www.epochconverter.com/ is a good resource
I am Just a new Boy,
A Stranger in this Town,
Where are All the Good Times,
Who's Gonna Show this Stranger Around?
Check out our Agile ACM Catalogue: Widgets, APIs, & Components for Building Solutions