← Return to the list of available actions
If you have a problem understanding how the action works, check: Action, Conditional execution, Components parameters
Basic information
Category: Table
Action location: Form, Button
Available from version: 1.0.67
Description
The action searches for processes with the same values of the given form variables and displays feedback in the form of a window. The action is called after changing the given variables (if it was placed on the form) or after pressing the button (if it was placed on the button).
Action call-up
Leaving an empty conditional field is equal to setting it to "true".
Action location | Conditional execution parameter action | Action call-up condition |
|---|---|---|
Form | Activates action | Change of one of the variables specified in the "Variables detecting duplicate" or "Variables excluding potential duplicates" parameters |
Button | Activates action | Pressing the button |
Configuration parameters
Parameter name | From version | Description | Paremeter type | Default value | Field type | Comments and restrictions | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Variables detecting the duplicate | 1.0.67 | The action will search for processes with the same values of the given variables as those in the current process. The condition of finding a duplicate is created by combining subsequent variables with the conjunction "AND", ie if "Variable A" is equal to x and "Variable B" is equal to y, then the duplicate was found. | Array of variables | Editable field | No tabular variables, no date and time variable. | |||||||||
| Message | 1.0.67 | The content of the alert that will be displayed when duplicates are found | Text | Editable field | ||||||||||
| Variables that exclude potential duplicates | 1.0.67 | Variables which values from the following parameter excludes the given process from evaluation. If any of the values given is met, the duplicate found will be skipped (subsequent values are joined by an OR), e.g. If "Variable A" is equal to x OR "Variable B" is equal to y, exclude this process from checking. | Array of variables | Editable field | No tabular variables, no date and time variable. | |||||||||
| Values for exclusion variables | 1.0.67 | An array of values, each of which decides to exclude a potential duplicate from evaluation. | An array of text values | Editable field | ||||||||||
| Types of processes | 1.0.67 | We choose in which processes to look for a duplicate: open, closed or all. | Text | OPENED | Drop-down list |
| ||||||||
| Case sensitivity | 1.0.67 | Specifies whether to distinguish case sensitivity when searching indexes. | Boolean | Yes | Editable field | |||||||||
| Variables in the duplicate table | 1.0.67 | Specifies which variables to show in the duplicate table | Array of variables | Editable field | Possible tabular variables. | |||||||||
| Hidden | 1.0.67 | Specifies whether selected data downloaded to the table should be hidden | An array of boolean values | Editable field | ||||||||||
| Retrieve values from the selected row | 1.0.68 | It allows saving values from the table to variables on the form for the currently selected row using the button | Boolean | No | Editable field | |||||||||
| Variables from the table | 1.0.68 | Variables whose values are taken from the table | Array of variables | Editable field | Without tabular variables. | |||||||||
| Variables on the form | 1.0.68 | Variables on the form, whose values will be set | Array of variables | Editable field | Without tabular variables. | |||||||||
| Name of the button setting the data | 1.0.68 | The name of the button that will insert the values from the table into variables | Text | Editable field | ||||||||||
| The column with the process name | 1.0.70 | Adds a column to the duplicate table with the name of the duplicate process | Boolean | No | Editable field | |||||||||
Number of duplicates found | 1.0.75 | Sets the field to show the number of duplicates found | Variable | Editable field | The variable must be of the integer type | |||||||||
| Way of displaying duplicates | 1.0.75 | Sets the method for displaying information about duplicates. The available options are:None,Message about duplicates found (message window about found duplicates with the choice continue),Table with duplicates found (table od duplicates without message) | Text | Basic information about duplicates | Drop-down list | The selected option hides the following parameters:Variables in duplicates tableHiddenSection: Retriving data from duplicate processColumn with process name |
Parameter*- mandatory field
Configuration example
Change log
1.0.67
- Adding a component
1.0.68
- Retrieving values from duplicate processes
1.0.70
- Ability to add a column with the name of the process + formatting of numeric columns
1.0.75
Developing actions to search for duplicates
1.0.122
- Added list of duplicates in the window
1.0.131
- Fixing a problem related to missing set values after editing the field "Way of displaying duplicates"
0 Comments