I have a people node which consists of 3500 people. Out of 3500 people 2600 items are marked as NeverPublished=True
. So in Web database I have only 900 items.
i want a fast query on master database which return all the items whether published or not published.
I used the following fast query
fast:/sitecore/content/Home/People//*[@@templateid='{AECD90BE-9289-4F7F-AA26-6C5ED88B6E65}']
When I am executing this fast query in Sitecore XPath window, it is returning 3500 item.
But when I am executing the same query from C# code, it is only returning 900 item. I have checked the max item setting, it is set to 0 i.e. no limit on result count
I have checked the Context Database, it is master. I have hard coded the database to master, then again getting same response.
I tried using the SQL Table approach, i.e getting all item id from SQL Table then using sitecore api fetching each item. This time again, sitecore api is returning null for NonPublishble Item.