Join us this Friday for AI in Action at the Virtual Happy Hour! This free virtual event is open to all—enroll now on Academy and don’t miss out.
AI OnAI Off
How to find pages with an empty property?
Hi Kenneth!
Try using the PropertyCriteria.IsNull instead, like:
#15341
PropertyCriteriaCollection col = new PropertyCriteriaCollection();
PropertyCriteria criteria = new PropertyCriteria();
criteria.Name = "infoOwner";
criteria.IsNull = true;
criteria.Condition = EPiServer.Filters.CompareCondition.Equal;
col.Add(criteria);
PageDataCollection pages = EPiServer.Global.EPDataFactory.FindPagesWithCriteria(Global.EPConfig.RootPage,col);
Regards,
Johan Olofsson
EPiServer AB
Jun 14, 2007 13:55
those 3 criterea won't work fo an epi property i.e 'PageName' , what's the best way to FPWC and passing it a generic request to ret all pages. in my mind if pagename is there it should return it, then I can filter on my custom needs
FilterCriteria.IsNull = true;
FilterCriteria.Name = "PageName";
Feb 20, 2009 12:32
what about rather checking that it's not null.. on the epi property pagename
Feb 20, 2009 12:35
hi,
If you just require a list of the pages, do you need to go through EPi at all?
A piece of T-sql might be a better route to get this information.
Ian
Feb 26, 2009 14:28
I was working on a similar issue yesterday (before reading this thread) and never got the hang of the workings of IsNull. I ended up getting all pages (by searching for a PageTypeID greater than 0) and looping through/filtering the pages. I suppose you're only doing this once to the performance penalty of such an approach is probably neglible.
Edit: Oh, this is probably even easier by using the DataFactory.Instance.GetDescendents if you are running CMS 5 R2
Edited,
Feb 27, 2009 7:10
PropertyCriteriaCollection col = new PropertyCriteriaCollection(); PropertyCriteria criteria = new PropertyCriteria(); criteria.Name = "infoOwner"; criteria.Value = string.Empty; criteria.Condition = EPiServer.Filters.CompareCondition.Equal; col.Add(criteria); PageDataCollection pages = EPiServer.Global.EPDataFactory.FindPagesWithCriteria(Global.EPConfig.RootPage,col);andPropertyCriteriaCollection col = new PropertyCriteriaCollection(); PropertyCriteria criteria = new PropertyCriteria(); criteria.Name = "infoOwner"; criteria.Value = null; criteria.Condition = EPiServer.Filters.CompareCondition.Equal; col.Add(criteria); PageDataCollection pages = EPiServer.Global.EPDataFactory.FindPagesWithCriteria(Global.EPConfig.RootPage,col);Both end up with no result. Can anyone help?