Hello Team,
I followed the REST Hands-on Lab and was able to create REST APIs and create reports with forms on top of the APIs.
However, I'm not able to create REST Data Sources that works on a "Report with Form" page. Here is the issue -
TABLES USED and ENDPOINTS
EBA_PROJECTS
EBA_PROJECT_MILESTONES/:project_id
EBA_PROJECT_TASKS/:project_id/:milestone_id
(using parameters with same name as columns without having to add Parameters in REST APIs)
Create REST APIs for PROJECTS, MILESTONES and TASKS tables - these work and fetch data from their endpoints fine.
Create REST Data Source for PROJECTS - works fine to be used on both Interactive Report (list) with Form (detail).
Create REST Data Source for MILESTONES that has Project_ID parameter and should fetch multiple Milestone rows for each Project row.
Create REST Data Source for TASKS that has Project_ID/Milestone_ID parameters and should fetch multiple task rows for each project/milestone combo.
Use the REST Data Sources for MILESTONES and TASKS as Classic Reports on the Form dialog page in different subregions using Region Display Selector, specify Parameters - don't work.
I was able to specify Project_ID parameter but Milestone_ID parameter is not available on the form page.
Project - Details tab displays the Project form fine.
Milestone list in the Milestones tab displays the same Project details form - need to display a list of Milestones for the Project as Classic Report.
Task list in the Tasks tab displays the same Project details form - need to display a list of Tasks for the Project/Milestone as Classic Report.
How do I go about accomplishing the above? I'm stuck!
The Actions > Chart option is missing in the Interactive Report page when using REST Data Source (even though the Chart switch is ON in the Attributes) but the option is available if connecting directly to the tables without REST. Is this a known issue? How to get it to display the Chart option under Actions? This is crucial to users.
If I place a Project_ID number item and a button on the Milestones tab to fetch data manually for testing purpose, it is submitting the entire page including the first tab (Project form). How can I submit just the region/form on Milestones tab? I know from HTML forms that a button can submit the form in which it is placed.
Please help...
Thanks in advance!