Null Vallue Lookup Column Issue

I've tried to create a SharePoint view with a lookup column value equals null, but even though there are items with "Phase" column equal to NULL, nothing is shown in the view.

I looked up the column value through the code, and it is NULL; I looked up the view CAML and it looks right: "<Query><Where><IsNull><FieldRef Name="Phase" /></IsNull></Where></Query>".

I really have no more ideas why it behaves this way.

Any suggestions are welcome

July 2nd, 2013 5:52pm

Hi,

the query of the view should look like this:

"<Where><IsNull><FieldRef Name="Phase" /></IsNull></Where>"

You have the <Query> surround your where clause which might cause the issue.

Kind regards
Stefan

July 3rd, 2013 1:07am

Hi,

the query of the view should look like this:

"<Where><IsNull><FieldRef Name="Phase" /></IsNull></Where>"

You have the <Query> surround your where clause which might cause the issue.

Kind regards

July 3rd, 2013 9:39am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics