I have a simple list represent a hierarchy. The list columns: ID
, Title
, Parent
, other columns
.
Where Parent is a lookup column
back to the list itself and get information from the Title column.
In a Nintex work flow, I need to look up the parent ID of the current item so to check values of other columns
in parent item.
The query to get the parent ID, at best, from me is:
<Query>
<Lists>
<List ID="{8F29198F-04FA-4558-A5A6-64FA8A85E7DE}" />
</Lists>
<ViewFields>
<FieldRef Name="Parent" />
</ViewFields>
<Where>
<Eq>
<FieldRef Name="ID" />
<Value Type="Counter">{WorkflowVariable:CurrentID}</Value>
</Eq>
</Where>
</Query>
When storing the result of the query in a workflow variable ParentIDLookup
, I, of course only get the parent Title
, but not the parent ID
How do I get the parent ID
from the current ID
?