p_pane_objlist
p_pane_objlist 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 |
---|---|
@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: |
@child_obj | Mandatory input parameter. Select which object values should be shown in the list. |
@child_objval | Optional parameter. Enter a value filter. For example, only ITEMs starting with 1 should be visible in the list (1*). Leave blank if all values should be shown. |
@client_id | The logged in client is automatically sent into the pane. |
@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 | |
@order_by | Optional parameter. If the list should be ordered in any other way than by object ID column, then enter the column. |
@p_struct_authority | |
@parent_obj | Optional parameter. Select a parent object from the list if this list box should be dependent on another list box in the pane. Note: In order for the dependency to work it is crucial that an object tree for ITEMGRP:ITEM has been defined in Bizview (if p_pane_objlist is used). |
@parent_objval | Optional parameter. Specify from which list box the ITEMGRP value should be fetched |
@template_type | The template type of the generated form (i.e. FORM/REPORT) is automatically sent into the pane. |
@user_id | The logged in user is automatically sent into the pane. |
@version_id |
Input Parameters
@client
The logged in client is automatically sent into the pane.
@user
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_obj
Mandatory input parameter. Select which object values should be shown in the list.
@child_objval
Optional parameter. Enter a value filter. For example, only ITEMs starting with 1 should be visible in the list (1*). Leave blank if all values should be shown.
@parent_obj
Optional parameter. Select a parent object from the list if this list box should be dependent on another list box in the pane.
Note: In order for the dependency to work it is crucial that an object tree for ITEMGRP:ITEM has been defined in Bizview (if p_pane_objlist is used).
@parent_objval
Optional parameter. Specify from which list box the ITEMGRP value should be fetched.
Select the black square to display a list of available list boxes within the pane. Select from which list box the ITEMGRP value should be fetched. The tag for each list box is shown, if any list box is not named with a tag, then the standard name "MultiDropDown_nn" displays. Hover over the values in the @parent_objval list to highlight the list box (orange border).
In this example, we want the selection made in the Item group list box to affect the data returned in the Item list box; therefore, ITEMGRP is chosen in the @parent_objval field:
@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:
@orderby
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: