{"id":3516,"date":"2013-03-06T07:38:30","date_gmt":"2013-03-06T07:38:30","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=3516"},"modified":"2013-03-06T07:38:30","modified_gmt":"2013-03-06T07:38:30","slug":"progressing-workflow-manually-through-workflow-rules","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/03\/06\/progressing-workflow-manually-through-workflow-rules\/","title":{"rendered":"Progressing workflow manually through Workflow Rules"},"content":{"rendered":"

In Sage CRM, we can create a workflow for primary entities. There are five types of workflow rules as:<\/p>\n

    \n
  1. Transitional rule.<\/li>\n
  2. Global rule.<\/li>\n
  3. Conditional rule.<\/li>\n
  4. Primary rule.<\/li>\n
  5. Escalation rule.<\/li>\n<\/ol>\n

    We had come across a scenario where we had to progress the workflow based on the some condition. The scenario was like if \u201cStart date\u201d and the system date match then we need to progress the workflow from Approved state to Activate state. To do the same we can follow below mentioned steps:<\/span><\/p>\n

      \n
    1. First write a stored procedure to get the record based on the condition and then progress the workflow and used the same stored procedure in the escalation rule.<\/li>\n
    2. Create an escalation rule using Administration <\/strong>|<\/strong> Advanced Customization <\/strong>|<\/strong> Escalation<\/strong> and click on \u201cNew\u201d<\/strong> button. You will get the below screen.\"\"<\/a><\/li>\n
    3. Select View radio box or table radio box.<\/li>\n
    4. Give the rule name as per your requirement like \u2018Active Program\u2019.<\/li>\n
    5. Tick the rule enabled checkbox.<\/li>\n
    6. Paste the below code in the Trigger SQL Clause. \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0case_stage=’Approved’ and case_status=’InProgress’ and case_startdate=DATEADD(day, DATEDIFF(day, 0, getdate()), 0)<\/strong><\/li>\n
    7. Click on the \u201cSave\u201d button, it will redirect you to the below grid.<\/li>\n
    8. Click on the hyperlink available on \u201cActive Program \u201crule. The below screen gets open.\"\"<\/a><\/li>\n
    9. Click on the \u201cNew<\/strong>\u201d button to create new action for the rule.<\/li>\n
    10. Click on the \u201cExecute SQL Statement\u201d.<\/li>\n
    11. Set the below code in the SQL statement section. \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0Exec ActiveProgram\u00a0<\/strong><\/li>\n
    12. Click on \u201cSave<\/strong>\u201d button.<\/li>\n<\/ol>\n

      Using the above steps, when the start date and the system date match, the workflow automatically progresses from approved state to the activate state.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

      In Sage CRM, we can create a workflow for primary entities. There are five types of workflow rules as: Transitional rule. Global rule. Conditional rule. Primary rule. Escalation rule. We had come across a scenario where we had to progress the workflow based on the some condition. The scenario was like if \u201cStart date\u201d and\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":[140,332,438],"tags":[],"class_list":["post-3516","post","type-post","status-publish","format-standard","hentry","category-escalations","category-sage-crm","category-worklfow"],"yoast_head":"\nProgressing workflow manually through Workflow Rules - 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\/2013\/03\/06\/progressing-workflow-manually-through-workflow-rules\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Progressing workflow manually through Workflow Rules - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"In Sage CRM, we can create a workflow for primary entities. There are five types of workflow rules as: Transitional rule. Global rule. Conditional rule. Primary rule. Escalation rule. We had come across a scenario where we had to progress the workflow based on the some condition. The scenario was like if \u201cStart date\u201d and\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/03\/06\/progressing-workflow-manually-through-workflow-rules\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2013-03-06T07:38:30+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/03\/EscalationRule.bmp\" \/>\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\/2013\/03\/06\/progressing-workflow-manually-through-workflow-rules\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/03\/06\/progressing-workflow-manually-through-workflow-rules\/\",\"name\":\"Progressing workflow manually through Workflow Rules - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/03\/06\/progressing-workflow-manually-through-workflow-rules\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/03\/06\/progressing-workflow-manually-through-workflow-rules\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/03\/EscalationRule.bmp\",\"datePublished\":\"2013-03-06T07:38:30+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/03\/06\/progressing-workflow-manually-through-workflow-rules\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/03\/06\/progressing-workflow-manually-through-workflow-rules\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/03\/06\/progressing-workflow-manually-through-workflow-rules\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/03\/EscalationRule.bmp\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/03\/EscalationRule.bmp\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/03\/06\/progressing-workflow-manually-through-workflow-rules\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Progressing workflow manually through Workflow Rules\"}]},{\"@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":"Progressing workflow manually through Workflow Rules - 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\/2013\/03\/06\/progressing-workflow-manually-through-workflow-rules\/","og_locale":"en_US","og_type":"article","og_title":"Progressing workflow manually through Workflow Rules - Sage CRM \u2013 Tips, Tricks and Components","og_description":"In Sage CRM, we can create a workflow for primary entities. There are five types of workflow rules as: Transitional rule. Global rule. Conditional rule. Primary rule. Escalation rule. We had come across a scenario where we had to progress the workflow based on the some condition. The scenario was like if \u201cStart date\u201d and\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/03\/06\/progressing-workflow-manually-through-workflow-rules\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2013-03-06T07:38:30+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/03\/EscalationRule.bmp","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\/2013\/03\/06\/progressing-workflow-manually-through-workflow-rules\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/03\/06\/progressing-workflow-manually-through-workflow-rules\/","name":"Progressing workflow manually through Workflow Rules - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/03\/06\/progressing-workflow-manually-through-workflow-rules\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/03\/06\/progressing-workflow-manually-through-workflow-rules\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/03\/EscalationRule.bmp","datePublished":"2013-03-06T07:38:30+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/03\/06\/progressing-workflow-manually-through-workflow-rules\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/03\/06\/progressing-workflow-manually-through-workflow-rules\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/03\/06\/progressing-workflow-manually-through-workflow-rules\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/03\/EscalationRule.bmp","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/03\/EscalationRule.bmp"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/03\/06\/progressing-workflow-manually-through-workflow-rules\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Progressing workflow manually through Workflow Rules"}]},{"@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\/3516","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=3516"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/3516\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=3516"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=3516"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=3516"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}