[jira] [Updated] (FINERACT-1747) Have an API endpoint to query values from Data Table

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

     [ https://issues.apache.org/jira/browse/FINERACT-1747?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Peter Santa updated FINERACT-1747:
----------------------------------
    Affects Version/s: 1.9.0

> 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
>    Affects Versions: 1.9.0
>            Reporter: Peter Santa
>            Assignee: Zoltán Nébli
>            Priority: Major
>              Labels: BeanSalad
>             Fix For: 1.9.0
>
>
> 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)