The query could not be executed. Please be more specific.

Applies to: SharePoint List Filter Web Part for SharePoint on premise (SP2010, SP2013, SP2016, SP2019)


If you use our List Filter Web Part to search and filter large document libraries and you search for a frequently used keyword you may receive the following error message:

Error: The query could not be executed. Please be more specific.

Out Of Memory Exception
If you are experiencing this issue, please download the latest version, run the setup and choose repair.

This issue has now been fixed in the version released on 01/07/14.

File Version of Sapiens.at.SharePoint.dll

SP2010: 14.0.14.0107

SP2013: 15.0.14.0107

If you are using SharePoint 2010 you must also add a new managed property to your search application. If you are using SharePoint 2013 this is not necessary.

To create a new managed property, open your Search Application in the Central Administration and click on Metadata Properties.

Managed Properties
Then click on New Managed Property.

New Managed Properties
Enter the name ListItemID (case-sensitive) and select Integer as the type of information.

ListItemID
Then click on Add Mapping, look for ows_id and select it.

Mapping

Confirm with OK.

After you have added the property, you must run a full crawl.

After the full crawl has been completed, the error should disappear.

If the error still occurs, make sure the “Max. size for Search Results (rows)”, which can be set in the web part configuration, is not too high. This value should be between 500 and 10,000. If the number of items returned exceeds the configured limit, a message will be appear on the screen. The message is “Warning: Searching for ‘keyword’ returned more than n items. Please use more specific keywords or operators (AND, …) in your query.”.