[ 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)