P_pane_dimlists
p_pane_dimlists is a standard script that can be used to fill lists in a selection pane with content. This script gets data from the object values saved in Bizview and will also automatically add any object value authorizations that are defined for the logged in user.
This standard script does the following:
- Returns object values from the Bizview database
- Adds any existing user and/or organization object value authorization to the data set
- Reads existing object trees in order to manage dependent list boxes
When selecting the script in Pane Designer, the following parameters can be defined:
| Parameter | Description |
|---|---|
| @client_id | The logged in client is automatically sent into the pane. |
| @user_id | The logged in user is automatically sent into the pane. |
| @template_type | The template type of the generated form (i.e. FORM/REPORT) is automatically sent into the pane. |
| @child_dim | Select the dimension number of the object. |
| @child_objval | Enter the value of object. |
| @parent_dim | Select the dimension number of the object. |
| @parent_objval | Optional parameter. Specify from which list box the ITEMGRP value should be fetched |
| @active | Optional parameter. Enter a "1" if only active object values should be returned in the list box. If left empty, both active and inactive values will be returned in the list. |
| @order_by | Optional parameter. If the list should be ordered in any other way than by object ID column, then enter the column. |
| custom_list | Optional parameter. In addition to the data set returned, there is a possibility to add an extra first selection row. For example, if the user should be able to select all items, then a custom list can be specified. The value within square brackets is the value that is sent into the PANE worksheet. Thereafter, a descriptive text can be stated. |
| @objver_id | Optional parameter, Enter the value of object version to filter the list, if it is empty, it sets the value to 'BASE' |