How do I give the field of a!querycolumn() when querying from datastore

Question

I'm querying from a datastore, I only need one column, how do I give the column name in field

bhargavip7872 · Accepted Answer

Hi [mention:2aea1bf0b6954f94815518e79da990c7:e9ed411860ed4f2ba0265705b8793d05] please use below code

a!queryEntity(
entity: cons!test,
query: a!query(
selection: a!querySelection(
columns: a!queryColumn(
field: "columnsNameAsInCDT"
)
),
pagingInfo: a!pagingInfo(1,10)
)
).data

you can change paging as your requirement

yogip3177 · Answer

You have to give the CDT's field name in a!queryColumn. See the sample code for reference:

a!queryEntity(
  entity: cons!DU_DOC_TYPE_DSE,
  query: a!query(
    selection: a!querySelection(
      columns: {
        a!queryColumn(
          field: "docTypeName"
        )
      }
    ),
    pagingInfo: a!pagingInfo(
      startIndex: 1,
      batchSize: 50
    )
  ),
  fetchTotalCount: false
)

Sign up

Login with SSO

Login to the community

Login with SSO