If you have a problem understanding how the action works, check: Action, Conditional execution, Components parameters
Basic information
Category: Database
Action location: Form, Button, Variable
Previous names: Perform a query from the database
Available from version: 1.0.4
Description
The ac
Action call-up
Leaving an empty conditional field is equal to setting it to "true".
Action location | From version | Conditional execution parameter action | Action call-up condition |
|---|---|---|---|
Form | 1.0.32 | Call-up action | The "Conditional execution" parameter will return "true" |
| Variable | 1.0.4 | Activates action | Change the value of the variable on which the action is located |
Button | 1.0.4 | Activates action | Pressing the button |
Configuration parameters
Parameter name | From version | Description | Paremeter type | Default value | Field type | Comments and restrictions | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Database | 1.0.4 | The configuration name defined in the data explorer settings. | Text | Editable field |
| |||||||||
| Table with queries | 1.0.4 | The name of the table in which queries triggered by the application are stored. | Text | Editable field | The parameter is optional. If we do not complete it, the question is taken from here: Table with database queries | |||||||||
| Query Name* | 1.0.4 | ID of the query stored in the database. | Text | Editable field | ||||||||||
| Parameters for the query | 1.0.4 | An array of text values storing variables / constants for query parameters and type information. An example parameter is "value type" for constants and "@id_variable" for variables. When we want to pass a constant value that has more than one word, we write it in quotation marks "" or "'. Supported types are: string, integer and float. | An array of text values | Editable field | Since version 1.0.24 it is possible not to pass any parameters to the query. | |||||||||
| Target Variables* | 1.0.4 | Array of variables into which the values from the database are to reach. Binding based on the variable id and returned alias from the database. | Array of variables | Editable field | ||||||||||
| Dynamic table id | 1.0.4 | An optional parameter conditioning the saving of result data to a dynamic table. | Text | Editable field | ||||||||||
| Multiple value support | 1.0.11 | An optional parameter that allows handling of many values returned by the database dedicated to one header variable. | Text | Drop-down list | Possible parameter values:
| |||||||||
| Way of adding data* | 1.0.83 | Parameter that allows you to specify the way of adding data. There are 3 types to choose from:
| Text | Add values | Drop-down list |
Parameter*- mandatory field
Configuration example
Example of operation
An example of operation based on the action configuration below.
One document with the given index values is signed and its content with the signature will be saved as a new version of the document. After clicking on the button on the form under which the action is defined, a dialog box for entering the PIN code and selecting the certificate will open. In the "Certificate" field, you can choose from two certificate configuration items based on the "Available certificates" parameter configured in this action.
After approval, the document is signed. In this mode, the native Szafir application window does not open. The signature operation is entirely based on the contents of the certificate configuration file. After the action is completed, the signature operation summary window appears. During the action, the console of the SzafirHost application is launched.
Change log
1.0.0
- Adding a component
Package with a sample form using the action
