Skip to main content


abstract persistent class %DeepSee.ListingTable extends %Library.Persistent

SQL Table Name: %DeepSee.ListingTable

Base class for all DeepSee listing tables.
Listing tables are used to hold the set of fact IDs when drilling through a cube to generate a listing.

Property Inventory


parameter CUBENAME;
Name of the cube that created this listing table.
parameter MANAGEDEXTENT = 0;
Turn off extent management for listing tables.


property queryKey as %String (MAXLEN = 255) [ SqlFieldName = _DSqueryKey , Required ];
Key for the DRILLTHROUGH query that populated this record.
Property methods: queryKeyDisplayToLogical(), queryKeyGet(), queryKeyIsValid(), queryKeyLogicalToDisplay(), queryKeyLogicalToOdbc(), queryKeyNormalize(), queryKeySet()
property sourceId as %String (MAXLEN = 255) [ SqlFieldName = _DSsourceId , Required ];
Id in the source data table.
Property methods: sourceIdDisplayToLogical(), sourceIdGet(), sourceIdIsValid(), sourceIdLogicalToDisplay(), sourceIdLogicalToOdbc(), sourceIdNormalize(), sourceIdSet()


index (ID on queryKey,sourceId) [IdKey, Type = key];
Index methods: IDCheck(), IDDelete(), IDExists(), IDOpen(), IDSQLCheckUnique(), IDSQLExists(), IDSQLFindPKeyByConstraint(), IDSQLFindRowIDByConstraint()

Inherited Members

Inherited Methods

FeedbackOpens in a new tab