P_Pane_Break_Objects
Feature available from Bizview version - Bizview 7.1
The procedure p_pane_break_objects is used to return objects that can be used in list box to select break object:
This procedure evaluates user authorities and a "no break" option will be visible at the top of the list.
When selecting the script in Pane Designer, the following parameters can be defined:
Parameter | Description |
---|---|
@client_id |
nvarchar(50) The logged in client is automatically sent into the pane. |
@user_id |
nvarchar(255) The logged in user is automatically sent into the pane. |
@object_filter |
nvarchar(max) Filter as SQL smart syntax, example: DEPARTMENT#DIVISION#REGION |
@nobreak_text |
nvarchar(255) if variable set from pane: this will be presented as the first option in the pane list. Example 'No break' |
@order_by_descr |
int null = order by obj_id, 1= order by description |