Forum Discussion
SIL-ChristianDias
Oct 29, 2021Copper Contributor
Result search query to exclude items without values in a managed property
Hi all, I am trying to configure a PnP Search Results WebPart to show all recently modified site pages that contain a value in a managed property, any value that isn't blank. For context, this...
Gurdev Singh
Jul 25, 2022Iron Contributor
Did you manage to find a solution for this?
SIL-ChristianDias
Aug 16, 2022Copper Contributor
Hi Gurdev,
I managed to find out that my query is achievable by configuring the following in the PnP Search Results WebPart:
- Available data sources
- Layout slots
- SharePoint Search
- Query template:
- {inputQueryText} path:https://saffroninteractive.sharepoint.com/sites/wiki/
- Result source ID:
- ItemsMatchingTag
- Selected properties:
- RefinableString00
- ModifiedBy
- ModifiedById
- LastModifiedTime
- Sort order
- Field name:
- Last ModifiedTime
- Direction:
- Descending
- Field name:
- Refinement filters:
- FileType:aspx
- Enable query rules
- On
- Enable localization
- On
- Query template:
- Available connections
- Use input query text
- Static value
- Query text
- {|RefinableString00:{Page.WikiCategory}}
- Query text
- Static value
- Use input query text
With some visual tweaking this is the result: