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.

Goal

Have an API endpoint provided by Fineract, that allows filtering rows from Data Tables based on a value.

Implement an API endpoint in Fineract with GET method, that executes a query on a specified Data Table.

E.g.:

Data Table:

my_great_data_table

client_id	special_value_1	special_value_2	special_value_3	created_at	updated_at
1	ABC1	DEF	GHI	...	...
2	ABC2	FED	IHG	...	...

columns, from which the value should be included in the response - resultColumns (comma separated column names)

...my_great_data_table/query?columnFilter=special_value_1&valueFilter=ABC2&resultColumns=special_value_2,special_value_3

[
  {
    "special_value_2": "FED",
    "special_value_3": "IHG"
  }
]

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.

is a child of

FINERACT-1874 Release Apache Fineract 1.9.0

is related to

FINERACT-1970 Assign Data Table to Transaction (General)

FINERACT-1910 Data Table query - Advanced

FINERACT-1911 Assign Data Table to Transaction (Savings)

links to

GitHub Pull Request #2624

(1 links to)