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:      

  • @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:

ParameterDescription
@client_idThe logged in client is automatically sent into the pane.
@user_idThe logged in user is automatically sent into the pane.
@object_filter
@nobreak_text
@order_by_descr

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:      

  • @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:

ParameterDescription
@client_idThe logged in client is automatically sent into the pane.
@user_idThe logged in user is automatically sent into the pane.
@object_filter
@nobreak_text
@order_by_descr

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