{"id":25449,"date":"2021-04-30T09:58:05","date_gmt":"2021-04-30T09:58:05","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=25449"},"modified":"2021-04-30T09:58:07","modified_gmt":"2021-04-30T09:58:07","slug":"change-display-field-on-list-in-quick-find","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2021\/04\/30\/change-display-field-on-list-in-quick-find\/","title":{"rendered":"Change Display Field on list in Quick Find"},"content":{"rendered":"\n

What good is capturing and organizing all that customer data in, if you can\u2019t find the right information when you need it? Sage CRM<\/a> is one such application that helps in capturing, organizing as well as searching the information with ease. Every business user that works with CRM wants quick results while searching for data records in CRM. Thus, Sage CRM has specifically focused on search functionality and provided not just one but four different ways to quickly search or access the records in CRM.<\/p>\n\n\n\n

New Stuff:<\/strong><\/em> Sage CRM 2021 R1: Advanced Customization Wizard Updates<\/a><\/p>\n\n\n\n

Entity specific search screens, Favourites, Recent List and Quick Find are the CRM tools that features search functionality. Out of these, Quick Find in Sage CRM allows users to perform a quick search within all the Primary entities i.e., Company, Person, Cases, Opportunity, Lead, Communication etc. as well as users can perform quick search on custom entities of CRM. In this blog, we are going to discuss about how to change the display field on list on quick find result.<\/p>\n\n\n\n

In Sage CRM, Quick Find retrieves data from the Quick Find service which runs as a background process. Below are advantages of quick find functionality in Sage CRM:<\/p>\n\n\n\n

  1. System Admin can set the maximum no. of records that will be visible on Quick find search result like 10, 15 or 20 records.<\/li>
  2. Users can enable Quick find for single or multiple entities in CRM.<\/li><\/ol>\n\n\n\n

    One of the clients came up with a new requirement that they want to view company name along with status Active or Inactive on quick find result list. The reason behind doing so was that users could perform quick find, however before taking any relevant action such as including these companies in campaigns, they had to first check whether the company status is Active or not. To do so, first the user has to open up the Company summary page and then check the status value. Since this is a time-consuming process, we tried our hands on handling the scenario by making changes to the result list.<\/p>\n\n\n\n

    Before making changes, you can see below screen shot that quick find result only displays the Company name.<\/p>\n\n\n\n

    \"Standard<\/a>\n\n
    Standard Quick Find Result<\/i><\/center><\/font><\/p><\/center><\/figure>\n\n\n\n

    To achieve the same in CRM, just follow the below steps:<\/p>\n\n\n\n

    1. Create a text field on the Company Entity, for example comp_quickfindfield
      <\/li>
    2. Stop the IIS Server.
      <\/li>
    3. Now execute below queries in SQL Management to update the comp_quickfindfield Field, before processing with updations take the database backup:

      — For Active Company<\/li><\/ol>\n\n\n\n

      UPDATE Company SET comp_quickfindfield = ( Select ‘Active’+ ‘ – ‘ + Comp_Name ) WHERE Comp_Deleted IS NULL AND Comp_Status = ‘Active’<\/strong>

      <\/strong>— For Inactive Company<\/p>\n\n\n\n

      UPDATE Company SET comp_quickfindfield = ( Select ‘Inactive’+ ‘ – ‘ + Comp_Name ) WHERE Comp_Deleted IS NULL AND Comp_Status = ‘Inactive’<\/strong>
      <\/p>\n\n\n\n

      1. Create a trigger that will update value in comp_quickfindfield field on insert or update in Company entity.
        <\/li>
      2. Now execute below query in SQL Management:

        UPDATE Custom_Tables SET Bord_RecDescriptor = ‘#comp_quickfindfield#\u2019,
        Bord_UpdatedDate = GETDATE() WHERE Bord_Caption = ‘Company’<\/strong><\/li><\/ol>\n\n\n\n

        Bord_RecDescriptor<\/strong> column in Custom_Tables table is responsible to display the value in quick find list.
        <\/p>\n\n\n\n

        1. Now take the backup and Delete the QuickFind folder from below path:<\/li><\/ol>\n\n\n\n

          InstalledDrive:\\Program Files (x86) \\Sage \\CRM \\(InstanceName)<\/strong>
          <\/p>\n\n\n\n

          1. Once done with all above steps, start the IIS Server and also check that the CRM Quick Find Service is started or not. If not, then start the service.<\/li><\/ol>\n\n\n\n

            Now login into the CRM and search Company using Quick find, you will get the search result list as Active or Inactive with company name. You can refer below screen shot for your reference.<\/p>\n\n\n\n

            \"Quick<\/a>\n\n
            Quick Find Result after customizing<\/i><\/center><\/font><\/p><\/center><\/figure>\n\n\n\n

            In this way, with the help of few steps you can easily change the display field of Quick find list. These changes can be applied to any other standard as well as custom entities in CRM just by updating Bord_RecDescriptor field value in Custom_Tables table.<\/p>\n\n\n\n

            About Us<\/strong><\/span><\/p>\n\n\n\n

            Greytrix \u2013 a globally recognized and one of the oldest Sage Development Partners is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience and expertise, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development, and implementation competence.<\/p>\n\n\n\n

            Greytrix\u00a0has some unique integration solutions developed for Sage CRM with Sage ERPs namely\u00a0Sage X3,\u00a0Sage Intacct,\u00a0Sage 100,\u00a0Sage 500,\u00a0and\u00a0Sage 300. We also offer best-in-class\u00a0Sage ERP\u00a0and\u00a0Sage CRM\u00a0customization and development services\u00a0to\u00a0Business\u00a0Partners,\u00a0End\u00a0Users, and Sage PSG worldwide. Greytrix\u00a0helps in\u00a0the migration of Sage CRM from\u00a0Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer. Our Sage CRM Product Suite includes\u00a0add-ons like\u00a0 Greytrix Business Manager,\u00a0Sage CRM Project Manager,\u00a0Sage CRM Resource Planner,\u00a0Sage CRM Contract Manager,\u00a0Sage CRM Event Manager,\u00a0Sage CRM Budget Planner,\u00a0Gmail Integration,\u00a0Sage CRM Mobile Service Signature,\u00a0Sage CRM CTI Framework.<\/gwmw><\/gwmw><\/gwmw><\/gwmw><\/gwmw><\/p>\n\n\n\n

            Greytrix is a recognized\u00a0Sage Champion Partner\u00a0for GUMU™ Sage X3 \u2013 Sage CRM integration listed on\u00a0Sage Marketplace and Sage CRM \u2013 Sage Intacct integration listed on Sage Intacct Marketplace. The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for the processing and execution of application programs at the click of a button.<\/gwmw><\/gwmw><\/gwmw><\/gwmw><\/gwmw><\/p>\n\n\n\n

            For more information on our integration solutions, please contact us at sage@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"

            What good is capturing and organizing all that customer data in, if you can\u2019t find the right information when you need it? Sage CRM is one such application that helps in capturing, organizing as well as searching the information with ease. Every business user that works with CRM wants quick results while searching for data\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19,20,73,82,92,93,119,136,137,152,153,157,206,207,209,219,220,332,333,335,334,3987,3985,3986,423,424],"tags":[4378,4379,4380,3619,4384,4382,3856,4383,4381],"class_list":["post-25449","post","type-post","status-publish","format-standard","hentry","category-administrator","category-advanced-find","category-configuration","category-crm-quickfind","category-custom-entity","category-custom-fields","category-display","category-enhancements","category-entity","category-feature","category-features","category-find-sage-crm","category-keyword","category-keyword-search","category-layouts","category-list","category-lists","category-sage-crm","category-sage-crm-2017","category-sage-crm-2018-crm72","category-sage-crm-2018","category-sage-crm-2019-r1-sage-crm","category-sage-crm-2019-r1","category-sage-crm-2019-r1-sage-crm-2018-crm72","category-view","category-views","tag-change-display-field-on-list-in-quick-find","tag-display-field-in-quick-find-list","tag-display-field-on-list-in-quick-find","tag-quick-find","tag-quick-find-for-single-or-multiple-entities-in-crm","tag-quick-find-in-sage-crm","tag-recent-list","tag-search-screens","tag-searching-for-data-records-in-crm"],"yoast_head":"\nChange Display Field on list in Quick Find - 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\/2021\/04\/30\/change-display-field-on-list-in-quick-find\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Change Display Field on list in Quick Find - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"What good is capturing and organizing all that customer data in, if you can\u2019t find the right information when you need it? Sage CRM is one such application that helps in capturing, organizing as well as searching the information with ease. Every business user that works with CRM wants quick results while searching for data\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2021\/04\/30\/change-display-field-on-list-in-quick-find\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2021-04-30T09:58:05+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-04-30T09:58:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2021\/04\/01_BeforeFieldUpdate.jpg\" \/>\n<meta name=\"author\" content=\"Greytrix\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Greytrix\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 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\/2021\/04\/30\/change-display-field-on-list-in-quick-find\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2021\/04\/30\/change-display-field-on-list-in-quick-find\/\",\"name\":\"Change Display Field on list in Quick Find - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2021\/04\/30\/change-display-field-on-list-in-quick-find\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2021\/04\/30\/change-display-field-on-list-in-quick-find\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2021\/04\/01_BeforeFieldUpdate.jpg\",\"datePublished\":\"2021-04-30T09:58:05+00:00\",\"dateModified\":\"2021-04-30T09:58:07+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/402abe5da07cd7f9bfeb6acfa41fae39\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2021\/04\/30\/change-display-field-on-list-in-quick-find\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2021\/04\/30\/change-display-field-on-list-in-quick-find\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2021\/04\/30\/change-display-field-on-list-in-quick-find\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2021\/04\/01_BeforeFieldUpdate.jpg\",\"contentUrl\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2021\/04\/01_BeforeFieldUpdate.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2021\/04\/30\/change-display-field-on-list-in-quick-find\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Change Display Field on list in Quick Find\"}]},{\"@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\/402abe5da07cd7f9bfeb6acfa41fae39\",\"name\":\"Greytrix\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g\",\"caption\":\"Greytrix\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greytrix\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Change Display Field on list in Quick Find - 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\/2021\/04\/30\/change-display-field-on-list-in-quick-find\/","og_locale":"en_US","og_type":"article","og_title":"Change Display Field on list in Quick Find - Sage CRM \u2013 Tips, Tricks and Components","og_description":"What good is capturing and organizing all that customer data in, if you can\u2019t find the right information when you need it? Sage CRM is one such application that helps in capturing, organizing as well as searching the information with ease. Every business user that works with CRM wants quick results while searching for data\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2021\/04\/30\/change-display-field-on-list-in-quick-find\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2021-04-30T09:58:05+00:00","article_modified_time":"2021-04-30T09:58:07+00:00","og_image":[{"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2021\/04\/01_BeforeFieldUpdate.jpg","type":"","width":"","height":""}],"author":"Greytrix","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Greytrix","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2021\/04\/30\/change-display-field-on-list-in-quick-find\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2021\/04\/30\/change-display-field-on-list-in-quick-find\/","name":"Change Display Field on list in Quick Find - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2021\/04\/30\/change-display-field-on-list-in-quick-find\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2021\/04\/30\/change-display-field-on-list-in-quick-find\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2021\/04\/01_BeforeFieldUpdate.jpg","datePublished":"2021-04-30T09:58:05+00:00","dateModified":"2021-04-30T09:58:07+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/402abe5da07cd7f9bfeb6acfa41fae39"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2021\/04\/30\/change-display-field-on-list-in-quick-find\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2021\/04\/30\/change-display-field-on-list-in-quick-find\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2021\/04\/30\/change-display-field-on-list-in-quick-find\/#primaryimage","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2021\/04\/01_BeforeFieldUpdate.jpg","contentUrl":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2021\/04\/01_BeforeFieldUpdate.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2021\/04\/30\/change-display-field-on-list-in-quick-find\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Change Display Field on list in Quick Find"}]},{"@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\/402abe5da07cd7f9bfeb6acfa41fae39","name":"Greytrix","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g","caption":"Greytrix"},"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greytrix\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/25449","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\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/comments?post=25449"}],"version-history":[{"count":6,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/25449\/revisions"}],"predecessor-version":[{"id":25457,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/25449\/revisions\/25457"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=25449"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=25449"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=25449"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}