How to query for a null value? - InfoPath Dev
in

InfoPath Dev

How to query for a null value?

Last post 07-24-2011 01:33 PM by Patrick Halstead. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 07-21-2011 03:01 PM

    How to query for a null value?

    Hello,

    I need to query a data connection (Sharepoint list) for all items where a specific column is null.  Is there a way to do this with rules?

    If not, how is this done with code-behind?

    Mike Frederick
  • 07-24-2011 01:33 PM In reply to

    Re: How to query for a null value?

    If your SharePoint list is small (<200 items), I recommend just loading the entire thing and filtering the data based on a rule. There are many rule conditions and you should be able to easily select items with blank values for the column in question.

    If you have a larger set, you can use OData (ShP2010) or filterowssvr (MOSS 2007) to filter on the server. The latter will require code behind or Qdabra's qRules which has a fiterowssvr command that you can easily access via a set-value command in a rule. OData is a very powerful way to access list data in SharePoint 2010. Check out Microsoft's Channel 9 site in the next week for an example by Hilary Stoupa regarding OData.

    Patrick Halstead
    Project Manager at Qdabra
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.