Skip to main content


deprecated class %iKnow.Model.listTable extends %iKnow.Model.list

Subclass of %iKnow.Model.list dedicated to represent lists for the SQL Lister, geared to one specific table/class. This class has its own set of properties mapping to the specific Lister paramaters of the SQL Lister and hence is more easy to use than the generic list class. Any <parameter> elements nested within this element will be overwritten with the values specified for the corresponding shorthand attributes.

See also %iKnow.Source.SQL.Lister for more details on these Lister Parameters.

Property Inventory


parameter XMLNAME = table;
Inherited description: This parameter provides the default XMLNAME for the class. If it is empty then the class name will be used to construct a default XML name. The default XMLNAME is used as the top level tag when exporting objects and the export context did not provide an XML container name.


property dataFields as %String (MAXLEN = 250, XMLPROJECTION = "attribute");
The columns in table tableName containing the actual data to be indexed.
Property methods: dataFieldsDisplayToLogical(), dataFieldsGet(), dataFieldsIsValid(), dataFieldsLogicalToDisplay(), dataFieldsLogicalToOdbc(), dataFieldsNormalize(), dataFieldsSet()
property groupField as %String (MAXLEN = 250, XMLPROJECTION = "attribute");
The column in table tableName containing the group name to use for constructing the external ID for a loaded source.
Property methods: groupFieldDisplayToLogical(), groupFieldGet(), groupFieldIsValid(), groupFieldLogicalToDisplay(), groupFieldLogicalToOdbc(), groupFieldNormalize(), groupFieldSet()
property idField as %String (MAXLEN = 250, XMLPROJECTION = "attribute");
The column in table tableName containing the local reference to use for constructing the external ID for a loaded source.
Property methods: idFieldDisplayToLogical(), idFieldGet(), idFieldIsValid(), idFieldLogicalToDisplay(), idFieldLogicalToOdbc(), idFieldNormalize(), idFieldSet()
property listerClass as %String (MAXLEN = 250, XMLPROJECTION = "attribute") [ InitialExpression = "%iKnow.Source.SQL.Lister" , ReadOnly ];
Inherited description: The Lister class to use for loading data defined in this list element. This class should extend %iKnow.Source.Lister. The Lister class defined here dictates the contents of the parameters property.
Property methods: listerClassDisplayToLogical(), listerClassGet(), listerClassIsValid(), listerClassLogicalToDisplay(), listerClassLogicalToOdbc(), listerClassNormalize(), listerClassSet()
property metadataColumns as %String (MAXLEN = 1000, XMLPROJECTION = "attribute");
The columns in table tableName containing any metadata values to be stored with loaded sources.
Property methods: metadataColumnsDisplayToLogical(), metadataColumnsGet(), metadataColumnsIsValid(), metadataColumnsLogicalToDisplay(), metadataColumnsLogicalToOdbc(), metadataColumnsNormalize(), metadataColumnsSet()
property metadataFields as %String (MAXLEN = 1000, XMLPROJECTION = "attribute");
The names of the metadata fields positionally corresponding to the columns identified in metadataColumns. If left empty, the column names in metadataColumns are expected to correspond to metadata field names themselves.
Property methods: metadataFieldsDisplayToLogical(), metadataFieldsGet(), metadataFieldsIsValid(), metadataFieldsLogicalToDisplay(), metadataFieldsLogicalToOdbc(), metadataFieldsNormalize(), metadataFieldsSet()
property tableName as %String (MAXLEN = 500, XMLPROJECTION = "ATTRIBUTE");
The table which contents should be indexed.
Property methods: tableNameDisplayToLogical(), tableNameGet(), tableNameIsValid(), tableNameLogicalToDisplay(), tableNameLogicalToOdbc(), tableNameNormalize(), tableNameSet()
property whereClause as %String (MAXLEN = 2000, XMLPROJECTION = "ATTRIBUTE");
An optional WHERE clause to filter the contents of table tableName
Property methods: whereClauseDisplayToLogical(), whereClauseGet(), whereClauseIsValid(), whereClauseLogicalToDisplay(), whereClauseLogicalToOdbc(), whereClauseNormalize(), whereClauseSet()

Inherited Members

Inherited Properties

Inherited Methods

FeedbackOpens in a new tab