Report

HI jyotig0003, What kind of report you want to create? please let us know about your requirement.

Hi [mention:b04813dcb78a48ff889e6fbdf057c6bc:e9ed411860ed4f2ba0265705b8793d05] 

Please find the below code for readonly grid with query entity rule.

Below example has a table with first name, last name, department and status.

I hope this code will help to correlate with your requirement.

a!gridField(
              label: "Read-only Grid",
              labelPosition: "ABOVE",
              data: a!queryEntity(
                entity: cons!EMPLOYEE_ENTITY,
                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: "status"
                      )
                    }
                  ),
                  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: fv!row.department
                ),
                a!gridColumn(
                  label: "Status",
                  sortField: "status",
                  value: fv!row.status,
                  align: "END"
                )
              },
              pageSize: 5,
              initialSorts: {
                a!sortInfo(
                  field: "lastName",
                  ascending: true
                )
              },
              validations: {}
            )

"

Are you talking about a grid? Did you try to just add a grid to an interface and use a query to fetch the data?

Something like this: docs.appian.com/.../recipe-filter-the-data-in-a-grid.html avatar game"

This is what I am finding, thanks a lot