Evaluate Query Activity (how-to)

Functionality

This article describes how to use the “Evaluate Query Activity“. We are going to show you how to get a true or false value that can be used as a condition in a workflow.

Settings

Parameters

Input-data

Output-data

Accessing Parameters

CurrentUser = "@#@USER@#@";

ApplicationSettings = "@#@APPLICATIONSETTINGS@#@";

NormalParameter = "#@#@#";

RelativeDate = "@#DATE#@";

Relative = "#@@@#";

Example

1. Go to the Flow tab and press create new workflow.

2. Drag-and-drop the “Evaluate Query Activity“ to your start activity.

3. Double-click the in-going branch and bind a parameter. This should be an entity that we later on can browse its parameters.
   
   

   

4. Select the parameters that you would like to query, it can be a single parameter. Or you can make a combination of different parameters.
   
   

   

5. Add an activity of your choice to follow upon the result of your query. In our case I would like to download a file from the entity. If the condition is “True” otherwise I want to cancel the workflow.

6. Drop both activities on top of the “Evaluate Query Activity” to get two branches going to different activities. In our case I will use “Evaluate Expression” (is explained in another article) followed by a “Download File Activity”. If “False” we want to cancel the workflow with a message to the user.
   

   

7. Double-click the in-going branch to the activity that you would like to occur when the condition is true.

8. Add a criteria that is “QueryResult” Equals “True”

9. Make sure to also bind a value to the next activity if necessary.
   
   

   

10. As the “Evaluate Query Activity” result only can be “True” or “False”. We only need to set a criteria for one branch. The other branch will be activated automatically if the result is equal to “False”

11. For the download activity we assign the in-going parameters accordingly:

    1. Expression result (from Evaluate Expression) → FileName

    2. DocumentData (from RootEntity) → FileData

12. 

13. And for the branch that represents the “False” condition we added:

    1. Show Message Box, it can be configured with an in-going parameter (Entity)

    2. 

    3. The “Cancel Workflow” does not have to be configured.

       
       

Related articles