AI OnAI Off
Null values and FindPagesWithCriteria method
Vote:
Ok, here's the deal. I have two custom properties. I've attached them to pages. Some of the pages have both properties defined, others just one of them (undefined value is NULL in db). Now I want to make a search with FindPagesWithCriteria method and find pages that have the other property defined but with other property undefined.
I added two criterias with Required properties to make it an AND search. The first criteria is simple, it just compares string value to another string. But the second part where I need to compare whether the property is defined or not, is a bit trickier. I tried to use "" and null as search values for the undefined value, but it didn't work. The search just seemed to ignore them. There's no method for testing undefined values in CompareCondition and StringCompareMethod classes.
I can loop the pages manually and test the properties with each page, but is there a way to do it with FindPagesWithCriteria method?
Feb 10, 2006 15:43
Hi
The trick is the PropertyCriteria.IsNull Property. Set that to true to find properties which are null. See the code below for a sample.
#14416
PropertyCriteria criteria = new PropertyCriteria();
criteria.IsNull = true;
criteria.Name = "WriterName";
PropertyCriteriaCollection pcc = new PropertyCriteriaCollection();
col.Add(criteria);
PageDataCollection pages;
pages = Global.EPDataFactory.FindPagesWithCriteria(Global.EPConfig.StartPage, pcc, EPiServer.Security.AccessControlList.NoAccess);
That code will return all pages where WriterName is null.
Feb 10, 2006 16:34
