{"id":2330,"date":"2012-07-13T09:09:41","date_gmt":"2012-07-13T09:09:41","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=2330"},"modified":"2012-07-13T09:09:41","modified_gmt":"2012-07-13T09:09:41","slug":"change-search-select-advanced-field-to-selection-in-self-service","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/07\/13\/change-search-select-advanced-field-to-selection-in-self-service\/","title":{"rendered":"Change Search Select Advanced field to Selection in Self Service"},"content":{"rendered":"

Search Select Advanced is one of the nice to have feature of Sage CRM. It enables you to search the records on the fly, also provides you the find screen for detailed searching of an item we are looking for. However it doesn\u2019t seem to work correctly on the self-service portal. I add SSA field on Case screen in CRM it works great, but if I add the similar field to the selfservice screen the default behaviour seems like lost. Check below screens.
\n\"\"<\/a>
\nSimilar field when added to Self-service screen it looks like below but dies not work.
\n\"\"<\/a>
\nSo\u00a0if you have comparatively less number of items, a better option is to replace the field with Selection field at runtime. Below is the basic approach you can take to do the same.
\n1. Make the field readonly.
\n\u00a0\u00a0\u00a0\u00a0 var EProduct = BlockObj.GetEntry(‘case_product’);
\n\u00a0\u00a0\u00a0\u00a0 EProduct.ReadOnly = true;
\n2. Create HTML for selection.
\n\u00a0\u00a0\u00a0\u00a0\u00a0var ssaHtml = ‘<select size=”1″ name=” case_product ” id=”case_product”>’;<\/em>
\n\u00a0\u00a0\u00a0\u00a0\u00a0ProdSql = ” SELECT prod_name, prod_id FROM Products (nolock) “;<\/em>
\n\u00a0\u00a0\u00a0\u00a0\u00a0ProdSql += ” WHERE prod_deleted IS NULL “;<\/em>
\n\u00a0\u00a0\u00a0\u00a0\u00a0recVals = eWare.CreateQueryObj(ProdSql);<\/em>
\n\u00a0\u00a0\u00a0\u00a0\u00a0recVals.SelectSql();<\/em>
\n\u00a0\u00a0\u00a0\u00a0\u00a0var foundSelected = false;<\/em>
\n\u00a0\u00a0\u00a0\u00a0\u00a0while (!recVals.eof)\u00a0<\/em>
\n\u00a0\u00a0\u00a0\u00a0\u00a0{<\/em>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0ssaHtml += ‘<option value=”‘ + recVals(“prod_id”) + ‘”>’ + recVals(“prod_name”) + ‘<\/option>’;<\/em>
\n\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0recVals.NextRecord();<\/em>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}<\/em>
\n\u00a0<\/em>\u00a0\u00a0\u00a0\u00a0\u00a0ssaHtml += ‘<option value=”” ‘ + (foundSelected ? ” : ‘selected=”selected”‘) + ‘>–None–<\/option>’;<\/em>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0ssaHtml += ‘<\/select>’;<\/em>
\n\u00a0
\n3. Add HTML to field caption \u00a0
\n\u00a0\u00a0\u00a0\u00a0 EProduct.Caption = eWare.GetTrans(“ColNames”, “ case_product<\/em> “) + ‘:<br \/>’ + ssaHtml;
\nAs we are using standard field names here Self service screen saves data correctly in the corresponding table.<\/p>\n","protected":false},"excerpt":{"rendered":"

Search Select Advanced is one of the nice to have feature of Sage CRM. It enables you to search the records on the fly, also provides you the find screen for detailed searching of an item we are looking for. However it doesn\u2019t seem to work correctly on the self-service portal. I add SSA field\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[332,354,358],"tags":[],"class_list":["post-2330","post","type-post","status-publish","format-standard","hentry","category-sage-crm","category-search-select-advanced","category-self-service-sage-crm"],"yoast_head":"\nChange Search Select Advanced field to Selection in Self Service - 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\/2012\/07\/13\/change-search-select-advanced-field-to-selection-in-self-service\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Change Search Select Advanced field to Selection in Self Service - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Search Select Advanced is one of the nice to have feature of Sage CRM. It enables you to search the records on the fly, also provides you the find screen for detailed searching of an item we are looking for. However it doesn\u2019t seem to work correctly on the self-service portal. I add SSA field\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/07\/13\/change-search-select-advanced-field-to-selection-in-self-service\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2012-07-13T09:09:41+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/07\/Screen1.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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/07\/13\/change-search-select-advanced-field-to-selection-in-self-service\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/07\/13\/change-search-select-advanced-field-to-selection-in-self-service\/\",\"name\":\"Change Search Select Advanced field to Selection in Self Service - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/07\/13\/change-search-select-advanced-field-to-selection-in-self-service\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/07\/13\/change-search-select-advanced-field-to-selection-in-self-service\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/07\/Screen1.jpg\",\"datePublished\":\"2012-07-13T09:09:41+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/07\/13\/change-search-select-advanced-field-to-selection-in-self-service\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/07\/13\/change-search-select-advanced-field-to-selection-in-self-service\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/07\/13\/change-search-select-advanced-field-to-selection-in-self-service\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/07\/Screen1.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/07\/Screen1.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/07\/13\/change-search-select-advanced-field-to-selection-in-self-service\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Change Search Select Advanced field to Selection in Self Service\"}]},{\"@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":"Change Search Select Advanced field to Selection in Self Service - 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\/2012\/07\/13\/change-search-select-advanced-field-to-selection-in-self-service\/","og_locale":"en_US","og_type":"article","og_title":"Change Search Select Advanced field to Selection in Self Service - Sage CRM \u2013 Tips, Tricks and Components","og_description":"Search Select Advanced is one of the nice to have feature of Sage CRM. It enables you to search the records on the fly, also provides you the find screen for detailed searching of an item we are looking for. However it doesn\u2019t seem to work correctly on the self-service portal. I add SSA field\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/07\/13\/change-search-select-advanced-field-to-selection-in-self-service\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2012-07-13T09:09:41+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/07\/Screen1.jpg","type":"","width":"","height":""}],"author":"greysagecrm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagecrm","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/07\/13\/change-search-select-advanced-field-to-selection-in-self-service\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/07\/13\/change-search-select-advanced-field-to-selection-in-self-service\/","name":"Change Search Select Advanced field to Selection in Self Service - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/07\/13\/change-search-select-advanced-field-to-selection-in-self-service\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/07\/13\/change-search-select-advanced-field-to-selection-in-self-service\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/07\/Screen1.jpg","datePublished":"2012-07-13T09:09:41+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/07\/13\/change-search-select-advanced-field-to-selection-in-self-service\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/07\/13\/change-search-select-advanced-field-to-selection-in-self-service\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/07\/13\/change-search-select-advanced-field-to-selection-in-self-service\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/07\/Screen1.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/07\/Screen1.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/07\/13\/change-search-select-advanced-field-to-selection-in-self-service\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Change Search Select Advanced field to Selection in Self Service"}]},{"@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\/2330","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=2330"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/2330\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=2330"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=2330"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=2330"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}