Shared Documents

From Accelerator for SageCRM
Revision as of 09:56, 9 September 2020 by Sagecrmw (talk | contribs) (Created page with "This screen is available from the new Email window. Click on the "Shared Documents" to how the screen File:shareddocuments.jpg ---- The SQL can be configured via the...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

This screen is available from the new Email window.

Click on the "Shared Documents" to how the screen



The SQL can be configured via the web.config

   SQL used to get the documents list for the user
   #languagefilter# is used to filter based on users language
   <add key="GlobalDocumentsSQL" value="select libr_libraryid,Libr_Type, Libr_Category, Libr_FilePath, Libr_FileName, Libr_Note, Libr_Status from library where libr_active='Y' and libr_deleted is null and libr_global='Y' and (libr_language is null or libr_language = '#languagefilter#') and libr_status='Final' and libr_entity is null and Libr_Mergetemplate='N' and Libr_Type !='TargetListExport' and libr_filename not like '%.csv%'"/>