a!queryColumn() Function

Function

a!queryColumn( field, alias, visible )

Creates a Column object for use inside a Selection object.

See also: Column, Selection, Query

Parameters

Returns

Column

Usage considerations

Using the fields parameter

• The field parameter is required.
• Fields that are children of a multiple cannot be selected.

Using the alias parameter

• If no alias is given, the alias for the column will be inferred as the field value.
• If the alias is not provided and the field name collides with another existing alias, the field name will be suffixed with an incremented digit appended to the end when returned in the result.

Examples

In this example, we create three Column object. The first retrieves the firstName field. The second retrieves the lastName field and makes it accessible with the alias familyName in query results. The third column for employeeId is hidden from end users, but it can still be used for sorting.

1
2
3
4
5
6
7
8
9
10
11
12
13
a!queryEntity(
  entity: cons!MY_DATA_STORE_ENTITY,
  query: a!query(
    selection: a!querySelection(
      columns: {
        a!queryColumn(field: "firstName"),
        a!queryColumn(field: "lastName", alias: "familyName"),
        a!queryColumn(field: "employeeId", visible: false)
      }
    ),
    pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 10)
  )
)

Feature compatibility

Feedback