P_Pane_Break_Objects

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

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