London Dev Meetup Rescheduled! Due to unavoidable reasons, the event has been moved to 21st May. Speakers remain the same—any changes will be communicated. Seats are limited—register here to secure your spot!

Search FindPagesWithCriteria FindAllPagesWithCriteria

Vote:
 

Hi

I need to search for certain Pages with a PageReference-Property set to a published page on a multisite-, multilanguage-environment with CMS5 R2 Sp2, but when I use FindPagesWithCriteria I only get pages which are published. So I tried with FindAllPagesWithCriteria but with the same results, I also added the criteria PagePendingPublish (since that worked in 4.62) but still can't retrieve unpublished pages.

Any ideas on how I can search for pages which are not published?

#37468
Mar 08, 2010 11:01
Vote:
 

There is no way of searching in properties that have not been published (since those are stored in separate versioning tables in the database until you hit Publish).

 

#37472
Mar 08, 2010 13:50
Vote:
 

Oh, but is there a way to work around this by searching directly in the database?

#37473
Mar 08, 2010 14:16
Vote:
 

You could access tblWorkProperty directly, but just remember that it is unsupported and not recommended since it may stop working in a future upgrade if we make changes to the schema. Your first option should be to find another way of solving the problem in hand.

#37479
Mar 08, 2010 16:20
Vote:
 

Yes, I solved it with setting startpublish and stoppublish to DateTime.Now and then it was possible to find them.
Thank you for your answer!

#37480
Mar 08, 2010 16:22
This topic was created over six months ago and has been resolved. If you have a similar question, please create a new topic and refer to this one.
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.