Error
All the details for the utility category.
Creates a short link for a designated page's URL.
Will launch a selected job when executed.
Updates the provided Persisted Dataset
This action will run the 'Build Script' of a Persisted Dataset and update its value through using the provided Persisted Dataset's 'Access Key'.
If you select Delay Processing Until Complete, the action will wait until the persisted dataset is done being updated. Otherwise it will trigger the update to begin then continue before it's complete.
This block provides a large Lava editor for writing into an attribute.
Know SQL? Then the world is your oyster.
The Run SQL action is one of the most powerful actions in Rock workflows. It allows you to execute any SQL query you provide and store the results into an attribute on the workflow. This action is great for looking up data in the database and using it to make decisions in the workflow.
Note that the SQL you provide can contain Lava merge fields to help pass in attribute values for your SQL. Consider this example.
Say you wanted to get the gender of the person stored in the attribute Requester. You could use the SQL below to achieve this.
DECLARE @PersonAliasGuid uniqueidentifier = '{{ Workflow | Attribute:'Requestor','RawValue' }}' SELECT [Gender] FROM [Person] p INNER JOIN [PersonAlias] pa ON pa.PersonId = p.Id WHERE pa.[Guid] = @PersonAliasGuid --note gender is stored in the database as a number where 0 = Unknown, 1 = Male and 2=Female
When the action places the result of the SQL into the configured workflow attribute, the returned result must match the data type of the attribute. For instance, your SQL can not return text if the attribute configured is expecting a number. A few common attribute types that you will use often are listed below, each with what they are expecting as input.
Note: If you update something directly via SQL, the cache manager won't know about it so you'll need to take care of flushing it from cache yourself.
Need data from another website? Then this action is for you.
Get
Post
Put
Delete
Patch
Write to Interactions or it didn't happen!
In v14, in addition to a CurrentPerson lava object, there is also a new CurrentVisitor object which represents a person who is not yet known (not logged in). We just wanted to remind you about this in case you were trying do record an interaction for that 'person alias'.v14.0