Hi,
On one of my lists i'd like to be able to extract the idle time of workflows that are running on an item. I'm aware I can use the CAML query editor, and have done so for extracting check in comments when a workflow is edited (in order to notify some users of changes to workflows):
<Query>
<Lists>
<List Title="NintexWorkflows" />
</Lists>
<ViewFields>
<FieldRef Name="_CheckinComment" />
<FieldRef Name="Title" />
</ViewFields>
<Where>
<Eq>
<FieldRef Name="Title" />
<Value Type="Text">NAMEOFWORKFLOW</Value>
</Eq>
</Where>
<ViewAttributes Scope="Recursive" />
</Query>
However I don't know what the column name is in the hidden Nintex Workflows list for idle time - I tried using "_IdleTime" but this was not correct.
Does anyone know what the column name is containing idle time, or even better, how to make the hidden workflows list visible?
Thanks!