[FINERACT-1916] Data Table query - Advanced result set

• Type: New Feature
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Component/s: Data Tables
• Labels: BeanSalad
• Assignee: Unassigned
• Reporter: Peter Santa
• Created: 05/Apr/23 09:13
• Updated: 06/Sep/23 13:19

Description

Background

Data Table related querying has been enhanced with FINERACT-1747 and FINERACT-1910, FINERACT-1915.

The result set currently does not say anything about the data type.

Goal

If the caller requests that way (advancedResultSet=true), let the result set of

• data table query
• parts of Transaction query that includes data from data table (FINERACT-1915)

include data type related information, and have a response that is similar to the response of a table Report.

Example response

As a report response look like for this request, utilising a built-in report:

url/runreports/Client%20Listing?R_officeId=1

 

Let the caller customise in the request whether the currently existing simple, or the advanced result set format is required.

Solution Concept

Have a flag in the request: advancedResultSet=true to let the caller configure, that advanced (reporting-like) result set is requested.

<Solution Concept to be extended by developers>

Acceptance Criteria

• The result set of a data table query looks like the response of a report, including types of values in columns.

Issue Links

• is a child of: FINERACT-1917 Major improvement to Savings Account
• relates to: FINERACT-1910 Data Table query - Advanced
• relates to: FINERACT-1915 Transaction query - considering assigned data table