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:
@client_id nvarchar(50)
@user_id nvarchar(255)
@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
The 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 | The logged in client is automatically sent into the pane. |
@user_id | The logged in user is automatically sent into the pane. |
@object_filter | |
@nobreak_text | |
@order_by_descr |