{"id":8237,"date":"2014-07-16T13:14:46","date_gmt":"2014-07-16T13:14:46","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=8237"},"modified":"2014-07-16T13:14:46","modified_gmt":"2014-07-16T13:14:46","slug":"hash-fields-in-workflow-execute-sql-statements","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/07\/16\/hash-fields-in-workflow-execute-sql-statements\/","title":{"rendered":"Hash fields in Workflow Execute SQL Statements"},"content":{"rendered":"

Workflow is one of the powerful features of SageCRM. We can define workflow Rules for systematically updating data for the entities through workflow. Every rule must be associated with set of actions. Sage CRM Workflow has several workflow actions that can be configured for any workflow rule as shown in below diagram.
\nNew Stuff:<\/strong><\/em><\/span> Implementing Browser based Spell-Checker in Sage CRM<\/a><\/p>\n

\"Workflow<\/a><\/p>\n

One of the very useful workflow actions is \u201cExecute SQL Statement<\/b>\u201d. Using this action you can write Update<\/b> queries in SQL style to manipulate the current record or any related data in CRM database.<\/p>\n

\"SQL<\/a><\/p>\n

Simple SQL Update queries can be written as we write them in SQL Query Manager however the beauty of using all this in SageCRM is hash fields. In SageCRM we can access any field from current entity using hash tags (#). We can utilize this for Execute SQL Statement action too.
\nFor Example:<\/b>\u00a0 Based on \u201cCase Reference ID<\/b>\u201d (1-1458) you want to update case description. To do this, query in Execute SQL statement action can be written as follows.
\nUPDATE Cases SET Case_description=\u2019 Ref : #Case_ReferenceId #\u2019\u00a0 WHERE Case_referenceid = \u2019#Case_ReferenceId#\u2019<\/i>
\nAlso Read:<\/strong><\/em><\/span>
\n1) Hide Tracking Note field while progressing workflow<\/a>
\n2) Restricting Workflow rules to Assigned User<\/a>
\n3) Creating tasks through workflow with defined due period<\/a>
\n4) Setting Default Date Time while progressing through Sage CRM Workflow<\/a>
\n5) Disabling Workflow for an Entity<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Workflow is one of the powerful features of SageCRM. We can define workflow Rules for systematically updating data for the entities through workflow. Every rule must be associated with set of actions. Sage CRM Workflow has several workflow actions that can be configured for any workflow rule as shown in below diagram. New Stuff: Implementing\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":[11,73,142,155,332,380,1,438],"tags":[499,1138,1313,1846,2325,2604],"class_list":["post-8237","post","type-post","status-publish","format-standard","hentry","category-action-sage-crm","category-configuration","category-execute","category-fields","category-sage-crm","category-sql","category-uncategorized","category-worklfow","tag-action","tag-field","tag-hash","tag-query","tag-sql","tag-workflow"],"yoast_head":"\nHash fields in Workflow Execute SQL Statements - 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\/2014\/07\/16\/hash-fields-in-workflow-execute-sql-statements\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hash fields in Workflow Execute SQL Statements - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Workflow is one of the powerful features of SageCRM. We can define workflow Rules for systematically updating data for the entities through workflow. Every rule must be associated with set of actions. Sage CRM Workflow has several workflow actions that can be configured for any workflow rule as shown in below diagram. New Stuff: Implementing\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/07\/16\/hash-fields-in-workflow-execute-sql-statements\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2014-07-16T13:14:46+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/07\/Workflow-Actions.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\/2014\/07\/16\/hash-fields-in-workflow-execute-sql-statements\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/07\/16\/hash-fields-in-workflow-execute-sql-statements\/\",\"name\":\"Hash fields in Workflow Execute SQL Statements - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/07\/16\/hash-fields-in-workflow-execute-sql-statements\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/07\/16\/hash-fields-in-workflow-execute-sql-statements\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/07\/Workflow-Actions.jpg\",\"datePublished\":\"2014-07-16T13:14:46+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/07\/16\/hash-fields-in-workflow-execute-sql-statements\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/07\/16\/hash-fields-in-workflow-execute-sql-statements\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/07\/16\/hash-fields-in-workflow-execute-sql-statements\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/07\/Workflow-Actions.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/07\/Workflow-Actions.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/07\/16\/hash-fields-in-workflow-execute-sql-statements\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hash fields in Workflow Execute SQL Statements\"}]},{\"@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":"Hash fields in Workflow Execute SQL Statements - 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\/2014\/07\/16\/hash-fields-in-workflow-execute-sql-statements\/","og_locale":"en_US","og_type":"article","og_title":"Hash fields in Workflow Execute SQL Statements - Sage CRM \u2013 Tips, Tricks and Components","og_description":"Workflow is one of the powerful features of SageCRM. We can define workflow Rules for systematically updating data for the entities through workflow. Every rule must be associated with set of actions. Sage CRM Workflow has several workflow actions that can be configured for any workflow rule as shown in below diagram. New Stuff: Implementing\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/07\/16\/hash-fields-in-workflow-execute-sql-statements\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2014-07-16T13:14:46+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/07\/Workflow-Actions.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\/2014\/07\/16\/hash-fields-in-workflow-execute-sql-statements\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/07\/16\/hash-fields-in-workflow-execute-sql-statements\/","name":"Hash fields in Workflow Execute SQL Statements - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/07\/16\/hash-fields-in-workflow-execute-sql-statements\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/07\/16\/hash-fields-in-workflow-execute-sql-statements\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/07\/Workflow-Actions.jpg","datePublished":"2014-07-16T13:14:46+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/07\/16\/hash-fields-in-workflow-execute-sql-statements\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/07\/16\/hash-fields-in-workflow-execute-sql-statements\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/07\/16\/hash-fields-in-workflow-execute-sql-statements\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/07\/Workflow-Actions.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/07\/Workflow-Actions.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/07\/16\/hash-fields-in-workflow-execute-sql-statements\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Hash fields in Workflow Execute SQL Statements"}]},{"@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\/8237","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=8237"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/8237\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=8237"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=8237"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=8237"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}