{"id":11423,"date":"2015-11-13T12:32:20","date_gmt":"2015-11-13T12:32:20","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=11423"},"modified":"2015-11-13T12:32:20","modified_gmt":"2015-11-13T12:32:20","slug":"how-to-alter-view-script-fields-data-entry-size-in-sage-crm","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/11\/13\/how-to-alter-view-script-fields-data-entry-size-in-sage-crm\/","title":{"rendered":"How to alter View Script Field\u2019s Data Entry size in Sage CRM"},"content":{"rendered":"

As we all know, Sage CRM works on SQL views to return records in response to user searches and to present relationships between different entities. For example, a view might list all the cases associated with a particular company that are assigned to a specific user. Creating advanced user-defined views entails administrators employing SQL operations such as Joins, and therefore requires basic SQL scripting skills. These views are also responsible to extract data through Mail Merge activity of CRM. However, many a times user is unable to create\/update a view with a SQL script of huge lines.
\nNew Stuff:\u00a0<\/strong>JavaScript to print Amount (In Words)<\/a>
\nThe View Script Field does not accepts all lines of SQL script therefore leading to SQL error. The first ever thing that would come in any developer\u2019s mind will be to increase field size from backend. But on checking that particular field length in database, there was no option to alter the field size as it was already set as nvarchar (max). Yet making it difficult for me to save the View content.
\nOn exploring many of the forums & blog site, finally I was able to understand the exact issue as well as found a solution for the same. Though the CuVi_ViewScript field<\/strong> length was set as maxlength, the CuVi_ViewScript<\/strong> was liable to accept only 3900 characters in its text area. To remove this restriction you can follow steps as explained below.
\n1. Navigate to Administration | Customization | Translations<\/strong> section.
\n2. Type \u2018Secterr\u2019<\/strong> under Caption Code field and click Find.
\n3. A record with Caption Code \u2018SecTerrColumnsRequiredForPrimaryEntityView\u2019<\/strong> will be listed out.
\n\"Blog<\/a>
\n4. Click on the Caption Code to navigate to the Translation Details screen.
\n5. Add below script under every field of Translation.
\n<script> <\/em>
\n$(document).ready(function () <\/em>
\n{ <\/em>
\n$(‘textarea[name=CuVi_ViewScript]’).removeAttr(“maxLength”); <\/em>
\n}); <\/em>
\n<\/script><\/em>
\n\"Blog<\/a>
\n6. Save the details and execute the Metadata Refresh.
\nHowever, this option will work in Sage CRM v7.2 and v7.3. To apply the same in CRM v7.1 and below, create a js file of the script provided in Step # 5. Call this js file under Translation details screen shown in above screen shot. Once done, you will now be able to modify\/save the view details with 10000 and more no. of SQL Script lines.
\nAlso Read:<\/strong>
\n1. New Tables, Views and Log files introduced in Sage CRM 7.3<\/a>
\n2. You may need to recreate views manually \u2013 II<\/a>
\n3. How to add the Mobile Phone and Private Phone fields to the views being used by Find screens, Reports and Groups<\/a>
\n4. How to access views of Different Database in CRM<\/a>
\n5. You may need to recreate views manually<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

As we all know, Sage CRM works on SQL views to return records in response to user searches and to present relationships between different entities. For example, a view might list all the cases associated with a particular company that are assigned to a specific user. Creating advanced user-defined views entails administrators employing SQL operations\u2026 Read More »<\/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":[332,338,380,1,423,424],"tags":[828,905,1416,2335,2339,2562],"class_list":["post-11423","post","type-post","status-publish","format-standard","hentry","category-sage-crm","category-sage-crm-73","category-sql","category-uncategorized","category-view","category-views","tag-crm-views","tag-cuvi_viewscript","tag-increase-view-field-size","tag-sql-script","tag-sql-view","tag-view-script"],"yoast_head":"\nHow to alter View Script Field\u2019s Data Entry size in Sage CRM - 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\/2015\/11\/13\/how-to-alter-view-script-fields-data-entry-size-in-sage-crm\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to alter View Script Field\u2019s Data Entry size in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"As we all know, Sage CRM works on SQL views to return records in response to user searches and to present relationships between different entities. For example, a view might list all the cases associated with a particular company that are assigned to a specific user. Creating advanced user-defined views entails administrators employing SQL operations\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/11\/13\/how-to-alter-view-script-fields-data-entry-size-in-sage-crm\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2015-11-13T12:32:20+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/11\/Blog-1.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\/2015\/11\/13\/how-to-alter-view-script-fields-data-entry-size-in-sage-crm\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/11\/13\/how-to-alter-view-script-fields-data-entry-size-in-sage-crm\/\",\"name\":\"How to alter View Script Field\u2019s Data Entry size in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/11\/13\/how-to-alter-view-script-fields-data-entry-size-in-sage-crm\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/11\/13\/how-to-alter-view-script-fields-data-entry-size-in-sage-crm\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/11\/Blog-1.jpg\",\"datePublished\":\"2015-11-13T12:32:20+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/11\/13\/how-to-alter-view-script-fields-data-entry-size-in-sage-crm\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/11\/13\/how-to-alter-view-script-fields-data-entry-size-in-sage-crm\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/11\/13\/how-to-alter-view-script-fields-data-entry-size-in-sage-crm\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/11\/Blog-1.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/11\/Blog-1.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/11\/13\/how-to-alter-view-script-fields-data-entry-size-in-sage-crm\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to alter View Script Field\u2019s Data Entry size in Sage CRM\"}]},{\"@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 & 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 alter View Script Field\u2019s Data Entry size in Sage CRM - 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\/2015\/11\/13\/how-to-alter-view-script-fields-data-entry-size-in-sage-crm\/","og_locale":"en_US","og_type":"article","og_title":"How to alter View Script Field\u2019s Data Entry size in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components","og_description":"As we all know, Sage CRM works on SQL views to return records in response to user searches and to present relationships between different entities. For example, a view might list all the cases associated with a particular company that are assigned to a specific user. Creating advanced user-defined views entails administrators employing SQL operations\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/11\/13\/how-to-alter-view-script-fields-data-entry-size-in-sage-crm\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2015-11-13T12:32:20+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/11\/Blog-1.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\/2015\/11\/13\/how-to-alter-view-script-fields-data-entry-size-in-sage-crm\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/11\/13\/how-to-alter-view-script-fields-data-entry-size-in-sage-crm\/","name":"How to alter View Script Field\u2019s Data Entry size in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/11\/13\/how-to-alter-view-script-fields-data-entry-size-in-sage-crm\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/11\/13\/how-to-alter-view-script-fields-data-entry-size-in-sage-crm\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/11\/Blog-1.jpg","datePublished":"2015-11-13T12:32:20+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/11\/13\/how-to-alter-view-script-fields-data-entry-size-in-sage-crm\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/11\/13\/how-to-alter-view-script-fields-data-entry-size-in-sage-crm\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/11\/13\/how-to-alter-view-script-fields-data-entry-size-in-sage-crm\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/11\/Blog-1.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/11\/Blog-1.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/11\/13\/how-to-alter-view-script-fields-data-entry-size-in-sage-crm\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"How to alter View Script Field\u2019s Data Entry size in Sage CRM"}]},{"@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 & 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\/11423","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=11423"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/11423\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=11423"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=11423"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=11423"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}