Use OQL query Data Set in a web page

0
I've created a data source that uses OQL to summarize data based on two fields from an entity.  I want to show the total number of 'Open_Reqs' by each 'TA.Manager'. OQL code is:   SELECT     P.id TotalReqsByTAM_Open_Reqs,     P.TA_Manager TA_Manager,     sum(P.Qty) QtyFROM    WeeklyReqReport.Open_Reqs P     group by P.id, P.TA_Manager   The OQL module documentation tells you how to build queries but isn't very clear on how to actually use the query results.   Note: my company limits us to Mendix version 10.18, so I can't use the View Entity available in 10.19   I'm open to suggestions if someone thinks there's an easier way to do this.
asked
1 answers
1

If you are sure the OQL query is correct, please do the following;

1. Create a page tat contains a data grid or list view according to your needs, with data source as microflow: DS_OpenReqs.

2. In DS_OpenReqs, place the execute OQL and this microflow should return the list of WeeklyReqReport.Open_Reqs.

 

This way you can display the output of OQL in a page.

answered