Skip to main content

<listingField>

Defines an optional listing field with which end users can create custom listings in a Business Intelligence cube.

Details

Note:

The system supports another kind of custom listing — a listing that does not necessarily use the source table of the cube. See Defining a Custom Listing in Defining Listings.

The <listingField> element has the following contents:

Attribute Purpose
name, displayName, description, disabled See Common Attributes in a Cube .
fieldExpression SQL expression that refers to a field in the source table or (via arrow syntax, for example) to a field in a related table. If you specify displayName, do not specify an alias within the SQL expression. Conversely, if you specify an alias within the SQL expression, displayName is ignored and the field name cannot be localized. For details, see Creating a Listing Field.
resource (Optional) Name of the resource used to control access to this listing field. See Implementing InterSystems Business Intelligence.

Example

For example:

<listingField name="PatientID" displayName="PatientID" fieldExpression="PatientID" />
<listingField name="Age" displayName="Age" fieldExpression="Age" />
<listingField name="Gender" displayName="Gender" fieldExpression="Gender" />
<listingField name="Test Score" displayName="Test Score" fieldExpression="TestScore" />
<listingField name="City" displayName="City" fieldExpression="HomeCity->Name" />
<listingField name="Doctor" displayName="Doctor" fieldExpression="PrimaryCarePhysician->LastName" />

FeedbackOpens in a new tab