[jira] [Created] (FINERACT-1910) Have advanced features for data table querying

["Peter Santa (Jira)" <ji...@apache.org>]

Peter Santa created FINERACT-1910:
-------------------------------------

             Summary: Have advanced features for data table querying
                 Key: FINERACT-1910
                 URL: https://issues.apache.org/jira/browse/FINERACT-1910
             Project: Apache Fineract
          Issue Type: New Feature
          Components: Data Tables
            Reporter: Peter Santa


h1. Background

FINERACT-1747
h1. 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 interval (from, to) in case of the following typed fields
 ** date
 ** date and time
 ** number
 ** decimal

Query example:

{\{url}}/datatables/\{{dataTableId}}/query?columnFilter=iban,transaction_date,type&valueFilter=\{{accountIban}},from_20230201-to_20230228,deposit&resultColumns=column3,column6,column4&offset=0&limit=10&sortOrder=desc&orderBy=transaction_date

{\{url}}/datatables/\{{dataTableId}}/query?columnFilter=iban,transaction_date,type&valueFilter=\{{accountIban}},from_20230201,withdraw&resultColumns=column3,column6,column4&offset=0&limit=10&sortOrder=desc&orderBy=transaction_date



--
This message was sent by Atlassian Jira
(v8.20.10#820010)