1

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.

2
  • 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, 2012 at 5:51
  • What's the exact query you're using to combine them?
    – lgaud
    Oct 18, 2012 at 23:25

1 Answer 1

1

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>
2
  • Oh, you are right. The problem is in another part of query. Thanks for helping to see it Oct 16, 2012 at 6:29
  • Dont forget to Mark as Answer.. Oct 16, 2012 at 6:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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