Grid related

In the given exercise https://docs.appian.com/suite/help/22.1/Grid_Tutorial.html

When below expression is used 

Results in 

When I tried the same no data is fetched 

  Discussion posts and replies are publicly visible

Parents Reply Children
  • I have already added selectionValue and selectionSaveInto in the gridfield. But how to store these "selected" vales in the "selectedEmployees" varible inorder to display under Selection Employees

    Below is the code

    a!localVariables(
    local!selection,
    local!selectedEmployees,
    {
    a!columnsLayout(
    columns: {
    a!columnLayout(
    contents: {
    a!gridField(
    label: "Read-only Grid",
    labelPosition: "ABOVE",
    data: a!queryEntity(
    entity: cons!AT_EMPLOYEE_ENTITY1,
    query: a!query(
    selection: a!querySelection(
    columns: {
    a!queryColumn(
    field: "id"
    ),
    a!queryColumn(
    field: "firstName"
    ),
    a!queryColumn(
    field: "lastName"
    ),
    a!queryColumn(
    field: "department"
    ),
    a!queryColumn(
    field: "startDate"
    )
    }
    ),
    pagingInfo: fv!pagingInfo
    ),
    fetchTotalCount: true
    ),
    columns: {
    a!gridColumn(
    label: "First Name",
    sortField: "firstName",
    value: fv!row.firstName
    ),
    a!gridColumn(
    label: "Last Name",
    sortField: "lastName",
    value: fv!row.lastName
    ),
    a!gridColumn(
    label: "Department",
    sortField: "department",
    value: a!richTextDisplayField(
    value: {
    a!richTextItem(
    text: {fv!row.department},
    color: if(fv!row.department="Sales","SECONDARY", null),
    style: {
    "EMPHASIS"
    }
    )
    }
    )
    ),
    a!gridColumn(
    label: "Start Date",
    sortField: "startDate",
    value: fv!row.startDate,
    align: "END"
    )
    },
    pageSize: 5,
    initialSorts: {
    a!sortInfo(
    field: "lastName",
    ascending: true
    )
    },
    selectable: true,
    selectionValue: local!selection,
    selectionSaveInto: local!selection,
    validations: {}
    )
    },
    width: "WIDE"
    ),
    a!columnLayout(
    contents: {
    a!richTextDisplayField(
    label: "Selected Employees",
    labelPosition: "ABOVE",
    value: a!forEach(
    items: local!selectedEmployees,
    expression: {a!richTextIcon(icon:"user-centric"),
    " "&fv!item.firstName&" "&fv!item.lastName&char(10)}
    )
    )
    }
    )
    }
    )
    })

  • The other posters are correct - in particular you are missing this additional logic in your selectionSaveInto:

    selectionSaveInto: {
      local!selection,
      a!save(local!selectedEmployees, append(local!selectedEmployees, fv!selectedRows)),
      a!save(local!selectedEmployees, difference(local!selectedEmployees, fv!deselectedRows))
    }