Outlook Search Results Tab

From Accelerator for SageCRM
Revision as of 18:06, 22 February 2017 by Sagecrmw (talk | contribs)

Within the main search results tab you can now search for an entity or use your bookmarks.

This allows you to save any email against any existing record. This is useful in the case where a colleague is assisting on an item and you wish to save the email against a customer. Typically if you do this it is recommended that you then tag the email.


To view the record from the grid just double click on the line item. This will then open the "Details" tab and show you the entity page.


Example on searching for an entity, tagging and filing an email

Select the Entity to search on (Lead in this example)

File:Selectlead2.png

Type in some search criteria and click Go

File:Searchandgo2.png

Double click on the lead in the list

File:Taglead1.png

This displays the lead. Tag the email (optionally)

File:Saveemaillead1.png

Save the email then as required.




All values in "entity_listfields" will display in the grid now.

-you must also set the "entity_DataTableFields" also

EG

 <add key="company_DataTableFields" value="comp_name,comp_website"/>
  • Pre Jun 2015 (v 4.3)

If you wish to customise the column that appears in the list (say to show a Sage 300 link field) the instructions are as follows:

In the web.config file (in custompages/sagecrmws)

You need to add in the following (bold text) to the company_selectsql key

<add key="company_selectsql" value="select (rtrim(comp_name) + ' '+rtrim(isnull(comp_somefieldname,))) as 'Company',* from vCompany where comp_name like '#searchsql#%' and comp_deleted is null"/>

In your case change the 'comp_somefieldname' to be the field you want displayed with the name

And company_listfields key

<add key="company_listfields" value="Company,Comp_WebSite"/>

and

               <add key="company_DataTableFields" value="comp_name,comp_website"/>

Users may need to restart Outlook.

The downside here though is that the CRM security is no longer used in this search. This may or may not be an issue depending on the implementation.