{"id":13979,"date":"2017-03-16T07:40:51","date_gmt":"2017-03-16T07:40:51","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=13979"},"modified":"2024-05-03T07:17:13","modified_gmt":"2024-05-03T07:17:13","slug":"how-to-make-document-visible-for-all-users","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/03\/16\/how-to-make-document-visible-for-all-users\/","title":{"rendered":"How to Make Document Visible for All Users"},"content":{"rendered":"<p style=\"text-align: justify;\">As you all know <a href=\"http:\/\/www.sagesoftware.co.in\/product-sage-crm\" target=\"_blank\" rel=\"noopener\">Sage CRM<\/a> comes with bundle of standard functionalities which fulfill user requirements such as Email, SMS, Reports and documents etc. By default CRM put some restrictions on this functionalities like while merging a document against any entity we need to fill some details on screen, and based on that details document will be merged and visible to selected user only not to all users. How can we make document visible for all users?<\/p>\n<p><span style=\"color: #993300;\"><strong><em>New Stuff:<\/em><\/strong> <a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/03\/16\/highlight-specific-rows-in-grid-based-on-condition-using-javascript\/\" target=\"_blank\" rel=\"noopener\"><span style=\"color: #000000;\">Highlight Specific Rows in Grid based on condition Using JavaScript<\/span><\/a><\/span><\/p>\n<p style=\"text-align: justify;\">As shown in below screenshot username is selected in <strong>\u201cOwner\u201d <\/strong>field this specifies that the Shared Template\/document will be visible to only this user. To make it visible for all the users we have to execute SQL query as provided below.<\/p>\n<p><a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2017\/03\/Img1.jpg\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-13981\" src=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2017\/03\/Img1.jpg\" alt=\"\" width=\"965\" height=\"285\" \/><\/a><br \/>\n<strong>Step 1: Execute this query on CRM database to view the record entry.<\/strong><\/p>\n<ul>\n<li>select libr_private, libr_global,Libr_FileName,* from library(nolock) where libr_deleted is null<\/li>\n<\/ul>\n<p style=\"padding-left: 30px;\">\u00a0\u00a0 and Libr_Entity=\u201d<strong>Entity Name<\/strong>\u201d and Libr_FileName=\u201d<strong>File Name<\/strong>\u201d <strong>(Here you have to mention the file\/document name)<\/strong><\/p>\n<p><strong>Step 2: Execute the Update query<\/strong><\/p>\n<ul>\n<li>update library set libr_private=null where where libr_deleted is null<\/li>\n<\/ul>\n<p style=\"padding-left: 30px;\">\u00a0\u00a0 and Libr_Entity=\u201d<strong>Entity Name<\/strong>\u201d and Libr_FileName=\u201d<strong>File Name<\/strong>\u201d <strong>(Here you have to mention the file\/document name)<\/strong><\/p>\n<p><strong>Step 3: Execute Metadata Refresh and login again.<\/strong><\/p>\n<p><strong>About Us<\/strong><\/p>\n<p style=\"text-align: justify;\"><a href=\"http:\/\/www.greytrix.com\/\">Greytrix<\/a> is one stop solution provider for Sage ERP and Sage CRM needs. We provide complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.<\/p>\n<p style=\"text-align: justify;\"><a href=\"http:\/\/www.greytrix.com\/\">Greytrix<\/a>\u00a0has some unique integration solutions for Sage CRM with Sage ERP\u2019s (<a href=\"http:\/\/www.greytrix.com\/product\/sage-crm\/gumu-sage-x3-integration\">Sage X3<\/a>,\u00a0<a href=\"http:\/\/www.greytrix.com\/product\/sage-crm\/gumu-sage-100-erp-integration\">Sage 100<\/a>,\u00a0<a href=\"http:\/\/www.greytrix.com\/product\/sage-crm\/gumu-sage-300-erp-integration\">Sage 300<\/a>,\u00a0<a href=\"http:\/\/www.greytrix.com\/product\/sage-crm\/gumu-sage-500-erp-integration\">Sage 500\u00a0<\/a>and\u00a0Sage 50). It also offers best-in-class\u00a0Sage ERP customization and development services\u00a0to\u00a0Business\u00a0Partners,\u00a0End\u00a0Users and Sage PSG worldwide. Greytrix\u00a0helps in\u00a0migrating to <a href=\"http:\/\/www.greytrix.com\/product\/sage-crm\/act-sage-crm-migration\">Sage CRM from ACT<\/a>,\u00a0<a href=\"http:\/\/www.greytrix.com\/product\/sage-crm\/goldmine-sage-crm-migration\">Goldmine<\/a>\u00a0and other CRM\u2019s.<\/p>\n<p style=\"text-align: justify;\">For more information on our integration solutions, please contact us at\u00a0<a href=\"mailto:sage@greytrix.com\">sage@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n<p><span style=\"color: #993300;\"><em><strong>Also Read:<\/strong> <\/em><\/span><\/p>\n<p style=\"padding-left: 30px;\"><strong>1.<\/strong> <a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/01\/21\/library-folder-in-sage-crm\/\" target=\"_blank\" rel=\"noopener\">Library folder in Sage CRM<\/a><br \/>\n<strong>2.<\/strong> <a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/08\/how-library-documents-are-stored\/\" target=\"_blank\" rel=\"noopener\">How Library documents are stored<\/a><br \/>\n<strong>3.<\/strong> <a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/02\/15\/configure-the-library-for-secondary-entities-in-crm\/\" target=\"_blank\" rel=\"noopener\">Configure the Library for Secondary entities in CRM<\/a><br \/>\n<strong>4.<\/strong> <a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/07\/30\/workflow-tip-to-set-document-type-and-category\/\" target=\"_blank\" rel=\"noopener\">Workflow Tip to set Document Type and Category<\/a><br \/>\n<strong>5.<\/strong> <a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/28\/create-document-template-in-sage-crm-7-1-sp2-and-sagecrm-7-2\/\" target=\"_blank\" rel=\"noopener\">Create Document Template in Sage CRM 7.1 SP2 and SageCRM 7.2<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>As you all know Sage CRM comes with bundle of standard functionalities which fulfill user requirements such as Email, SMS, Reports and documents etc. By default CRM put some restrictions on this functionalities like while merging a document against any entity we need to fill some details on screen, and based on that details document\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/03\/16\/how-to-make-document-visible-for-all-users\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[30,31,122,123,126,332,352,380,1],"tags":[998,1367,2334],"class_list":["post-13979","post","type-post","status-publish","format-standard","hentry","category-attachment","category-attachments","category-document-sage-crm","category-document-drop-sage-crm","category-download","category-sage-crm","category-script","category-sql","category-uncategorized","tag-documents-access-in-sage-crm","tag-how-to-make-document-visible-for-all-users","tag-sql-queries-for-documents-visibility-in-sage-crm"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Make Document Visible for All Users - Sage CRM \u2013 Tips, Tricks and Components<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/03\/16\/how-to-make-document-visible-for-all-users\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Make Document Visible for All Users - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"As you all know Sage CRM comes with bundle of standard functionalities which fulfill user requirements such as Email, SMS, Reports and documents etc. By default CRM put some restrictions on this functionalities like while merging a document against any entity we need to fill some details on screen, and based on that details document\u2026 Read More &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/03\/16\/how-to-make-document-visible-for-all-users\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2017-03-16T07:40:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-03T07:17:13+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2017\/03\/Img1.jpg\" \/>\n<meta name=\"author\" content=\"greysagecrm\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagecrm\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/03\/16\/how-to-make-document-visible-for-all-users\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/03\/16\/how-to-make-document-visible-for-all-users\/\",\"name\":\"How to Make Document Visible for All Users - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/03\/16\/how-to-make-document-visible-for-all-users\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/03\/16\/how-to-make-document-visible-for-all-users\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2017\/03\/Img1.jpg\",\"datePublished\":\"2017-03-16T07:40:51+00:00\",\"dateModified\":\"2024-05-03T07:17:13+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/03\/16\/how-to-make-document-visible-for-all-users\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/03\/16\/how-to-make-document-visible-for-all-users\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/03\/16\/how-to-make-document-visible-for-all-users\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2017\/03\/Img1.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2017\/03\/Img1.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/03\/16\/how-to-make-document-visible-for-all-users\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Make Document Visible for All Users\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\",\"name\":\"Sage CRM \u2013 Tips, Tricks and Components\",\"description\":\"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips &amp; tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\",\"name\":\"greysagecrm\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"greysagecrm\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Make Document Visible for All Users - Sage CRM \u2013 Tips, Tricks and Components","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/03\/16\/how-to-make-document-visible-for-all-users\/","og_locale":"en_US","og_type":"article","og_title":"How to Make Document Visible for All Users - Sage CRM \u2013 Tips, Tricks and Components","og_description":"As you all know Sage CRM comes with bundle of standard functionalities which fulfill user requirements such as Email, SMS, Reports and documents etc. By default CRM put some restrictions on this functionalities like while merging a document against any entity we need to fill some details on screen, and based on that details document\u2026 Read More &raquo;","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/03\/16\/how-to-make-document-visible-for-all-users\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2017-03-16T07:40:51+00:00","article_modified_time":"2024-05-03T07:17:13+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2017\/03\/Img1.jpg","type":"","width":"","height":""}],"author":"greysagecrm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagecrm","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/03\/16\/how-to-make-document-visible-for-all-users\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/03\/16\/how-to-make-document-visible-for-all-users\/","name":"How to Make Document Visible for All Users - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/03\/16\/how-to-make-document-visible-for-all-users\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/03\/16\/how-to-make-document-visible-for-all-users\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2017\/03\/Img1.jpg","datePublished":"2017-03-16T07:40:51+00:00","dateModified":"2024-05-03T07:17:13+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/03\/16\/how-to-make-document-visible-for-all-users\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/03\/16\/how-to-make-document-visible-for-all-users\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/03\/16\/how-to-make-document-visible-for-all-users\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2017\/03\/Img1.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2017\/03\/Img1.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/03\/16\/how-to-make-document-visible-for-all-users\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"How to Make Document Visible for All Users"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/","name":"Sage CRM \u2013 Tips, Tricks and Components","description":"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips &amp; tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f","name":"greysagecrm","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"greysagecrm"},"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/13979","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/comments?post=13979"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/13979\/revisions"}],"predecessor-version":[{"id":28227,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/13979\/revisions\/28227"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=13979"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=13979"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=13979"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}