{"id":169,"date":"2009-07-18T13:13:00","date_gmt":"2009-07-18T13:13:00","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=169"},"modified":"2009-07-18T13:13:00","modified_gmt":"2009-07-18T13:13:00","slug":"search-select-advance-functionality","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/18\/search-select-advance-functionality\/","title":{"rendered":"Search Select Advance Functionality"},"content":{"rendered":"

Consider a scenario when there is a relation between 3 fields like Company, person and opportunity.<\/p>\n

Now in SageCRM, we need to display the values in that dropdown fields. There can be 2ways to achieve this:<\/p>\n

1. By using SSA field of standard CRM functionality.
2. By using selection list and fill it run time using server side + client side script.<\/p>\n

The disadvantage of using second option would be time to fill dropdown would be too much when the values in those fields would be greater than 100. So the best option would be to use SSA field in such case to slow down speed.<\/p>\n

Steps to maintain structure in CRM\/SQL tables:
1. In order to display values in the above SSA field, create a custom entity and feed the values in that custom entity.
2. For displaying values in view mode make an entry in custom captions so that you can see caption in view mode instead of code.
3. Maintain the field name structure in CRM as shown below:<\/p>\n

Entity Name: Company
Field Name: comp_companyid,comp_name<\/p>\n

Entity Name: Person
Field Name: Pers_personid,pers_companyid,pers_name<\/p>\n

Entity Name: Opportunity
Field Name: Oppo_opportunityid,oppo_companyid,oppo_personid<\/p>\n

After creating entities you can make an entry in translation in order to display values in SSA field from custom entity.<\/p>\n

By following the above mentioned procedure you can display values in company, person and opportunity by selecting value from company field then their corresponding person and opportunity would be displayed.
Screen Shot:
<\/a>
\"\"<\/a><\/p>\n

If you find this content useful, Please drop us an email at crm@greytrix.com<\/a>. <\/b><\/marquee><\/p>\n","protected":false},"excerpt":{"rendered":"

Consider a scenario when there is a relation between 3 fields like Company, person and opportunity. Now in SageCRM, we need to display the values in that dropdown fields. There can be 2ways to achieve this: 1. By using SSA field of standard CRM functionality.2. By using selection list and fill it run time using\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":[1],"tags":[2244,2340,2471],"class_list":["post-169","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-search-select-advance","tag-ssa","tag-tricks"],"yoast_head":"\nSearch Select Advance Functionality - 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\/2009\/07\/18\/search-select-advance-functionality\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Search Select Advance Functionality - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Consider a scenario when there is a relation between 3 fields like Company, person and opportunity. Now in SageCRM, we need to display the values in that dropdown fields. There can be 2ways to achieve this: 1. By using SSA field of standard CRM functionality.2. By using selection list and fill it run time using\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/18\/search-select-advance-functionality\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2009-07-18T13:13:00+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/1.bp.blogspot.com\/_A6_b0zkYeSY\/SmQF66oDCSI\/AAAAAAAAAeY\/XsgcbtubK8Y\/s400\/GT_Component1.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\/2009\/07\/18\/search-select-advance-functionality\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/18\/search-select-advance-functionality\/\",\"name\":\"Search Select Advance Functionality - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/18\/search-select-advance-functionality\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/18\/search-select-advance-functionality\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/1.bp.blogspot.com\/_A6_b0zkYeSY\/SmQF66oDCSI\/AAAAAAAAAeY\/XsgcbtubK8Y\/s400\/GT_Component1.JPG\",\"datePublished\":\"2009-07-18T13:13:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/18\/search-select-advance-functionality\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/18\/search-select-advance-functionality\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/18\/search-select-advance-functionality\/#primaryimage\",\"url\":\"http:\/\/1.bp.blogspot.com\/_A6_b0zkYeSY\/SmQF66oDCSI\/AAAAAAAAAeY\/XsgcbtubK8Y\/s400\/GT_Component1.JPG\",\"contentUrl\":\"http:\/\/1.bp.blogspot.com\/_A6_b0zkYeSY\/SmQF66oDCSI\/AAAAAAAAAeY\/XsgcbtubK8Y\/s400\/GT_Component1.JPG\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/18\/search-select-advance-functionality\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Search Select Advance Functionality\"}]},{\"@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":"Search Select Advance Functionality - 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\/2009\/07\/18\/search-select-advance-functionality\/","og_locale":"en_US","og_type":"article","og_title":"Search Select Advance Functionality - Sage CRM \u2013 Tips, Tricks and Components","og_description":"Consider a scenario when there is a relation between 3 fields like Company, person and opportunity. Now in SageCRM, we need to display the values in that dropdown fields. There can be 2ways to achieve this: 1. By using SSA field of standard CRM functionality.2. By using selection list and fill it run time using\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/18\/search-select-advance-functionality\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2009-07-18T13:13:00+00:00","og_image":[{"url":"http:\/\/1.bp.blogspot.com\/_A6_b0zkYeSY\/SmQF66oDCSI\/AAAAAAAAAeY\/XsgcbtubK8Y\/s400\/GT_Component1.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\/2009\/07\/18\/search-select-advance-functionality\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/18\/search-select-advance-functionality\/","name":"Search Select Advance Functionality - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/18\/search-select-advance-functionality\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/18\/search-select-advance-functionality\/#primaryimage"},"thumbnailUrl":"http:\/\/1.bp.blogspot.com\/_A6_b0zkYeSY\/SmQF66oDCSI\/AAAAAAAAAeY\/XsgcbtubK8Y\/s400\/GT_Component1.JPG","datePublished":"2009-07-18T13:13:00+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/18\/search-select-advance-functionality\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/18\/search-select-advance-functionality\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/18\/search-select-advance-functionality\/#primaryimage","url":"http:\/\/1.bp.blogspot.com\/_A6_b0zkYeSY\/SmQF66oDCSI\/AAAAAAAAAeY\/XsgcbtubK8Y\/s400\/GT_Component1.JPG","contentUrl":"http:\/\/1.bp.blogspot.com\/_A6_b0zkYeSY\/SmQF66oDCSI\/AAAAAAAAAeY\/XsgcbtubK8Y\/s400\/GT_Component1.JPG"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/07\/18\/search-select-advance-functionality\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Search Select Advance Functionality"}]},{"@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\/169","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=169"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/169\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=169"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=169"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=169"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}