SharePoint Search API
2 TopicsMulti Select Person or Group as filter in custom vertical is not parsed as single value in MS Search
I've created a custom search vertical under Microsoft Search settings in a modern SharePoint Online site collection. There are couple of fields which are multi select Managed Metadata and Person or Group fields. The data is stored in them in the format which is given as follows: Company (Managed Metadata) - ABC Inc; XYZ Pvt Ltd Author (Person or Group) - User1;User2 (display names) The above 2 fields are used as filters and the respective RefinableString managed properties are used with corresponding crawled properties. Company - OWS_Company (managed metadata), OWS_Company2 (lookup), OWS_CompanyName (multiple lines of text) Author - OWS_Author When we try to filter the search results, the available options in the dropdown are shown in the format that is stored in the library instead of showing single values for the person or group column and it displays correct values (single values) for the managed metadata field. Current Format Company ABC Inc XYZ PVt Ltd Author User1;User2 Desired Format Company ABC Inc XYZ PVt Ltd Author User1 User2 The Company field's (managed metadata) managed property has 3 fields crawled properties mapped to it of type Managed Metadata, Lookup and Multiple lines of text whereas the Author (person or group) field only has one crawled property of type person or group. Based on PnP Community support and a related reddit thread, this is a search API issue for which the fix has been rolled out few months back but we are currently still seeing this issue. Any thoughts or ideas on how to resolve this? https://github.com/microsoft-search/pnp-modern-search/issues/2096 https://www.reddit.com/r/sharepoint/comments/uvv3vw/sharepoint_online_multiuser_refinement_tokens_too/779Views0likes0CommentsSharePoint Pagination using Index Doc Id does not allow sorting on Created on columns
Hi All, We are using SharePoint Search API to get the items from SharePoint List. We have a large dataset so we are following the below approach for pagination as mentioned in the MS Documentation below. https://docs.microsoft.com/en-us/sharepoint/dev/general-development/pagination-for-large-result-sets It is sorting on DocId. But we also have to sort based on the created on Date, I am using below API. API: https://site/_api/search/query?querytext='test ListId:0ae14d29 indexdocid >10'&sortlist='refinabledate00:descending,[docid]:ascending'&rowlimit=10 but when I try to get results for page 2 it is not giving me the correct result. It gives the same set of records as on page 1. If I retrieve records without createdOn sorting I am getting correct records but we want sorting based on date as well.892Views0likes0Comments