Skip to main content

%DeepSee.Model.listing

Class %DeepSee.Model.listing Extends %DeepSee.Model.node [ System = 3 ]

Meta-data object that represents a listing for a DeepSee cube. This specifies what is used as the default RETURN clause for DRILLTHROUGH queries against this cube.
If no listings are defined for a cube, then no listing option is provided.

Properties​

cube​

Relationship cube As %DeepSee.Model.cube(XMLPROJECTION = "none") [ Cardinality = one, Inverse = listings ];

Cube that this listing belongs to.

listingType​

Property listingType As %String(MAXLEN = 50, VALUELIST = ",table,map", XMLPROJECTION = "attribute") [ InitialExpression = "table" ];

Indicates how to display this listing.
"table" (the default) shows the listing as a table.
"map" shows the listing within a map view. For this case, your listing must contain a columns called "Latitude" and "Longitude".

fieldList​

Property fieldList As %String(MAXLEN = "", XMLPROJECTION = "attribute");

Optional. If specified, this is used as the RETURN clause for the DRILLTHROUGH query used for this listing.
For listings based on a Data Connector, this attribute must be supplied.

formatList​

Property formatList As %String(MAXLEN = 5000, XMLPROJECTION = "attribute");

Optional. This is a "^" delimited list of css formatting instructions for the listing. Each piece of the list is applied to its corresponding column in the listing.

orderBy​

Property orderBy As %String(MAXLEN = 1000, XMLPROJECTION = "attribute");

Optional. If specified, this is used as the %ORDER BY clause for the DRILLTHROUGH query used for this listing.
This is only used if the cube's sourceClass is a persistent class.

sql​

Property sql As %String(MAXLEN = "", XMLPROJECTION = "attribute");

Optional. If specified, this is the sql statement used for this listing.
This is only used if the cube's sourceClass is a persistent class.

sourceClass​

Property sourceClass As %DeepSee.Datatype.className(XMLPROJECTION = "attribute");

Name of the %DeepSee.DataConnector class that provides the listing data.
If the cube uses a data connector as its sourceClass, then you must specify this value if you wish to show listings for the cube. If not specified, then the primary data connector for cube will be used for listings.

resource​

Property resource As %String(MAXLEN = 255, XMLPROJECTION = "attribute");

Optional. The resource needed to view this listing:
If defined and the current user holds the USE privilege on this resource, then the user may view this listing.

selectMode​

Property selectMode As %String(DISPLAYLIST = ",Logical,ODBC,Display", VALUELIST = ",0,1,2", XMLPROJECTION = "attribute") [ InitialExpression = 2 ];

SQL selectMode which this SQL listing will use to execute.
Possible values are:

  • 0 for LOGICAL mode.
  • 1 for ODBC mode.
  • 2 for DISPLAY mode.

Methods​

%Validate​

Method %Validate() As %Status

Test if this listing's definition is valid.

%AtScaleExport​

Method %AtScaleExport(pStatus As %Status = {$$$OK}, ByRef pAuxiliaryIndex As %DynamicAbstractObject = {$$$NULLOREF}) As %DynamicAbstractObject

Produce the structures needed to emit the appropriate JSON and export this item to AtScale