Element Details: DataLayer.SP
 Back


Available in: Logi Info Source code name: DataLayer.SP

Allows specification of a Stored Procedure that returns a rowset and populates a DataTable or other data element. There will be one row for each row returned by the SQL statement. Inside the data element, you reference each field with the @Data token, such as "@Data.fieldname~". Supply parameters to the Stored Procedure with an SPInputParams element.

Element Group:Relational Database DataLayers



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
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.
ID
UserDefined
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.
MaxRows
UserDefined
The maximum number of rows to retrieve from the data source.



PARENT ELEMENTS

Click element to drill down for more information.

Analysis Chart
Analysis Grid
Animated Chart.Pie
Animated Chart.Scatter
Animated Chart.XY
Animated Extra Scatter Layer
Animated Gauge.Bar
Animated Gauge.Needle
Animated Gauge.Pyramid
Animated Map
Authentication
Auto Complete
Bulk Email Data Layer
Chart Canvas
Chart Grid
Chart.Gantt
Chart.Heatmap
Chart.Pie
Chart.Polar
Chart.Scatter
Chart.XY
Crosstab Table
Data Calendar
Data List
Data Menu
Data Multi-Column List
Data Table
Data Tree
DataLayer.Cached
Default Values
Email List
External Definitions
Extra Gantt Column
Extra Grid Layer
Extra Polar Layer
Extra Scatter Layer
Extract
Gauge.Angular
Gauge.Arc
Gauge.Balloon Bar
Gauge.Bar
Gauge.Bullet Bar
Gauge.Indicator
Gauge.Needle
Gauge.Number
If Data Error
Input Checkbox List
Input Combo List
Input Radio Buttons
Input Select List
Interactive Data View Applet
Join
Json Data
Local Data
Lookup
Map Markers
Map Polygons
Map Polylines
Marker Band
Marker Line
Marks
Milestone Column
Pattern Block
PDF Form
Procedure.Data
Procedure.Run Datalayer Rows
Right
Right From Role
Rights From DataLayer
Series.Area
Series.Area Range
Series.Area Spline
Series.Area Spline Range
Series.Bar
Series.Bar Range
Series.Box Plot
Series.Bubble
Series.Funnel
Series.Heatmap
Series.Line
Series.Pie
Series.Pyramid
Series.Scatter
Series.Spline
Series.Waterfall
Series.Whiskers
Sharing List
Sparkline.Area
Sparkline.Bar
Sparkline.Line
Sparkline.WinLoss
Subdata Layer
Table
Text Cloud
User Roles
Word Form
Xml Data
XOLAP Cube
XslFo Data


CHILD ELEMENTS

Click element to drill down for more information.

Aggregate Column
Analysis Filter Insert
Calculated Column
Change Case
Color Range Column
Color Spectrum Column
Compare Columns
Compare Filter
Comparison Filter
Condition Filter
Contain Filter
Contains Filter
Convert Units
Crosstab Filter
Data Layer Link
Data Layer Plugin Call
DeDuplicate Filter
DeDuplication Filter
Difference Column
Ends With Filter
File Column
Forecast.Current Time Period
Forecast.Regression
Forecast.Time Series Decomp
Formatted Column
Geocode Columns
Group Filter
HierarchicalLookup.SP
HierarchicalLookup.SQL
HierarchicalLookup.WebService
If Data Error
Incremental Append
Insert String
Join
Lookup
Lookup.SP
Lookup.SQL
Lookup.WebService
Moving Average Column
Pad String
Percent of Total Column
Predicted Column
Range Filter
Rank Column
RegEx Filter
Relevance Filter
Remove Columns
RenameColumns
Replace String
Replace Value
Reverse Geocode Columns
Running Total Column
Security Filter
Sequence Column
Sort Filter
SP Parameters
Starts With Filter
Substring
Switch Column
Time Period Column
Trim String
UnCrosstab Filter
Unit Conversion Column
Unpivot
Validate Date
Validate Number
Validate RegEx
Validate String


 Back to top


 Chart Debug