{"id":1758,"date":"2012-04-18T15:09:23","date_gmt":"2012-04-18T15:09:23","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=1758"},"modified":"2012-04-18T15:09:23","modified_gmt":"2012-04-18T15:09:23","slug":"why-notify-time-field-is-used-in-escalation","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/04\/18\/why-notify-time-field-is-used-in-escalation\/","title":{"rendered":"Why Notify Time Field is used in Escalation"},"content":{"rendered":"<p>Sage CRM provides many features at administration level that can be used to make modifications and\u00a0customizations\u00a0without having to do intense coding. For e.g. Workflow, Table Level Scripting, Translation. In this blog we am going to explain the notification feature of Escalation in Sage CRM.<br \/>\nEscalation is a key tool of CRM to implement different kinds of functionality e.g.<br \/>\n1)\u00a0\u00a0\u00a0\u00a0 Display Notification on\u00a0 Entity Screen<br \/>\n2)\u00a0\u00a0\u00a0\u00a0 Display Message on Entity Screen<br \/>\n3)\u00a0\u00a0\u00a0\u00a0 Send E-mail to Person or Assignment Users<br \/>\n4)\u00a0\u00a0\u00a0\u00a0 Create Communications\/Cases\/Lead\/Opportunity base on condition.<br \/>\nBut sometimes the requirement is to display notification on screen whenever case is created and also display this notification to the assigned user. Please refer the screen shot given below for you reference.<br \/>\n<a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/04\/Image31.jpg\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-1761\" title=\"Image3\" src=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/04\/Image31.jpg\" alt=\"\" width=\"463\" height=\"61\" \/><\/a><br \/>\nTo implement this we need to follow the below steps<br \/>\nGo to Adminstration -&gt; Advanced Customization -&gt; \u00a0Escalation<br \/>\n1)\u00a0\u00a0\u00a0\u00a0 Click on the New button<br \/>\n2)\u00a0\u00a0\u00a0\u00a0 Enter value in Following fields<\/p>\n<ol>\n<li>Rule Name:XXXXX<\/li>\n<li>Table: Case<\/li>\n<li>Rule Enable:Check<\/li>\n<li>Trigger SQL Clause: &lt;Enter your Condition&gt;<\/li>\n<li>Click on the save button<\/li>\n<li>Select XXXX Escalation\u00a0 from list<\/li>\n<li>Click on the Change button<\/li>\n<li>Click on the new button<\/li>\n<li>Select Show Notification on screen list from list<\/li>\n<li>Enter value in following fields<\/li>\n<\/ol>\n<p>i.\u00a0\u00a0\u00a0 Column:case_notifytime<br \/>\nii.\u00a0\u00a0\u00a0 Table:Cases<br \/>\niii.\u00a0\u00a0\u00a0 \u00a0Message: #case_referenceId# is assigned to you.<br \/>\n11. Click on the save button<br \/>\nAfter implementing these steps users are able display the notification on screen. But we found a problem here that the users were not able to Dismiss or Snooze the selected items. So we analyzed this issue and found that we have to apply notifytime condition in Trigger SQL Clause, i.e. case_notifytime&lt;#T. Once we applied this we were able to Dismiss or Snooze the selected notifications.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sage CRM provides many features at administration level that can be used to make modifications and\u00a0customizations\u00a0without having to do intense coding. For e.g. Workflow, Table Level Scripting, Translation. In this blog we am going to explain the notification feature of Escalation in Sage CRM. Escalation is a key tool of CRM to implement different kinds\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/04\/18\/why-notify-time-field-is-used-in-escalation\/\">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":[332],"tags":[1098,1143],"class_list":["post-1758","post","type-post","status-publish","format-standard","hentry","category-sage-crm","tag-escalation","tag-fields"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Why Notify Time Field is used in Escalation - 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\/04\/18\/why-notify-time-field-is-used-in-escalation\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Why Notify Time Field is used in Escalation - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Sage CRM provides many features at administration level that can be used to make modifications and\u00a0customizations\u00a0without having to do intense coding. For e.g. Workflow, Table Level Scripting, Translation. In this blog we am going to explain the notification feature of Escalation in Sage CRM. Escalation is a key tool of CRM to implement different kinds\u2026 Read More &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/04\/18\/why-notify-time-field-is-used-in-escalation\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2012-04-18T15:09:23+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/04\/Image31.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\/04\/18\/why-notify-time-field-is-used-in-escalation\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/04\/18\/why-notify-time-field-is-used-in-escalation\/\",\"name\":\"Why Notify Time Field is used in Escalation - 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\/04\/18\/why-notify-time-field-is-used-in-escalation\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/04\/18\/why-notify-time-field-is-used-in-escalation\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/04\/Image31.jpg\",\"datePublished\":\"2012-04-18T15:09:23+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/04\/18\/why-notify-time-field-is-used-in-escalation\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/04\/18\/why-notify-time-field-is-used-in-escalation\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/04\/18\/why-notify-time-field-is-used-in-escalation\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/04\/Image31.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/04\/Image31.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/04\/18\/why-notify-time-field-is-used-in-escalation\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Why Notify Time Field is used in Escalation\"}]},{\"@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":"Why Notify Time Field is used in Escalation - 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\/04\/18\/why-notify-time-field-is-used-in-escalation\/","og_locale":"en_US","og_type":"article","og_title":"Why Notify Time Field is used in Escalation - Sage CRM \u2013 Tips, Tricks and Components","og_description":"Sage CRM provides many features at administration level that can be used to make modifications and\u00a0customizations\u00a0without having to do intense coding. For e.g. Workflow, Table Level Scripting, Translation. In this blog we am going to explain the notification feature of Escalation in Sage CRM. Escalation is a key tool of CRM to implement different kinds\u2026 Read More &raquo;","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/04\/18\/why-notify-time-field-is-used-in-escalation\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2012-04-18T15:09:23+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/04\/Image31.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\/04\/18\/why-notify-time-field-is-used-in-escalation\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/04\/18\/why-notify-time-field-is-used-in-escalation\/","name":"Why Notify Time Field is used in Escalation - 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\/04\/18\/why-notify-time-field-is-used-in-escalation\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/04\/18\/why-notify-time-field-is-used-in-escalation\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/04\/Image31.jpg","datePublished":"2012-04-18T15:09:23+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/04\/18\/why-notify-time-field-is-used-in-escalation\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/04\/18\/why-notify-time-field-is-used-in-escalation\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/04\/18\/why-notify-time-field-is-used-in-escalation\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/04\/Image31.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/04\/Image31.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/04\/18\/why-notify-time-field-is-used-in-escalation\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Why Notify Time Field is used in Escalation"}]},{"@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\/1758","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=1758"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/1758\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=1758"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=1758"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=1758"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}