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

P_Pane_Default_TimeValue

The procedure p_pane_default_timevalue should be used to easily return a default timevalue in a pane control:

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.

@timeunit

nvarchar(50)

Mandatory input parameter. Select which timeunit the list should show.

Example: ISOMONTH, ISOWEEK, ISOYEAR                

@timeadd

int

seqno relative to @base_timeval, eg. -1 is previous timeval  

@base_timeval

nvarchar(8)

base timevalue, if not specified then base timevalue will be current date converted to @timeunit. Example: @base_timevalue = null, @timeunit                                                                                         ISOMONTH, today is 2016-06-01, then base timevalue will be 201606.  

             if @timeadd = -1 the returned value will be 201605                              

 

Published:

P_Pane_Default_TimeValue

The procedure p_pane_default_timevalue should be used to easily return a default timevalue in a pane control:

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.

@timeunit

nvarchar(50)

Mandatory input parameter. Select which timeunit the list should show.

Example: ISOMONTH, ISOWEEK, ISOYEAR                

@timeadd

int

seqno relative to @base_timeval, eg. -1 is previous timeval  

@base_timeval

nvarchar(8)

base timevalue, if not specified then base timevalue will be current date converted to @timeunit. Example: @base_timevalue = null, @timeunit                                                                                         ISOMONTH, today is 2016-06-01, then base timevalue will be 201606.  

             if @timeadd = -1 the returned value will be 201605                              

 

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