CAML query Lookup column value

Question

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?

Answer 1

Try to execute a CAML query directly on the list (SPList.GetItems(SPQuery)) and not on the site, then you should get a value like <parentID>;#<parentTitle> (SPFielLookupValue) for the Parent lookup column.