Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

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:      

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

Published:

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:      

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

For an optimal Community experience, Please view on Desktop
Powered by Zendesk