When you search for big amounts of entities, a SQL TimeOut exception can occur. To minimize the amount of data, you can specify additional filtering in the PowerSearch Configuration (This filter must be manually inserted into the XML of the PowerSearch Config).

To specify additional filtering, navigate to CRM > Settings > MSCRM-ADDONS.com Products > PowerSearch > MSCRM-ADDONS.com Settingkeys > ServerConfig. 

Figure 1: PowerSearch Settings

Edit the KeyValue as described in Figure 2 and below.  

Figure 2: Edit Key-Value

Between the tags of the entity you are planning to filter, add a tag. Inside of the  you can fill in your filter condition. (These are the same filter condition as in CRM.)

Example: (Show only mails from the last 10 weeks): 

<email>
    <searchfields>subject,description,regardingobjectid,torecipients,sender</searchfields>
    <resultfields>subject,regardingobjectid,torecipients,sender</resultfields>
    <activestate>1</activestate>
    <collapseonrow></collapseonrow>
    <sortorder></sortorder>
    <additionalfilter><![CDATA[<filter type="and"><condition attribute="createdon" operator="last-x-weeks" value="10">]]></condition></additionalfilter>
</email>

Finally click on the [Save]-button at the PowerSearch Settingskey to save your new filter on the entity.

Please note:

If you want to create your own filter conditions easier, you can create the filter in the CRM Advanced Find and click on the [Download Fetch XML]-button.

Simply copy the filter condition inside the so received XML-file and paste it into the additional filter of the PowerSearch Config entity.

Figure 3: CRM Advanced Find

That’s it! We appreciate your feedback! Please share your thoughts by sending an email to support@mscrm-addons.com.