Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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?

share|improve this question
    
Note that, per the FAQ we do not accept questions about commercial third-party products. As far as I can tell this is a general SharePoint question which is fine. In future it would be great if you could phrase questions in general terms, rather than in relation to a vendor product (Nintex). Thanks. –  SPDoctor Nov 24 '11 at 9:04
add comment

1 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.

share|improve this answer
    
Thanks, @Matthias for the answer. However, Nintex does not allow me to do so. As SPDoctor pointed out, it's not appropriate for me to ask this question here. I'll pursue the answer on Nintex site, and hope there is a satisfactory one. Cheers. –  Tinminator Nov 29 '11 at 2:51
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.