{ "Entities": [ { "EntityType": "Rock.Model.WorkflowType", "Guid": "dcaaad07-e5f4-4ce5-aa02-157aacf78fa6", "GenerateNewGuid": true, "Properties": { "IsSystem": false, "IsActive": true, "WorkflowIdPrefix": "", "Name": "Clear User Preferences", "Description": "Clear's all the Rock user preferences for a particular person.", "Order": 0, "WorkTerm": "Work", "ProcessingIntervalSeconds": 28800, "IsPersisted": false, "SummaryViewText": "
\n
\n
Started By
{{ Workflow.InitiatorPersonAlias.Person.FullName }}
\n
\n
\n
Started On
{{ Workflow.ActivatedDateTime | Date:'MM/dd/yyyy' }} at {{ Workflow.ActivatedDateTime | Date:'hh:mm:ss tt' }}
\n
\n
\n\n{% assign attributeList = '' %}\n{% for attribute in Workflow.AttributeValues %}\n {% if attribute.AttributeIsGridColumn %}\n {% assign attributeValue = attribute.ValueFormatted %}\n {% if attributeValue != '' %}\n {% capture item %}
{{ attribute.AttributeName }}
{{ attributeValue }}
{% endcapture %}\n {% assign attributeList = attributeList | Append:item %}\n {% endif %}\n {% endif %}\n{% endfor %}\n\n{% if attributeList != '' %}\n
\n
\n
\n {{ attributeList }}\n
\n
\n
\n{% endif %}", "NoActionMessage": "This {{ Workflow.WorkflowType.WorkTerm }} does not currently require your attention.", "LogRetentionPeriod": null, "CompletedWorkflowRetentionPeriod": null, "LoggingLevel": 0, "IconCssClass": "fa fa-eraser", "CreatedDateTime": "2020-07-08T09:16:05.39", "ModifiedDateTime": "2020-07-08T09:43:42.173" }, "Transforms": {}, "References": [ { "Property": "CategoryId", "EntityType": "", "Type": 4, "Data": "WorkflowCategory" } ] }, { "EntityType": "Rock.Model.WorkflowActivityType", "Guid": "164554d7-1892-4104-94d5-d12b518eed5f", "GenerateNewGuid": true, "Properties": { "IsActive": true, "Name": "Start", "Description": "", "IsActivatedWithWorkflow": true, "Order": 0, "CreatedDateTime": "2020-07-08T09:16:05.61", "ModifiedDateTime": "2020-07-08T09:16:05.61" }, "Transforms": {}, "References": [ { "Property": "WorkflowTypeId", "EntityType": "Rock.Model.WorkflowType", "Type": 1, "Data": "dcaaad07-e5f4-4ce5-aa02-157aacf78fa6" } ] }, { "EntityType": "Rock.Model.WorkflowActionType", "Guid": "9a98db33-81e9-4748-8b98-c079211e58a3", "GenerateNewGuid": true, "Properties": { "Name": "Get Person", "Order": 0, "IsActionCompletedOnSuccess": true, "IsActivityCompletedOnSuccess": false, "CriteriaAttributeGuid": null, "CriteriaComparisonType": 1, "CriteriaValue": "", "CreatedDateTime": "2020-07-08T09:16:05.703", "ModifiedDateTime": "2020-07-08T09:16:05.703" }, "Transforms": {}, "References": [ { "Property": "ActivityTypeId", "EntityType": "Rock.Model.WorkflowActivityType", "Type": 1, "Data": "164554d7-1892-4104-94d5-d12b518eed5f" }, { "Property": "EntityTypeId", "EntityType": "Rock.Model.EntityType", "Type": 2, "Data": "Rock.Workflow.Action.SetAttributeFromEntity" } ] }, { "EntityType": "Rock.Model.Attribute", "Guid": "9392e3d7-a28b-4cd8-8b03-5e147b102ef1", "GenerateNewGuid": false, "Properties": { "IsSystem": true, "EntityTypeQualifierColumn": "EntityTypeId", "Key": "Active", "Name": "Active", "Description": "Should Service be used?", "Order": 0, "IsGridColumn": false, "DefaultValue": "False", "IsMultiValue": false, "IsRequired": false, "IconCssClass": null, "AllowSearch": false, "IsIndexEnabled": false, "IsAnalytic": false, "IsAnalyticHistory": false, "IsActive": true, "EnableHistory": false, "PreHtml": null, "PostHtml": null, "AbbreviatedName": "Active", "IsPublic": false, "ShowOnBulk": false, "CreatedDateTime": null, "ModifiedDateTime": null }, "Transforms": {}, "References": [ { "Property": "FieldTypeId", "EntityType": "Rock.Model.FieldType", "Type": 3, "Data": "Rock.Field.Types.BooleanFieldType" }, { "Property": "EntityTypeId", "EntityType": "Rock.Model.EntityType", "Type": 2, "Data": "Rock.Model.WorkflowActionType" }, { "Property": "EntityTypeQualifierValue", "EntityType": "Rock.Model.EntityType", "Type": 2, "Data": "Rock.Workflow.Action.SetAttributeFromEntity" } ] }, { "EntityType": "Rock.Model.AttributeValue", "Guid": "2dad4cf4-80e0-4e06-8940-ea8dddce4c04", "GenerateNewGuid": true, "Properties": { "IsSystem": false, "Value": "False", "ValueAsNumeric": null, "CreatedDateTime": "2020-07-08T09:16:05.767", "ModifiedDateTime": "2020-07-08T09:16:05.767" }, "Transforms": {}, "References": [ { "Property": "AttributeId", "EntityType": "Rock.Model.Attribute", "Type": 1, "Data": "9392e3d7-a28b-4cd8-8b03-5e147b102ef1" }, { "Property": "EntityId", "EntityType": "Rock.Model.WorkflowActionType", "Type": 1, "Data": "9a98db33-81e9-4748-8b98-c079211e58a3" } ] }, { "EntityType": "Rock.Model.Attribute", "Guid": "ad4efac4-e687-43df-832f-0dc3856ababb", "GenerateNewGuid": false, "Properties": { "IsSystem": true, "EntityTypeQualifierColumn": "EntityTypeId", "Key": "Order", "Name": "Order", "Description": "The order that this service should be used (priority)", "Order": 0, "IsGridColumn": false, "DefaultValue": "", "IsMultiValue": false, "IsRequired": true, "IconCssClass": null, "AllowSearch": false, "IsIndexEnabled": false, "IsAnalytic": false, "IsAnalyticHistory": false, "IsActive": true, "EnableHistory": false, "PreHtml": null, "PostHtml": null, "AbbreviatedName": "Order", "IsPublic": false, "ShowOnBulk": false, "CreatedDateTime": null, "ModifiedDateTime": "2018-10-18T13:37:56.09" }, "Transforms": {}, "References": [ { "Property": "FieldTypeId", "EntityType": "Rock.Model.FieldType", "Type": 3, "Data": "Rock.Field.Types.IntegerFieldType" }, { "Property": "EntityTypeId", "EntityType": "Rock.Model.EntityType", "Type": 2, "Data": "Rock.Model.WorkflowActionType" }, { "Property": "EntityTypeQualifierValue", "EntityType": "Rock.Model.EntityType", "Type": 2, "Data": "Rock.Workflow.Action.SetAttributeFromEntity" } ] }, { "EntityType": "Rock.Model.Attribute", "Guid": "61e6e1bc-e657-4f00-b2e9-769aaa25b9f7", "GenerateNewGuid": false, "Properties": { "IsSystem": true, "EntityTypeQualifierColumn": "EntityTypeId", "Key": "Attribute", "Name": "Attribute", "Description": "The attribute to set the value of.", "Order": 1, "IsGridColumn": false, "DefaultValue": "", "IsMultiValue": false, "IsRequired": true, "IconCssClass": null, "AllowSearch": false, "IsIndexEnabled": false, "IsAnalytic": false, "IsAnalyticHistory": false, "IsActive": true, "EnableHistory": false, "PreHtml": null, "PostHtml": null, "AbbreviatedName": "Attribute", "IsPublic": false, "ShowOnBulk": false, "CreatedDateTime": null, "ModifiedDateTime": "2018-10-18T13:37:56.06" }, "Transforms": {}, "References": [ { "Property": "FieldTypeId", "EntityType": "Rock.Model.FieldType", "Type": 3, "Data": "Rock.Field.Types.WorkflowAttributeFieldType" }, { "Property": "EntityTypeId", "EntityType": "Rock.Model.EntityType", "Type": 2, "Data": "Rock.Model.WorkflowActionType" }, { "Property": "EntityTypeQualifierValue", "EntityType": "Rock.Model.EntityType", "Type": 2, "Data": "Rock.Workflow.Action.SetAttributeFromEntity" } ] }, { "EntityType": "Rock.Model.AttributeValue", "Guid": "d3f62b12-8968-4e37-b335-491b94c0e81d", "GenerateNewGuid": true, "Properties": { "IsSystem": false, "Value": "a5300f3e-1df8-4954-b0a4-0e024a38ffb9", "ValueAsNumeric": null, "CreatedDateTime": "2020-07-08T09:16:05.767", "ModifiedDateTime": "2020-07-08T09:16:05.767" }, "Transforms": {}, "References": [ { "Property": "AttributeId", "EntityType": "Rock.Model.Attribute", "Type": 1, "Data": "61e6e1bc-e657-4f00-b2e9-769aaa25b9f7" }, { "Property": "EntityId", "EntityType": "Rock.Model.WorkflowActionType", "Type": 1, "Data": "9a98db33-81e9-4748-8b98-c079211e58a3" } ] }, { "EntityType": "Rock.Model.Attribute", "Guid": "ddefb300-0a4f-4086-99be-a32761928f5e", "GenerateNewGuid": false, "Properties": { "IsSystem": false, "EntityTypeQualifierColumn": "EntityTypeId", "Key": "EntityIsRequired", "Name": "Entity Is Required", "Description": "Should an error be returned if the entity is missing or not a valid entity type?", "Order": 2, "IsGridColumn": false, "DefaultValue": "True", "IsMultiValue": false, "IsRequired": false, "IconCssClass": "", "AllowSearch": false, "IsIndexEnabled": false, "IsAnalytic": false, "IsAnalyticHistory": false, "IsActive": true, "EnableHistory": false, "PreHtml": null, "PostHtml": null, "AbbreviatedName": "Entity Is Required", "IsPublic": false, "ShowOnBulk": false, "CreatedDateTime": "2018-10-18T13:37:56.06", "ModifiedDateTime": "2018-10-18T13:37:56.06" }, "Transforms": {}, "References": [ { "Property": "FieldTypeId", "EntityType": "Rock.Model.FieldType", "Type": 3, "Data": "Rock.Field.Types.BooleanFieldType" }, { "Property": "EntityTypeId", "EntityType": "Rock.Model.EntityType", "Type": 2, "Data": "Rock.Model.WorkflowActionType" }, { "Property": "EntityTypeQualifierValue", "EntityType": "Rock.Model.EntityType", "Type": 2, "Data": "Rock.Workflow.Action.SetAttributeFromEntity" } ] }, { "EntityType": "Rock.Model.AttributeValue", "Guid": "faae84ed-4560-496e-af7e-53cb3260f200", "GenerateNewGuid": true, "Properties": { "IsSystem": false, "Value": "False", "ValueAsNumeric": null, "CreatedDateTime": "2020-07-08T09:16:05.767", "ModifiedDateTime": "2020-07-08T09:16:26.297" }, "Transforms": {}, "References": [ { "Property": "AttributeId", "EntityType": "Rock.Model.Attribute", "Type": 1, "Data": "ddefb300-0a4f-4086-99be-a32761928f5e" }, { "Property": "EntityId", "EntityType": "Rock.Model.WorkflowActionType", "Type": 1, "Data": "9a98db33-81e9-4748-8b98-c079211e58a3" } ] }, { "EntityType": "Rock.Model.Attribute", "Guid": "1246c53a-fd92-4e08-abde-9a6c37e70c7b", "GenerateNewGuid": false, "Properties": { "IsSystem": true, "EntityTypeQualifierColumn": "EntityTypeId", "Key": "UseId", "Name": "Use Id instead of Guid", "Description": "Most entity attribute field types expect the Guid of the entity (which is used by default). Select this option if the entity's Id should be used instead (should be rare).", "Order": 3, "IsGridColumn": false, "DefaultValue": "False", "IsMultiValue": false, "IsRequired": false, "IconCssClass": null, "AllowSearch": false, "IsIndexEnabled": false, "IsAnalytic": false, "IsAnalyticHistory": false, "IsActive": true, "EnableHistory": false, "PreHtml": null, "PostHtml": null, "AbbreviatedName": "Use Id instead of Guid", "IsPublic": false, "ShowOnBulk": false, "CreatedDateTime": null, "ModifiedDateTime": "2018-10-18T13:37:56.077" }, "Transforms": {}, "References": [ { "Property": "FieldTypeId", "EntityType": "Rock.Model.FieldType", "Type": 3, "Data": "Rock.Field.Types.BooleanFieldType" }, { "Property": "EntityTypeId", "EntityType": "Rock.Model.EntityType", "Type": 2, "Data": "Rock.Model.WorkflowActionType" }, { "Property": "EntityTypeQualifierValue", "EntityType": "Rock.Model.EntityType", "Type": 2, "Data": "Rock.Workflow.Action.SetAttributeFromEntity" } ] }, { "EntityType": "Rock.Model.AttributeValue", "Guid": "db93ab90-9228-4f37-8717-e590abcd6449", "GenerateNewGuid": true, "Properties": { "IsSystem": false, "Value": "False", "ValueAsNumeric": null, "CreatedDateTime": "2020-07-08T09:16:05.767", "ModifiedDateTime": "2020-07-08T09:40:57.5" }, "Transforms": {}, "References": [ { "Property": "AttributeId", "EntityType": "Rock.Model.Attribute", "Type": 1, "Data": "1246c53a-fd92-4e08-abde-9a6c37e70c7b" }, { "Property": "EntityId", "EntityType": "Rock.Model.WorkflowActionType", "Type": 1, "Data": "9a98db33-81e9-4748-8b98-c079211e58a3" } ] }, { "EntityType": "Rock.Model.Attribute", "Guid": "00d8331d-3055-4531-b374-6b98a9a71d70", "GenerateNewGuid": false, "Properties": { "IsSystem": false, "EntityTypeQualifierColumn": "EntityTypeId", "Key": "LavaTemplate", "Name": "Lava Template", "Description": "By default this action will set the attribute value equal to the guid (or id) of the entity that was passed in for processing. If you include a lava template here, the action will instead set the attribute value to the output of this template. The mergefield to use for the entity is 'Entity.' For example, use {{ Entity.Name }} if the entity has a Name property. ", "Order": 4, "IsGridColumn": false, "DefaultValue": "", "IsMultiValue": false, "IsRequired": false, "IconCssClass": "", "AllowSearch": false, "IsIndexEnabled": false, "IsAnalytic": false, "IsAnalyticHistory": false, "IsActive": true, "EnableHistory": false, "PreHtml": null, "PostHtml": null, "AbbreviatedName": "Lava Template", "IsPublic": false, "ShowOnBulk": false, "CreatedDateTime": "2018-10-18T13:37:56.077", "ModifiedDateTime": "2018-10-18T13:37:56.077" }, "Transforms": {}, "References": [ { "Property": "FieldTypeId", "EntityType": "Rock.Model.FieldType", "Type": 3, "Data": "Rock.Field.Types.CodeEditorFieldType" }, { "Property": "EntityTypeId", "EntityType": "Rock.Model.EntityType", "Type": 2, "Data": "Rock.Model.WorkflowActionType" }, { "Property": "EntityTypeQualifierValue", "EntityType": "Rock.Model.EntityType", "Type": 2, "Data": "Rock.Workflow.Action.SetAttributeFromEntity" } ] }, { "EntityType": "Rock.Model.AttributeQualifier", "Guid": "52be8512-12e8-44f4-9637-1c6d1b71b769", "GenerateNewGuid": false, "Properties": { "IsSystem": false, "Key": "editorHeight", "Value": "200" }, "Transforms": {}, "References": [ { "Property": "AttributeId", "EntityType": "Rock.Model.Attribute", "Type": 1, "Data": "00d8331d-3055-4531-b374-6b98a9a71d70" } ] }, { "EntityType": "Rock.Model.AttributeQualifier", "Guid": "bcb12106-b8ca-4d03-8f6a-f4c3a716d5ba", "GenerateNewGuid": false, "Properties": { "IsSystem": false, "Key": "editorMode", "Value": "Lava" }, "Transforms": {}, "References": [ { "Property": "AttributeId", "EntityType": "Rock.Model.Attribute", "Type": 1, "Data": "00d8331d-3055-4531-b374-6b98a9a71d70" } ] }, { "EntityType": "Rock.Model.AttributeQualifier", "Guid": "7688b928-dd43-4ba9-8239-b46f0902dc7b", "GenerateNewGuid": false, "Properties": { "IsSystem": false, "Key": "editorTheme", "Value": "Rock" }, "Transforms": {}, "References": [ { "Property": "AttributeId", "EntityType": "Rock.Model.Attribute", "Type": 1, "Data": "00d8331d-3055-4531-b374-6b98a9a71d70" } ] }, { "EntityType": "Rock.Model.AttributeValue", "Guid": "9e47e2e1-a70a-40b1-b198-613b03e74af9", "GenerateNewGuid": true, "Properties": { "IsSystem": false, "Value": "{{ Entity.PrimaryAlias.Guid }}", "ValueAsNumeric": null, "CreatedDateTime": "2020-07-08T09:40:57.5", "ModifiedDateTime": "2020-07-08T09:40:57.5" }, "Transforms": {}, "References": [ { "Property": "AttributeId", "EntityType": "Rock.Model.Attribute", "Type": 1, "Data": "00d8331d-3055-4531-b374-6b98a9a71d70" }, { "Property": "EntityId", "EntityType": "Rock.Model.WorkflowActionType", "Type": 1, "Data": "9a98db33-81e9-4748-8b98-c079211e58a3" } ] }, { "EntityType": "Rock.Model.WorkflowActionType", "Guid": "5b02dec8-38ee-4a3e-9295-9e0fafbe34f3", "GenerateNewGuid": true, "Properties": { "Name": "Show Error Message", "Order": 1, "IsActionCompletedOnSuccess": true, "IsActivityCompletedOnSuccess": true, "CriteriaAttributeGuid": "a5300f3e-1df8-4954-b0a4-0e024a38ffb9", "CriteriaComparisonType": 32, "CriteriaValue": "", "CreatedDateTime": "2020-07-08T09:16:05.703", "ModifiedDateTime": "2020-07-08T09:16:05.703" }, "Transforms": {}, "References": [ { "Property": "ActivityTypeId", "EntityType": "Rock.Model.WorkflowActivityType", "Type": 1, "Data": "164554d7-1892-4104-94d5-d12b518eed5f" }, { "Property": "EntityTypeId", "EntityType": "Rock.Model.EntityType", "Type": 2, "Data": "Rock.Workflow.Action.ShowHtml" } ] }, { "EntityType": "Rock.Model.Attribute", "Guid": "d61a5dfb-3187-4498-aea9-38a5ff8ffe07", "GenerateNewGuid": false, "Properties": { "IsSystem": false, "EntityTypeQualifierColumn": "EntityTypeId", "Key": "HTML", "Name": "HTML", "Description": "The HTML to show. ", "Order": 0, "IsGridColumn": false, "DefaultValue": "", "IsMultiValue": false, "IsRequired": true, "IconCssClass": "", "AllowSearch": false, "IsIndexEnabled": false, "IsAnalytic": false, "IsAnalyticHistory": false, "IsActive": true, "EnableHistory": false, "PreHtml": null, "PostHtml": null, "AbbreviatedName": "HTML", "IsPublic": false, "ShowOnBulk": false, "CreatedDateTime": "2018-10-18T13:37:56.03", "ModifiedDateTime": "2018-10-18T13:37:56.03" }, "Transforms": {}, "References": [ { "Property": "FieldTypeId", "EntityType": "Rock.Model.FieldType", "Type": 3, "Data": "Rock.Field.Types.CodeEditorFieldType" }, { "Property": "EntityTypeId", "EntityType": "Rock.Model.EntityType", "Type": 2, "Data": "Rock.Model.WorkflowActionType" }, { "Property": "EntityTypeQualifierValue", "EntityType": "Rock.Model.EntityType", "Type": 2, "Data": "Rock.Workflow.Action.ShowHtml" } ] }, { "EntityType": "Rock.Model.AttributeQualifier", "Guid": "1b49ab47-0032-4c0d-8a49-37533c17f419", "GenerateNewGuid": false, "Properties": { "IsSystem": false, "Key": "editorHeight", "Value": "200" }, "Transforms": {}, "References": [ { "Property": "AttributeId", "EntityType": "Rock.Model.Attribute", "Type": 1, "Data": "d61a5dfb-3187-4498-aea9-38a5ff8ffe07" } ] }, { "EntityType": "Rock.Model.AttributeQualifier", "Guid": "89b63152-95fe-4c12-a6a3-fbf9948a1fc6", "GenerateNewGuid": false, "Properties": { "IsSystem": false, "Key": "editorMode", "Value": "Html" }, "Transforms": {}, "References": [ { "Property": "AttributeId", "EntityType": "Rock.Model.Attribute", "Type": 1, "Data": "d61a5dfb-3187-4498-aea9-38a5ff8ffe07" } ] }, { "EntityType": "Rock.Model.AttributeQualifier", "Guid": "e17ba7a6-e41f-4275-8e35-107c5b9afce6", "GenerateNewGuid": false, "Properties": { "IsSystem": false, "Key": "editorTheme", "Value": "Rock" }, "Transforms": {}, "References": [ { "Property": "AttributeId", "EntityType": "Rock.Model.Attribute", "Type": 1, "Data": "d61a5dfb-3187-4498-aea9-38a5ff8ffe07" } ] }, { "EntityType": "Rock.Model.AttributeValue", "Guid": "96f4f309-2f18-4744-84ad-81eebbb53411", "GenerateNewGuid": true, "Properties": { "IsSystem": false, "Value": "
\n Sorry, could not determine the person to clear preferences for. Make sure to run this workflow from the Actions menu on a person profile.\n
", "ValueAsNumeric": null, "CreatedDateTime": "2020-07-08T09:16:05.83", "ModifiedDateTime": "2020-07-08T09:16:05.83" }, "Transforms": {}, "References": [ { "Property": "AttributeId", "EntityType": "Rock.Model.Attribute", "Type": 1, "Data": "d61a5dfb-3187-4498-aea9-38a5ff8ffe07" }, { "Property": "EntityId", "EntityType": "Rock.Model.WorkflowActionType", "Type": 1, "Data": "5b02dec8-38ee-4a3e-9295-9e0fafbe34f3" } ] }, { "EntityType": "Rock.Model.Attribute", "Guid": "2464886d-7916-42f8-b9a4-f9cfdbdff3ef", "GenerateNewGuid": false, "Properties": { "IsSystem": false, "EntityTypeQualifierColumn": "EntityTypeId", "Key": "Order", "Name": "Order", "Description": "The order that this service should be used (priority)", "Order": 0, "IsGridColumn": false, "DefaultValue": "", "IsMultiValue": false, "IsRequired": true, "IconCssClass": "", "AllowSearch": false, "IsIndexEnabled": false, "IsAnalytic": false, "IsAnalyticHistory": false, "IsActive": true, "EnableHistory": false, "PreHtml": null, "PostHtml": null, "AbbreviatedName": "Order", "IsPublic": false, "ShowOnBulk": false, "CreatedDateTime": "2018-10-18T13:37:56.043", "ModifiedDateTime": "2018-10-18T13:37:56.043" }, "Transforms": {}, "References": [ { "Property": "FieldTypeId", "EntityType": "Rock.Model.FieldType", "Type": 3, "Data": "Rock.Field.Types.IntegerFieldType" }, { "Property": "EntityTypeId", "EntityType": "Rock.Model.EntityType", "Type": 2, "Data": "Rock.Model.WorkflowActionType" }, { "Property": "EntityTypeQualifierValue", "EntityType": "Rock.Model.EntityType", "Type": 2, "Data": "Rock.Workflow.Action.ShowHtml" } ] }, { "EntityType": "Rock.Model.Attribute", "Guid": "cc8c75fd-134f-4b76-a777-2c0c13d8fd3f", "GenerateNewGuid": false, "Properties": { "IsSystem": false, "EntityTypeQualifierColumn": "EntityTypeId", "Key": "Active", "Name": "Active", "Description": "Should Service be used?", "Order": 0, "IsGridColumn": false, "DefaultValue": "False", "IsMultiValue": false, "IsRequired": false, "IconCssClass": "", "AllowSearch": false, "IsIndexEnabled": false, "IsAnalytic": false, "IsAnalyticHistory": false, "IsActive": true, "EnableHistory": false, "PreHtml": null, "PostHtml": null, "AbbreviatedName": "Active", "IsPublic": false, "ShowOnBulk": false, "CreatedDateTime": "2018-10-18T13:37:56.043", "ModifiedDateTime": "2018-10-18T13:37:56.043" }, "Transforms": {}, "References": [ { "Property": "FieldTypeId", "EntityType": "Rock.Model.FieldType", "Type": 3, "Data": "Rock.Field.Types.BooleanFieldType" }, { "Property": "EntityTypeId", "EntityType": "Rock.Model.EntityType", "Type": 2, "Data": "Rock.Model.WorkflowActionType" }, { "Property": "EntityTypeQualifierValue", "EntityType": "Rock.Model.EntityType", "Type": 2, "Data": "Rock.Workflow.Action.ShowHtml" } ] }, { "EntityType": "Rock.Model.AttributeValue", "Guid": "127eae58-89cb-4826-85fa-f557dd322dd4", "GenerateNewGuid": true, "Properties": { "IsSystem": false, "Value": "False", "ValueAsNumeric": null, "CreatedDateTime": "2020-07-08T09:16:05.83", "ModifiedDateTime": "2020-07-08T09:16:05.83" }, "Transforms": {}, "References": [ { "Property": "AttributeId", "EntityType": "Rock.Model.Attribute", "Type": 1, "Data": "cc8c75fd-134f-4b76-a777-2c0c13d8fd3f" }, { "Property": "EntityId", "EntityType": "Rock.Model.WorkflowActionType", "Type": 1, "Data": "5b02dec8-38ee-4a3e-9295-9e0fafbe34f3" } ] }, { "EntityType": "Rock.Model.Attribute", "Guid": "09054c70-c7aa-4c8d-a95c-6c303f513b12", "GenerateNewGuid": false, "Properties": { "IsSystem": false, "EntityTypeQualifierColumn": "EntityTypeId", "Key": "HideStatusMessage", "Name": "Hide Status Message", "Description": "Whether or not to hide the built-in status message.", "Order": 1, "IsGridColumn": false, "DefaultValue": "False", "IsMultiValue": false, "IsRequired": false, "IconCssClass": "", "AllowSearch": false, "IsIndexEnabled": false, "IsAnalytic": false, "IsAnalyticHistory": false, "IsActive": true, "EnableHistory": false, "PreHtml": null, "PostHtml": null, "AbbreviatedName": "Hide Status Message", "IsPublic": false, "ShowOnBulk": false, "CreatedDateTime": "2018-10-18T13:37:56.03", "ModifiedDateTime": "2018-10-18T13:37:56.03" }, "Transforms": {}, "References": [ { "Property": "FieldTypeId", "EntityType": "Rock.Model.FieldType", "Type": 3, "Data": "Rock.Field.Types.BooleanFieldType" }, { "Property": "EntityTypeId", "EntityType": "Rock.Model.EntityType", "Type": 2, "Data": "Rock.Model.WorkflowActionType" }, { "Property": "EntityTypeQualifierValue", "EntityType": "Rock.Model.EntityType", "Type": 2, "Data": "Rock.Workflow.Action.ShowHtml" } ] }, { "EntityType": "Rock.Model.AttributeValue", "Guid": "d613bb28-483a-4799-90d9-453f5e669f8b", "GenerateNewGuid": true, "Properties": { "IsSystem": false, "Value": "True", "ValueAsNumeric": null, "CreatedDateTime": "2020-07-08T09:16:05.83", "ModifiedDateTime": "2020-07-08T09:16:48.083" }, "Transforms": {}, "References": [ { "Property": "AttributeId", "EntityType": "Rock.Model.Attribute", "Type": 1, "Data": "09054c70-c7aa-4c8d-a95c-6c303f513b12" }, { "Property": "EntityId", "EntityType": "Rock.Model.WorkflowActionType", "Type": 1, "Data": "5b02dec8-38ee-4a3e-9295-9e0fafbe34f3" } ] }, { "EntityType": "Rock.Model.WorkflowActionType", "Guid": "f1ec7bc4-c22b-4032-9130-51323bf76c0b", "GenerateNewGuid": true, "Properties": { "Name": "Delete Preferences", "Order": 2, "IsActionCompletedOnSuccess": true, "IsActivityCompletedOnSuccess": false, "CriteriaAttributeGuid": null, "CriteriaComparisonType": 1, "CriteriaValue": "", "CreatedDateTime": "2020-07-08T09:16:05.703", "ModifiedDateTime": "2020-07-08T09:16:05.703" }, "Transforms": {}, "References": [ { "Property": "ActivityTypeId", "EntityType": "Rock.Model.WorkflowActivityType", "Type": 1, "Data": "164554d7-1892-4104-94d5-d12b518eed5f" }, { "Property": "EntityTypeId", "EntityType": "Rock.Model.EntityType", "Type": 2, "Data": "Rock.Workflow.Action.RunSQL" } ] }, { "EntityType": "Rock.Model.Attribute", "Guid": "f3b9908b-096f-460b-8320-122cf046d1f9", "GenerateNewGuid": false, "Properties": { "IsSystem": true, "EntityTypeQualifierColumn": "EntityTypeId", "Key": "SQLQuery", "Name": "SQLQuery", "Description": "The SQL query to run. ", "Order": 0, "IsGridColumn": false, "DefaultValue": "", "IsMultiValue": false, "IsRequired": true, "IconCssClass": null, "AllowSearch": false, "IsIndexEnabled": false, "IsAnalytic": false, "IsAnalyticHistory": false, "IsActive": true, "EnableHistory": false, "PreHtml": null, "PostHtml": null, "AbbreviatedName": "SQLQuery", "IsPublic": false, "ShowOnBulk": false, "CreatedDateTime": null, "ModifiedDateTime": "2018-10-18T13:37:55.997" }, "Transforms": {}, "References": [ { "Property": "FieldTypeId", "EntityType": "Rock.Model.FieldType", "Type": 3, "Data": "Rock.Field.Types.CodeEditorFieldType" }, { "Property": "EntityTypeId", "EntityType": "Rock.Model.EntityType", "Type": 2, "Data": "Rock.Model.WorkflowActionType" }, { "Property": "EntityTypeQualifierValue", "EntityType": "Rock.Model.EntityType", "Type": 2, "Data": "Rock.Workflow.Action.RunSQL" } ] }, { "EntityType": "Rock.Model.AttributeQualifier", "Guid": "61a950e7-3335-4977-bcbc-4d964859fe5e", "GenerateNewGuid": false, "Properties": { "IsSystem": false, "Key": "editorHeight", "Value": "400" }, "Transforms": {}, "References": [ { "Property": "AttributeId", "EntityType": "Rock.Model.Attribute", "Type": 1, "Data": "f3b9908b-096f-460b-8320-122cf046d1f9" } ] }, { "EntityType": "Rock.Model.AttributeQualifier", "Guid": "bfe13902-ba56-487a-8b89-8f4c0b012ae8", "GenerateNewGuid": false, "Properties": { "IsSystem": false, "Key": "editorMode", "Value": "Sql" }, "Transforms": {}, "References": [ { "Property": "AttributeId", "EntityType": "Rock.Model.Attribute", "Type": 1, "Data": "f3b9908b-096f-460b-8320-122cf046d1f9" } ] }, { "EntityType": "Rock.Model.AttributeQualifier", "Guid": "da59e934-30ed-4cfe-a600-ad2ff9c2e181", "GenerateNewGuid": false, "Properties": { "IsSystem": false, "Key": "editorTheme", "Value": "Rock" }, "Transforms": {}, "References": [ { "Property": "AttributeId", "EntityType": "Rock.Model.Attribute", "Type": 1, "Data": "f3b9908b-096f-460b-8320-122cf046d1f9" } ] }, { "EntityType": "Rock.Model.AttributeValue", "Guid": "07af162a-8d52-467a-9adc-19184be44997", "GenerateNewGuid": true, "Properties": { "IsSystem": false, "Value": "DECLARE @PersonId int = {{ Workflow | Attribute:'Person','Id' }}\n\nDECLARE @EntityTypeId int = ( SELECT TOP 1 [Id] FROM [EntityType] WHERE [Name] = 'Rock.Model.Person.Value' )\nDELETE V\nFROM [Attribute] A\nINNER JOIN [AttributeValue] V \n\tON V.[AttributeId] = A.[Id] \n\tAND V.[EntityId] = @PersonId\nWHERE A.[EntityTypeId] = @EntityTypeId\n", "ValueAsNumeric": null, "CreatedDateTime": "2020-07-08T09:16:05.86", "ModifiedDateTime": "2020-07-08T09:18:28.16" }, "Transforms": {}, "References": [ { "Property": "AttributeId", "EntityType": "Rock.Model.Attribute", "Type": 1, "Data": "f3b9908b-096f-460b-8320-122cf046d1f9" }, { "Property": "EntityId", "EntityType": "Rock.Model.WorkflowActionType", "Type": 1, "Data": "f1ec7bc4-c22b-4032-9130-51323bf76c0b" } ] }, { "EntityType": "Rock.Model.Attribute", "Guid": "a18c3143-0586-4565-9f36-e603bc674b4e", "GenerateNewGuid": false, "Properties": { "IsSystem": true, "EntityTypeQualifierColumn": "EntityTypeId", "Key": "Active", "Name": "Active", "Description": "Should Service be used?", "Order": 0, "IsGridColumn": false, "DefaultValue": "False", "IsMultiValue": false, "IsRequired": false, "IconCssClass": null, "AllowSearch": false, "IsIndexEnabled": false, "IsAnalytic": false, "IsAnalyticHistory": false, "IsActive": true, "EnableHistory": false, "PreHtml": null, "PostHtml": null, "AbbreviatedName": "Active", "IsPublic": false, "ShowOnBulk": false, "CreatedDateTime": null, "ModifiedDateTime": null }, "Transforms": {}, "References": [ { "Property": "FieldTypeId", "EntityType": "Rock.Model.FieldType", "Type": 3, "Data": "Rock.Field.Types.BooleanFieldType" }, { "Property": "EntityTypeId", "EntityType": "Rock.Model.EntityType", "Type": 2, "Data": "Rock.Model.WorkflowActionType" }, { "Property": "EntityTypeQualifierValue", "EntityType": "Rock.Model.EntityType", "Type": 2, "Data": "Rock.Workflow.Action.RunSQL" } ] }, { "EntityType": "Rock.Model.AttributeValue", "Guid": "35c18284-daee-4436-ae33-c5526d63a98a", "GenerateNewGuid": true, "Properties": { "IsSystem": false, "Value": "False", "ValueAsNumeric": null, "CreatedDateTime": "2020-07-08T09:16:05.86", "ModifiedDateTime": "2020-07-08T09:16:05.86" }, "Transforms": {}, "References": [ { "Property": "AttributeId", "EntityType": "Rock.Model.Attribute", "Type": 1, "Data": "a18c3143-0586-4565-9f36-e603bc674b4e" }, { "Property": "EntityId", "EntityType": "Rock.Model.WorkflowActionType", "Type": 1, "Data": "f1ec7bc4-c22b-4032-9130-51323bf76c0b" } ] }, { "EntityType": "Rock.Model.Attribute", "Guid": "fa7c685d-8636-41ef-9998-90fff3998f76", "GenerateNewGuid": false, "Properties": { "IsSystem": true, "EntityTypeQualifierColumn": "EntityTypeId", "Key": "Order", "Name": "Order", "Description": "The order that this service should be used (priority)", "Order": 0, "IsGridColumn": false, "DefaultValue": "", "IsMultiValue": false, "IsRequired": true, "IconCssClass": null, "AllowSearch": false, "IsIndexEnabled": false, "IsAnalytic": false, "IsAnalyticHistory": false, "IsActive": true, "EnableHistory": false, "PreHtml": null, "PostHtml": null, "AbbreviatedName": "Order", "IsPublic": false, "ShowOnBulk": false, "CreatedDateTime": null, "ModifiedDateTime": "2018-10-18T13:37:56.013" }, "Transforms": {}, "References": [ { "Property": "FieldTypeId", "EntityType": "Rock.Model.FieldType", "Type": 3, "Data": "Rock.Field.Types.IntegerFieldType" }, { "Property": "EntityTypeId", "EntityType": "Rock.Model.EntityType", "Type": 2, "Data": "Rock.Model.WorkflowActionType" }, { "Property": "EntityTypeQualifierValue", "EntityType": "Rock.Model.EntityType", "Type": 2, "Data": "Rock.Workflow.Action.RunSQL" } ] }, { "EntityType": "Rock.Model.Attribute", "Guid": "ea9a026a-934f-4920-97b1-9734795127ed", "GenerateNewGuid": false, "Properties": { "IsSystem": false, "EntityTypeQualifierColumn": "EntityTypeId", "Key": "Parameters", "Name": "Parameters", "Description": "The parameters to supply to the SQL query. ", "Order": 1, "IsGridColumn": false, "DefaultValue": "", "IsMultiValue": false, "IsRequired": false, "IconCssClass": "", "AllowSearch": false, "IsIndexEnabled": false, "IsAnalytic": false, "IsAnalyticHistory": false, "IsActive": true, "EnableHistory": false, "PreHtml": null, "PostHtml": null, "AbbreviatedName": "Parameters", "IsPublic": false, "ShowOnBulk": false, "CreatedDateTime": "2018-10-18T13:45:22.247", "ModifiedDateTime": "2018-10-18T13:45:22.247" }, "Transforms": {}, "References": [ { "Property": "FieldTypeId", "EntityType": "Rock.Model.FieldType", "Type": 3, "Data": "Rock.Field.Types.KeyValueListFieldType" }, { "Property": "EntityTypeId", "EntityType": "Rock.Model.EntityType", "Type": 2, "Data": "Rock.Model.WorkflowActionType" }, { "Property": "EntityTypeQualifierValue", "EntityType": "Rock.Model.EntityType", "Type": 2, "Data": "Rock.Workflow.Action.RunSQL" } ] }, { "EntityType": "Rock.Model.AttributeQualifier", "Guid": "795644d9-d877-4e51-bedd-a20cbd11ba4b", "GenerateNewGuid": false, "Properties": { "IsSystem": false, "Key": "displayvaluefirst", "Value": "False" }, "Transforms": {}, "References": [ { "Property": "AttributeId", "EntityType": "Rock.Model.Attribute", "Type": 1, "Data": "ea9a026a-934f-4920-97b1-9734795127ed" } ] }, { "EntityType": "Rock.Model.AttributeQualifier", "Guid": "cdcff4c2-ff4a-499b-a04f-cdefc7b1a80b", "GenerateNewGuid": false, "Properties": { "IsSystem": false, "Key": "keyprompt", "Value": "Parameter" }, "Transforms": {}, "References": [ { "Property": "AttributeId", "EntityType": "Rock.Model.Attribute", "Type": 1, "Data": "ea9a026a-934f-4920-97b1-9734795127ed" } ] }, { "EntityType": "Rock.Model.Attribute", "Guid": "56997192-2545-4ea1-b5b2-313b04588984", "GenerateNewGuid": false, "Properties": { "IsSystem": true, "EntityTypeQualifierColumn": "EntityTypeId", "Key": "ResultAttribute", "Name": "Result Attribute", "Description": "An optional attribute to set to the scaler result of SQL query.", "Order": 2, "IsGridColumn": false, "DefaultValue": "", "IsMultiValue": false, "IsRequired": false, "IconCssClass": null, "AllowSearch": false, "IsIndexEnabled": false, "IsAnalytic": false, "IsAnalyticHistory": false, "IsActive": true, "EnableHistory": false, "PreHtml": null, "PostHtml": null, "AbbreviatedName": "Result Attribute", "IsPublic": false, "ShowOnBulk": false, "CreatedDateTime": null, "ModifiedDateTime": "2018-10-18T13:45:22.45" }, "Transforms": {}, "References": [ { "Property": "FieldTypeId", "EntityType": "Rock.Model.FieldType", "Type": 3, "Data": "Rock.Field.Types.WorkflowAttributeFieldType" }, { "Property": "EntityTypeId", "EntityType": "Rock.Model.EntityType", "Type": 2, "Data": "Rock.Model.WorkflowActionType" }, { "Property": "EntityTypeQualifierValue", "EntityType": "Rock.Model.EntityType", "Type": 2, "Data": "Rock.Workflow.Action.RunSQL" } ] }, { "EntityType": "Rock.Model.Attribute", "Guid": "9a567f6a-2a77-4ecd-80f7-bbd7d54e843c", "GenerateNewGuid": false, "Properties": { "IsSystem": false, "EntityTypeQualifierColumn": "EntityTypeId", "Key": "ContinueOnError", "Name": "Continue On Error", "Description": "Should processing continue even if SQL Error occurs?", "Order": 3, "IsGridColumn": false, "DefaultValue": "False", "IsMultiValue": false, "IsRequired": false, "IconCssClass": "", "AllowSearch": false, "IsIndexEnabled": false, "IsAnalytic": false, "IsAnalyticHistory": false, "IsActive": true, "EnableHistory": false, "PreHtml": null, "PostHtml": null, "AbbreviatedName": "Continue On Error", "IsPublic": false, "ShowOnBulk": false, "CreatedDateTime": "2018-10-18T13:37:56.013", "ModifiedDateTime": "2018-10-18T13:45:23.357" }, "Transforms": {}, "References": [ { "Property": "FieldTypeId", "EntityType": "Rock.Model.FieldType", "Type": 3, "Data": "Rock.Field.Types.BooleanFieldType" }, { "Property": "EntityTypeId", "EntityType": "Rock.Model.EntityType", "Type": 2, "Data": "Rock.Model.WorkflowActionType" }, { "Property": "EntityTypeQualifierValue", "EntityType": "Rock.Model.EntityType", "Type": 2, "Data": "Rock.Workflow.Action.RunSQL" } ] }, { "EntityType": "Rock.Model.AttributeValue", "Guid": "3e62ff21-d049-44a6-90ea-376ec33dc1fd", "GenerateNewGuid": true, "Properties": { "IsSystem": false, "Value": "False", "ValueAsNumeric": null, "CreatedDateTime": "2020-07-08T09:16:05.86", "ModifiedDateTime": "2020-07-08T09:16:05.86" }, "Transforms": {}, "References": [ { "Property": "AttributeId", "EntityType": "Rock.Model.Attribute", "Type": 1, "Data": "9a567f6a-2a77-4ecd-80f7-bbd7d54e843c" }, { "Property": "EntityId", "EntityType": "Rock.Model.WorkflowActionType", "Type": 1, "Data": "f1ec7bc4-c22b-4032-9130-51323bf76c0b" } ] }, { "EntityType": "Rock.Model.WorkflowActionType", "Guid": "47a6dc33-3c3b-4347-9bd5-f91a620e0e88", "GenerateNewGuid": true, "Properties": { "Name": "Show Message", "Order": 3, "IsActionCompletedOnSuccess": true, "IsActivityCompletedOnSuccess": true, "CriteriaAttributeGuid": null, "CriteriaComparisonType": 1, "CriteriaValue": "", "CreatedDateTime": "2020-07-08T09:16:05.703", "ModifiedDateTime": "2020-07-08T09:16:05.703" }, "Transforms": {}, "References": [ { "Property": "ActivityTypeId", "EntityType": "Rock.Model.WorkflowActivityType", "Type": 1, "Data": "164554d7-1892-4104-94d5-d12b518eed5f" }, { "Property": "EntityTypeId", "EntityType": "Rock.Model.EntityType", "Type": 2, "Data": "Rock.Workflow.Action.ShowHtml" } ] }, { "EntityType": "Rock.Model.AttributeValue", "Guid": "d5c29c28-c77d-42b8-85eb-98a26c496bc0", "GenerateNewGuid": true, "Properties": { "IsSystem": false, "Value": "
\n All of {{ Workflow | Attribute:'Person','NickName' | Possessive }} Rock preferences have been cleared.\n
", "ValueAsNumeric": null, "CreatedDateTime": "2020-07-08T09:16:05.89", "ModifiedDateTime": "2020-07-08T09:16:05.89" }, "Transforms": {}, "References": [ { "Property": "AttributeId", "EntityType": "Rock.Model.Attribute", "Type": 1, "Data": "d61a5dfb-3187-4498-aea9-38a5ff8ffe07" }, { "Property": "EntityId", "EntityType": "Rock.Model.WorkflowActionType", "Type": 1, "Data": "47a6dc33-3c3b-4347-9bd5-f91a620e0e88" } ] }, { "EntityType": "Rock.Model.AttributeValue", "Guid": "a7ea7a69-4fa0-4bd5-85f3-73b04aeb6058", "GenerateNewGuid": true, "Properties": { "IsSystem": false, "Value": "False", "ValueAsNumeric": null, "CreatedDateTime": "2020-07-08T09:16:05.89", "ModifiedDateTime": "2020-07-08T09:16:05.89" }, "Transforms": {}, "References": [ { "Property": "AttributeId", "EntityType": "Rock.Model.Attribute", "Type": 1, "Data": "cc8c75fd-134f-4b76-a777-2c0c13d8fd3f" }, { "Property": "EntityId", "EntityType": "Rock.Model.WorkflowActionType", "Type": 1, "Data": "47a6dc33-3c3b-4347-9bd5-f91a620e0e88" } ] }, { "EntityType": "Rock.Model.AttributeValue", "Guid": "a1a94c6f-e801-4e78-a20d-c1cdf1424acf", "GenerateNewGuid": true, "Properties": { "IsSystem": false, "Value": "True", "ValueAsNumeric": null, "CreatedDateTime": "2020-07-08T09:16:05.89", "ModifiedDateTime": "2020-07-08T09:16:48.097" }, "Transforms": {}, "References": [ { "Property": "AttributeId", "EntityType": "Rock.Model.Attribute", "Type": 1, "Data": "09054c70-c7aa-4c8d-a95c-6c303f513b12" }, { "Property": "EntityId", "EntityType": "Rock.Model.WorkflowActionType", "Type": 1, "Data": "47a6dc33-3c3b-4347-9bd5-f91a620e0e88" } ] }, { "EntityType": "Rock.Model.Attribute", "Guid": "a5300f3e-1df8-4954-b0a4-0e024a38ffb9", "GenerateNewGuid": true, "Properties": { "IsSystem": false, "EntityTypeQualifierColumn": "WorkflowTypeId", "Key": "Person", "Name": "Person", "Description": "", "Order": 0, "IsGridColumn": false, "DefaultValue": "", "IsMultiValue": false, "IsRequired": false, "IconCssClass": "", "AllowSearch": false, "IsIndexEnabled": false, "IsAnalytic": false, "IsAnalyticHistory": false, "IsActive": true, "EnableHistory": false, "PreHtml": "", "PostHtml": "", "AbbreviatedName": "Person", "IsPublic": false, "ShowOnBulk": false, "CreatedDateTime": null, "ModifiedDateTime": "2020-07-08T09:43:42.22" }, "Transforms": {}, "References": [ { "Property": "FieldTypeId", "EntityType": "Rock.Model.FieldType", "Type": 3, "Data": "Rock.Field.Types.PersonFieldType" }, { "Property": "EntityTypeId", "EntityType": "Rock.Model.EntityType", "Type": 2, "Data": "Rock.Model.Workflow" }, { "Property": "EntityTypeQualifierValue", "EntityType": "Rock.Model.WorkflowType", "Type": 1, "Data": "dcaaad07-e5f4-4ce5-aa02-157aacf78fa6" } ] }, { "EntityType": "Rock.Model.AttributeQualifier", "Guid": "e5d1af9c-e1ff-4795-a1b6-38539cbf03d6", "GenerateNewGuid": true, "Properties": { "IsSystem": false, "Key": "EnableSelfSelection", "Value": "False" }, "Transforms": {}, "References": [ { "Property": "AttributeId", "EntityType": "Rock.Model.Attribute", "Type": 1, "Data": "a5300f3e-1df8-4954-b0a4-0e024a38ffb9" } ] } ], "RootEntities": [ "dcaaad07-e5f4-4ce5-aa02-157aacf78fa6" ] }