ListView control , caml query issue

[sojanm]

I am using the function fn-userProfilelookup in caml query for the list view control and it is not geting any value it seems, i am not getting any records. The function works in calculated value control, the query works if I set hardcoded value. Also if i use getQueryString function the query works.

Is fn-userprofilelookup supported in caml query.

<And>
 <Eq>
<FieldRef Name='Status' />
<Value Type='Text'>Approved</Value>
</Eq>
<Eq>
<FieldRef Name='ItemID' />
<Value Type='Text'>fn-userProfileLookup(Current User,"ItemId")</Value>
</Eq>
</And>

[emha]

how did you build this snippet/formula?

userProfileLookup() is a runtime function, there is not any equivalent inline function like fn-userProfileLookup() 

[sojanm · Accepted solution]

I was just trying to see if the functions works, finally end up loading the page again passing value in the url and GetQueryString function to get the value into the caml query.