Tell me more ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.
up vote 1 down vote favorite

I need to get items from my list where multiLookup field contains value (for example, value is 42) or has no values. First part is simple:

<Eq>
    <FieldRef Name='mlookup' LookupId='true' />
    <Value Type='Integer'>42</Value>
</Eq>

Problems in second part. I tried to use <IsNull><FieldRef Name='mlookup' /></IsNull> but it falls with ArgumentException ("Value does not fall within the expected range.") Is there any solutions for my problem? Thanks in advance.

share|improve this question
1  
When you ran <IsNull><FieldRef Name='mlookup' /></IsNull> did you remove the <Eq> ? This should work: <Query><Where><IsNull><FieldRef Name="Customer" /></IsNull></Where></Query> – eirikb Oct 16 '12 at 5:51
What's the exact query you're using to combine them? – lgaud Oct 18 '12 at 23:25

1 Answer

up vote 1 down vote accepted

Your Query is right.. problem is something else.. I tried it in my environment it is working fine.. try it by using CAML Builder.. it will show you result of you query also..

<Where>
      <IsNull>
         <FieldRef Name='DestinationColumn' />
      </IsNull>
   </Where>
share|improve this answer
Oh, you are right. The problem is in another part of query. Thanks for helping to see it – Denis Zavershinskiy Oct 16 '12 at 6:29
Dont forget to Mark as Answer.. – Torque Oct 16 '12 at 6:37

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.