https://www.infopathdev.com:443/forums/44.aspx enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/68661.aspxSun, 24 Jul 2011 20:33:54 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:68661Patrick Halstead0https://www.infopathdev.com:443/forums/thread/68661.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=68661<p>If your SharePoint list is small (&lt;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.</p> <p>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&#39;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 <a title="odata on channel9" href="http://channel9.msdn.com/Tags/odata" target="_blank">Microsoft&#39;s Channel 9 site</a> in the next week for an example by Hilary Stoupa regarding OData.</p>https://www.infopathdev.com:443/forums/thread/68627.aspxThu, 21 Jul 2011 22:01:58 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:68627mikeyfev10https://www.infopathdev.com:443/forums/thread/68627.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=68627<p>Hello,</p> <p>I need to query a data connection (Sharepoint list) for all items where a specific column is null.&nbsp; Is there a way to do this with rules?</p> <p>If not, how is this done with code-behind?</p>