To filter the data from API, it's possible to make request with two comparison methods:
- Constant
- Input : value of an input in the form.
For each comparison method we have two parameters :
- Firstly a comparator (==, <=, <, >=, >, between)
- Secondly a constant or an input (input name)
- constant : it must have the same type (number, date, etc.) as the data id.
- input : nested query with the selected input value on the braincube mb.
If the selected comparator is between, we have two inputs for the comparison.
Click on the add button to add a comparator and value in the filters list.
You can also delete an existing filter with the delete button (select a filter in the list before).
You can filter data with multiple filters.
Particular cases : Table and TextArea inputs
In the case of Table and TextArea inputs, we can request multiple API variables.
- The name of the braincube is filled by default.
- Data id, with the prefix d, you want to add to the component. For example if the Id of the data is 2000020, so Data source will be “d2000020”.
- Button to add a variable in the component
- Button to delete the selected variable in the list of variables
- List of variables in the component
- Different fields to query and filter the list of variables (see above)
Note1 : The table will be composed of one variable per column.
Note2 : The TextArea will be composed of the last value of each variable per line.