Skip to main content
Known Participant
Apr 6, 2022 6:07 AM UTC
Question

Report

Hii all

How to create a report using query entity not using report type ?Can anybody help me .

    11 replies

    gopalk2865
    Participating Frequently
    Apr 6, 2022 6:10 AM UTC

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

    Known Participant
    Apr 6, 2022 6:17 AM UTC

    I have a candidate information table in database  and I want to create a report using this table and also want to show all status (like form submit, Hr accepted)in the report. 

    How to create report using this table?

    stefanhelzle0001
    Brainy
    Apr 6, 2022 6:19 AM UTC

    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

    dastagirid0004
    Participating Frequently
    Apr 6, 2022 7:44 AM UTC

    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: {}
                )

    New Participant
    Apr 27, 2023 8:53 AM UTC

    "

    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

    sanchitg0002
    Inspiring
    Apr 27, 2023 9:14 AM UTC

    Report as abusive