SharePoint Keyword Query Search In SharePoint 2013

Question

I want to get all pages from pages library from search result where page layout name is "abc.aspx". I have tried below code but it is not working. If I simply pass "abc" in querytext then it will get result from list,library and from every where. I want to get only those pages whose page layout is "abc.aspx". How to do that?

string pageLayoutFullName="abc.aspx"
  KeywordQuery keywordQueryTop = new KeywordQuery(site);
  keywordQueryTop.SelectProperties.Add("Title");
  keywordQueryTop.SelectProperties.Add("PublishingPageLayoutOWSURLH");
  keywordQueryTop.SelectProperties.Add("WebId");
  keywordQueryTop.SelectProperties.Add("ModifiedOWSDATE");
  keywordQueryTop.RowLimit = 15;
  keywordQueryTop.ResultsProvider = SearchProvider.SharepointSearch;
  keywordQueryTop.QueryText = String.Format("PublishingPageLayoutOWSURLH=\"*{0}\"", pageLayoutFullName);

Answer 1

The problem you have is because SharePoint search does not support suffix-matching (*omething), only prefix-matching (somethin*). Therefore this row will not work

keywordQueryTop.QueryText = String.Format("PublishingPageLayoutOWSURLH=\"*{0}\"", pageLayoutFullName);

Are the pages from only one site collection? Then you can use the full path http://portal.com/_catalogs/masterpage/PageLayoutFileName.aspx, PageLayoutName.

If not, it seems more difficult!

There is a crawled property named "ows_PublishingPageLayout", try mapping that one up to a new Managed Property, perform a full crawl and see what you get from that property (you can use the REST API in the browser to test it:

http://portal.com/_api/search/query?querytext='*'&selectproperties='PublishingPageLayout'

Update

Unfortunately, this property also indexes the URL, not the name:

<d:Key>PublishingPageLayout</d:Key> 
<d:Value>http://portal.com/_catalogs/masterpage/PageLayoutFileName.aspx</d:Value> 

which is not helpful for you. I find no other properties that seems to be useful, so you might be out of luck I'm afraid (if the specific Page Layout does not use a specific custom content type).