[
https://issues.apache.org/jira/browse/FINERACT-1747?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Peter Santa updated FINERACT-1747:
----------------------------------
Description:
h1. Background
It is needed to be able to find rows in a Data Table, based on a value in a
specified column, and get the whole row based on the given value.
h1. Goal
Have an API endpoint provided by Fineract, that allows filtering rows from Data
Tables based on a value.
h1. Solution Concept
Implement an API endpoint in Fineract with {{GET}} method, that executes a
query on a specified Data Table.
E.g.:
Data Table:
{code:java}
my_great_data_table{code}
||client_id||special_value_1||special_value_2||special_value_3||created_at||updated_at||
|1|ABC1|DEF|GHI|...|...|
|2|ABC2|FED|IHG|...|...|
h3. Request
* data table ID - {{datatable}}
* data table filter column name - {{columnFilter}}
* requested filter value in the column - {{valueFilter}}
* columns, from which the value should be included in the response -
{{resultColumns}} (comma separated column names)
{code:java}
...my_great_data_table/query?columnFilter=special_value_1&valueFilter=ABC2&resultColumns=special_value_2,special_value_3{code}
h3. Response
{code:java}
[
{
"special_value_2": "FED",
"special_value_3": "IHG"
}
] {code}
h1. Acceptance Criteria
* The new API endpoint accepts as input
** data table ID - {{datatable}}
** data table filter column name - {{columnFilter}}
** requested filter value in the column - {{valueFilter}}
** columns, from which the value should be included in the response -
{{resultColumns}} (comma separated column names)
* The response contains the list of records, that satisfy the conditions in
the input.
was:
h1. Background
It is needed to be able to find rows in a Data Table, based on a value in a
specified column, and get the whole row based on the given value.
h1. Goal
Have an API endpoint provided by Fineract, that allows filtering rows from Data
Tables based on a value.
h1. Solution Concept
Implement an API endpoint in Fineract with {{GET}} method, that executes a
query on a specified Data Table.
E.g.:
Data Table:
{code:java}
my_great_data_table{code}
||client_id||special_value_1||special_value_2||special_value_3||created_at||updated_at||
|1|ABC1|DEF|GHI|...|...|
|2|ABC2|FED|IHG|...|...|
h3. Request
* data table ID - {{datatable}}
* data table filter column name - {{columnFilter}}
* requested filter value in the column - {{valueFilter}}
* columns, from which the value should be included in the response -
{{resultColumns}} (comma separated column names)
{code:java}
...?datatable=my_great_data_table&columnFilter=special_value_1&valueFilter=ABC2&resultColumns=special_value_2,special_value_3{code}
h3. Response
{code:java}
[
{
"special_value_2": "FED",
"special_value_3": "IHG"
}
] {code}
h1. Acceptance Criteria
* The new API endpoint accepts as input
** data table ID - {{datatable}}
** data table filter column name - {{columnFilter}}
** requested filter value in the column - {{valueFilter}}
** columns, from which the value should be included in the response -
{{resultColumns}} (comma separated column names)
* The response contains the list of records, that satisfy the conditions in
the input.
> Have an API endpoint to query values from Data Table
> ----------------------------------------------------
>
> Key: FINERACT-1747
> URL: https://issues.apache.org/jira/browse/FINERACT-1747
> Project: Apache Fineract
> Issue Type: New Feature
> Components: Data Tables
> Reporter: Peter Santa
> Assignee: Zoltán Nébli
> Priority: Major
>
> h1. Background
> It is needed to be able to find rows in a Data Table, based on a value in a
> specified column, and get the whole row based on the given value.
> h1. Goal
> Have an API endpoint provided by Fineract, that allows filtering rows from
> Data Tables based on a value.
> h1. Solution Concept
> Implement an API endpoint in Fineract with {{GET}} method, that executes a
> query on a specified Data Table.
> E.g.:
> Data Table:
> {code:java}
> my_great_data_table{code}
> ||client_id||special_value_1||special_value_2||special_value_3||created_at||updated_at||
> |1|ABC1|DEF|GHI|...|...|
> |2|ABC2|FED|IHG|...|...|
> h3. Request
> * data table ID - {{datatable}}
> * data table filter column name - {{columnFilter}}
> * requested filter value in the column - {{valueFilter}}
> * columns, from which the value should be included in the response -
> {{resultColumns}} (comma separated column names)
> {code:java}
> ...my_great_data_table/query?columnFilter=special_value_1&valueFilter=ABC2&resultColumns=special_value_2,special_value_3{code}
> h3. Response
> {code:java}
> [
> {
> "special_value_2": "FED",
> "special_value_3": "IHG"
> }
> ] {code}
> h1. Acceptance Criteria
> * The new API endpoint accepts as input
> ** data table ID - {{datatable}}
> ** data table filter column name - {{columnFilter}}
> ** requested filter value in the column - {{valueFilter}}
> ** columns, from which the value should be included in the response -
> {{resultColumns}} (comma separated column names)
> * The response contains the list of records, that satisfy the conditions in
> the input.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
