Right.SP Details

Element Details: Right.SP

Available in: Logi Info

Source code name: Right.SP

Rights control what user roles are allowed to view a report or report element, or perform an action. You should have a Right element for each function that you want to securely control in the report application. Each Right is associated with one or more Roles, and any user that has any of the Right's Roles has access to reports and report elements that require that Right. Right.SP should return a list of Roles in the first column, or multiple Roles in a single record as a comma-delimited list.

ATTRIBUTES

Click attribute Name to drill down for more information.

Name

Possible Values

Description

Command

UserDefined

(Required) When this is an attribute of Procedure.SP, provide the name of a Stored Procedure that returns a single or no values. Use this element for procedures that execute UPDATEs, INSERTs, and other database actions. When this is an attribute of DataLayer.SP, provide the name of a Stored Procedure that returns a result set of some number of data rows. If working with Oracle Packages, provide the Package name, then a period, then the Procedure name. For example, "myPackage.myProcedure".

ConnectionID

UserDefined

Specifies a connection to a data source that is defined in the Settings. For elements connecting to relational databases, default is the first Connection element in _settings.lgx.

UserDefined

(Required) The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition.

PARENT ELEMENTS

Click element to drill down for more information.

CHILD ELEMENTS

Click element to drill down for more information.

Calculated Column
Condition Filter

SP Auto Parameters
SP Input Parameters

SP Parameters