Hii all
How to create a report using query entity not using report type ?Can anybody help me .
Discussion posts and replies are publicly visible
HI jyotig0003, What kind of report you want to create? please let us know about your requirement.
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?
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
yes i am talking about a grid
HI jyoti, If its a grid then please go through the link which Stefan has provided, you will get an idea about implementation.
Hii gopal ,
the link that is provided by stefan is using record type to fetch data in grid but I don't want using record type .I want to fetch data using query entity from database
You can replace the query record type data with query entity data right.
Hi jojog0003
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: {} )
"
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