[
https://issues.apache.org/jira/browse/FINERACT-1910?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Peter Santa updated FINERACT-1910:
----------------------------------
Description:
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
* "LIKE" search in string and text fields - use wildcard
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
{{{}url{}}}/datatables/{{{}dataTableId{}}}/query?columnFilter=iban,transaction_date,type,note&valueFilter={{{}accountIban{}}},from_20230201-to_20230228,deposit,%Ltd.%&resultColumns=column3,column6,column4&offset=0&limit=10&sortOrder=desc&orderBy=transaction_date
was:
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
> 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
> Priority: Critical
>
> 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
> * "LIKE" search in string and text fields - use wildcard
> 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
> {{{}url{}}}/datatables/{{{}dataTableId{}}}/query?columnFilter=iban,transaction_date,type,note&valueFilter={{{}accountIban{}}},from_20230201-to_20230228,deposit,%Ltd.%&resultColumns=column3,column6,column4&offset=0&limit=10&sortOrder=desc&orderBy=transaction_date
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
