← 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: Table button, Button
Available from version: 1.0.12
Description
Displays database data in a table in a new window. The window allows you to sort and filter data, as well as export selected rows to a specified dynamic table.
Example new window preview
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 |
|---|---|---|
Table button | Activates action | Pressing the button |
| Button | Activates action | Pressing the button |
Configuration parameters
Parameter name | From version | Description | Paremeter type | Default value | Field type | Comments and restrictions | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Database Name* | 1.0.12 | Name set in dbExplorer | Text | Editable field |
| |||||||||||||
| Query key | 1.0.12 | The key (name) of the query in the pm_dbqueries table | Text | Editable field | ||||||||||||||
| Query Parameters | 1.0.12 | Values of query parameters | An array of text values | Editable field | ||||||||||||||
| Types of query parameters | 1.0.12 | An array of text values | Drop-down list | Types are selected from the values:
| ||||||||||||||
| Column names* | 1.0.12 | The names of the columns displayed in the table in a new window | An array of text values | Editable field | ||||||||||||||
| Column indexes | 1.0.12 | Indexes of columns displayed in a new window - should coincide with the columns transferred from the query | An array of text values | Editable field | ||||||||||||||
| Variables to set | 1.0.12 | Variables to which selected values from mapped columns will be assigned. | Array of variables | Editable field | ||||||||||||||
| Types of columns | 1.0.60 | Types of columns in the database - information needed to filter columns | An array of text values | Drop-down list |
| |||||||||||||
| Hidden | 1.0.68 | Specifies whether selected data downloaded to the table should be hidden | An array of boolean values | Editable field | ||||||||||||||
| Number of rows | 1.0.12 | Number of lines on one page | Integer | Editable field | ||||||||||||||
| Override data | 1.0.12 | Clears tables before saving data | Boolean | Editable field | ||||||||||||||
| Moving | 1.0.12 | Button that allows data to be transferred to a dynamic table | Boolean | Editable field | ||||||||||||||
Multiple rows selection
| 1.0.90 | Parameter specifies if user can select many rows or just one. | Boolean | Editable field | ||||||||||||||
| Numbering | 1.0.12 | Enables / disables row numbering | Boolean | Editable field | ||||||||||||||
| Variable set id | 1.0.78 | Specifies to which dynamic table the data from the database presented in the new window is to be exported | Text | Editable field | The field is visible only if the action is placed on a regular button. Parameter is marked as required when action is set on the regular button and "moving" is set to true.. | |||||||||||||
| Multiple value support | 1.0.89 | 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:
| |||||||||||||
| Context menu* | 1.0.110 | Displays a context menu for each column. It allows you to select the sorting direction and hide / show selected columns in the table. | Boolean | Editable field | ||||||||||||||
| Save the form after the data has been transferred to the table* | 1.0.138 | Saves the state of the form after the data has been transferred from the window to the table. | Boolean | No | Editable field | |||||||||||||
| Execute automapping | 1.0.139 | Executes automapping (may cause performance issues). | Boolean | No | Editable field | Executing automapping may cause severe performance issues - especially with large numbers. Automapping execution could reach database, network resource or data source and performance drops due to the extra queries being made. | ||||||||||||
| Window name | 1.0.139 | Title of the window displaying data from the selected database. If the parameter is left empty, the default name of the window will be 'Add data to dynamic table'. The default name is properly translated depending on the language version of the using PlusWorkflow system. In order to use your own translation key for the window name, it is recommended to define the translate function in this parameter. | Text | Editable field |
Parameter*- mandatory field
Configuration example
Action on table
Action on table button
Change log
1.0.12
- Adding a component
1.0.45
- Fix for placing parameters in the component
1.0.60
- Dynamic form + adding buttons select all, deselect all + filtering
1.0.61
- Support for adding a date type to the table
1.0.62
- Adding the option of placing a button on the table
1.0.65
- Case insensitive filtering
1.0.68
- Ability to add hidden columns to the table
1.0.71
- Acceleration of switching between successive pages of the window
1.0.72
- Calling a save function before getting data from table
1.0.78
- Putting an action under an ordinary button
1.0.89
- Allows to set form variables
1.0.97 (applicable documentation)
Adjusting action to the new component builder + removing the Button name parameter
1.0.108 (applicable documentation)
Ability to sort by columns.
1.0.110 (applicable documentation)
- Addition of the Context menu parameter
1.0.132
- Fixing the Deselect All button
1.0.134
- Possibility to call action on the process history page
- Table identifier is marked as required when action is set on the regular button
1.0.138 (applicable documentation)
- Added new parameter Save the form after the data has been transferred to the table
- Removed the possibility to create action by dragging it onto a table.
1.0.139 (applicable documentation)
- Adding Window name parameter
1.0.151
- The "Select All" and "Deselect All" buttons are hidden when the Select Multiple Rows parameter is set to NO.
Save the form after the data has been transferred to the table
Add Comment