Create dynamic columns for the gridField based on the data.

Hello Prasanta Paul 

Thanks for the reply.

I have already fetched the data into the local variable like this:

How can I use this data in a grid directly with foreach?

a!gridField(
      label: "",
      labelPosition: "ABOVE",
      data: local!name,
      columns: {
        a!gridColumn(
          label: "First Name",
          sortField: local!name['recordType!GT CustomerDetails.fields.firstName'],
          value: fv!row['recordType!GT CustomerDetails.fields.firstName']
        ),
        a!gridColumn(
          label: "Last Name",
          sortField: local!name['recordType!GT CustomerDetails.fields.lastName'],
          value: fv!row['recordType!GT CustomerDetails.fields.lastName']
        )
      },
      pageSize: 16
    )
  }
)

a!localVariables(
  local!items:rule!GT_firstName(),
  a!gridLayout(
    label: "Customer",
    headerCells: {
      a!gridLayoutHeaderCell(label: "First Name"),
      a!gridLayoutHeaderCell(label: "Gender"),
    },
    rows: a!forEach(
      items: local!items,
      expression: {
        a!gridRowLayout(
          contents: {
            a!textField(
              value: fv!item['recordType!GT CustomerDetails.fields.firstName'],
            ),
            a!textField(
              value: fv!item['recordType!GT CustomerDetails.fields.gender'],
            )
          }
        )
      },
    )
  )
)

a!localVariables(
  local!items:rule!GT_firstName(),
  a!gridLayout(
    label: "Customer",
    headerCells: {
      a!gridLayoutHeaderCell(label: "First Name"),
      a!gridLayoutHeaderCell(label: "Gender"),
    },
    rows: a!forEach(
      items: local!items,
      expression: {
        a!gridRowLayout(
          contents: {
            a!textField(
              value: fv!item['recordType!GT CustomerDetails.fields.firstName'],
            ),
            a!textField(
              value: fv!item['recordType!GT CustomerDetails.fields.gender'],
            )
          }
        )
      },
    )
  )
)