https://accelerator.crmtogether.com/index.php?action=history&feed=atom&title=Shared_Documents 2026-05-26T23:23:37Z Revision history for this page on the wiki MediaWiki 1.40.0 https://accelerator.crmtogether.com/index.php?title=Shared_Documents&diff=1332&oldid=prev 2020-09-17T15:54:40Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 16:54, 17 September 2020</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l13">Line 13:</td> <td colspan="2" class="diff-lineno">Line 13:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>     #languagefilter# is used to filter based on users language</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>     #languagefilter# is used to filter based on users language</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>     &lt;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' <del style="font-weight: bold; text-decoration: none;">and libr_entity is null </del>and Libr_Mergetemplate='N' and Libr_Type !='TargetListExport' and libr_filename not like '%.csv%'"/&gt;</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>     &lt;add key="GlobalDocumentsSQL" value="select libr_libraryid,Libr_Type, Libr_Category,  </div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>Libr_FilePath, Libr_FileName, Libr_Note, Libr_Status from library where libr_active='Y' and  </div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>libr_deleted is null and libr_global='Y' and (libr_language is null or libr_language = '#languagefilter#')</div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> </ins>and libr_status='Final' and Libr_Mergetemplate='N' and</div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> </ins>Libr_Type !='TargetListExport' and libr_filename not like '%.csv%'"/&gt;</div></td></tr> </table>

Sagecrmw https://accelerator.crmtogether.com/index.php?title=Shared_Documents&diff=1327&oldid=prev 2020-09-09T09:56:06Z

<p>Created page with &quot;This screen is available from the new Email window. Click on the &quot;Shared Documents&quot; to how the screen <a href="/index.php?title=File:Shareddocuments.jpg" title="File:Shareddocuments.jpg">File:shareddocuments.jpg</a> ---- The SQL can be configured via the...&quot;</p> <p><b>New page</b></p><div>This screen is available from the new Email window.<br /> <br /> Click on the &quot;Shared Documents&quot; to how the screen<br /> <br /> [[File:shareddocuments.jpg]]<br /> <br /> <br /> <br /> ----<br /> The SQL can be configured via the web.config<br /> <br /> SQL used to get the documents list for the user<br /> #languagefilter# is used to filter based on users language<br /> <br /> &lt;add key=&quot;GlobalDocumentsSQL&quot; value=&quot;select libr_libraryid,Libr_Type, Libr_Category, Libr_FilePath, Libr_FileName, Libr_Note, Libr_Status from library where libr_active=&#039;Y&#039; and libr_deleted is null and libr_global=&#039;Y&#039; and (libr_language is null or libr_language = &#039;#languagefilter#&#039;) and libr_status=&#039;Final&#039; and libr_entity is null and Libr_Mergetemplate=&#039;N&#039; and Libr_Type !=&#039;TargetListExport&#039; and libr_filename not like &#039;%.csv%&#039;&quot;/&gt;</div>

Sagecrmw