{"id":263,"date":"2010-10-06T12:40:00","date_gmt":"2010-10-06T12:40:00","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=263"},"modified":"2010-10-06T12:40:00","modified_gmt":"2010-10-06T12:40:00","slug":"remove-entry-from-saved-search-dropdown","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/10\/06\/remove-entry-from-saved-search-dropdown\/","title":{"rendered":"Remove Entry from Saved Search dropdown"},"content":{"rendered":"<div class=\"MsoNormal\"><span style=\"font-family: Arial, sans-serif; font-size: 10pt; line-height: 115%;\">SageCRM provides the functionality of providing search criteria in reports and if you tend to use a certain criteria regularly then you can even save those criteria. In this way you can save the multiple criteria for a single report. So the next time the report needs to be run, you can just choose the saved criteria and view the report without having to set the criteria all over again.<o:p><\/o:p><\/span><\/div>\n<div class=\"MsoNormal\"><span style=\"font-family: Arial, sans-serif; font-size: 10pt; line-height: 115%;\">Now it is quite possible that once of the search criteria that you must have specified may not be valid now and you no longer need it in your report saved search dropdown. How do you remove it? From the application level, SageCRM does not allow you to do it. So, if the car engine cannot be started from the driver seat, we will have to open the \u201cbonnet\u201d and do it the hard way <\/span><span style=\"font-family: Wingdings; font-size: 10pt; line-height: 115%;\">J<\/span><span style=\"font-family: Arial, sans-serif; font-size: 10pt; line-height: 115%;\">. In this case the SQL database.<o:p><\/o:p><\/span><\/div>\n<div class=\"MsoNoSpacing\"><span style=\"font-family: Arial, sans-serif; font-size: 10pt;\">If a Save Search criterion by the name \u201cOpportunities &#8211; Open\u201d needs to be deleted then here is what needs to be done. <o:p><\/o:p><\/span><\/div>\n<div class=\"MsoNoSpacing\"><\/div>\n<div class=\"MsoNoSpacing\"><span style=\"font-family: Arial, sans-serif; font-size: 10pt;\">delete from Custom_ReportSearches where rese_searchname=&#8217; Opportunities &#8211; Open &#8216; <o:p><\/o:p><\/span><\/div>\n<div class=\"MsoNoSpacing\"><\/div>\n<div class=\"MsoNoSpacing\"><span style=\"font-family: Arial, sans-serif; font-size: 10pt;\">That\u2019s it. The saved search criteria would be removed from the list.<o:p><\/o:p><\/span><\/div>\n<p><marquee width=\"80%\"><b>If you find this content useful, please feel free to drop us an email at <a href=\"mailto:crm@greytrix.com\" title=\"mailto:crm@greytrix.com\">crm@greytrix.com<\/a>. <\/b><\/marquee><\/p>\n","protected":false},"excerpt":{"rendered":"<p>SageCRM provides the functionality of providing search criteria in reports and if you tend to use a certain criteria regularly then you can even save those criteria. In this way you can save the multiple criteria for a single report. So the next time the report needs to be run, you can just choose the\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/10\/06\/remove-entry-from-saved-search-dropdown\/\">Read More &raquo;<\/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":[792,1920,2240],"class_list":["post-263","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-criteria","tag-report","tag-search"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Remove Entry from Saved Search dropdown - 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\/2010\/10\/06\/remove-entry-from-saved-search-dropdown\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Remove Entry from Saved Search dropdown - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"SageCRM provides the functionality of providing search criteria in reports and if you tend to use a certain criteria regularly then you can even save those criteria. In this way you can save the multiple criteria for a single report. So the next time the report needs to be run, you can just choose the\u2026 Read More &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/10\/06\/remove-entry-from-saved-search-dropdown\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2010-10-06T12:40:00+00:00\" \/>\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\/2010\/10\/06\/remove-entry-from-saved-search-dropdown\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/10\/06\/remove-entry-from-saved-search-dropdown\/\",\"name\":\"Remove Entry from Saved Search dropdown - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"datePublished\":\"2010-10-06T12:40:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/10\/06\/remove-entry-from-saved-search-dropdown\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/10\/06\/remove-entry-from-saved-search-dropdown\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/10\/06\/remove-entry-from-saved-search-dropdown\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Remove Entry from Saved Search dropdown\"}]},{\"@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":"Remove Entry from Saved Search dropdown - 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\/2010\/10\/06\/remove-entry-from-saved-search-dropdown\/","og_locale":"en_US","og_type":"article","og_title":"Remove Entry from Saved Search dropdown - Sage CRM \u2013 Tips, Tricks and Components","og_description":"SageCRM provides the functionality of providing search criteria in reports and if you tend to use a certain criteria regularly then you can even save those criteria. In this way you can save the multiple criteria for a single report. So the next time the report needs to be run, you can just choose the\u2026 Read More &raquo;","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/10\/06\/remove-entry-from-saved-search-dropdown\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2010-10-06T12:40:00+00:00","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\/2010\/10\/06\/remove-entry-from-saved-search-dropdown\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/10\/06\/remove-entry-from-saved-search-dropdown\/","name":"Remove Entry from Saved Search dropdown - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"datePublished":"2010-10-06T12:40:00+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/10\/06\/remove-entry-from-saved-search-dropdown\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/10\/06\/remove-entry-from-saved-search-dropdown\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/10\/06\/remove-entry-from-saved-search-dropdown\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Remove Entry from Saved Search dropdown"}]},{"@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\/263","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=263"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/263\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=263"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=263"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=263"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}