[FINERACT-1910] Data Table query - Advanced

• Type: New Feature
• Status: Resolved
• Priority: Critical
• Resolution: Done
• Fix Version/s: 1.9.0
• Component/s: Data Tables
• Labels: BeanSalad
• Assignee: Unassigned
• Reporter: Peter Santa
• Created: 24/Mar/23 16:25
• Updated: 07/Jan/24 10:53
• Resolved: 18/Oct/23 13:50

Description

Background

FINERACT-1747

Goal

Have the querying possibilities - that have been developed with FINERACT-1747 - extended with the following features:

• pagination - similarly to several Fineract API endpoints
• sorting based on given attribute
• filter for closed (greather-than-or-equal, less-than-or-equal) interval in case of the following typed fields:
  • date
  • date and time
  • number
  • decimal
  • string/text that can be parsed to numeric
• contains search in string and text fields
• exact match for string and text fields

The filtering parameters should be applied with "AND" relation.

Solution Concept

Have the solution concept aligned between

• FINERACT-1910
• FINERACT-1912
• FINERACT-1915

If multiple columns would be used as column filter, it is advisable not to put this number of query parameters in the url, but in the body, like graphql. With this, a request would look like:

URL

GET url/datatables/dataTableId/query?resultColumns=column3,column6,column4&offset=0&limit=10&sortOrder=desc&orderBy=transaction_date

Body

See the attached dataTableAdvancedFilteringExample.txt.

The filtering parameters should be applied with "AND" relation.

 

<Solution Concept to be extended by developers>

Issue Links

• blocks: FINERACT-1915 Transaction query - considering assigned data table
• is a child of: FINERACT-1917 Major improvement to Savings Account
• is a child of: FINERACT-1874 Release Apache Fineract 1.9.0
• is related to: FINERACT-1916 Data Table query - Advanced result set
• is related to: FINERACT-1970 Assign Data Table to Transaction (General)
• is related to: FINERACT-1912 Transaction query - Advanced
• is related to: FINERACT-1911 Assign Data Table to Transaction (Savings)
• relates to: FINERACT-1747 Have an API endpoint to query values from Data Table
• links to: GitHub Pull Request #3076
• links to: GitHub Pull Request #3226