platform icon indicating copy to clipboard operation
platform copied to clipboard

Possibility to use comparators in Action Table

Open pgrill79 opened this issue 1 year ago • 2 comments

It would be great if you can use different operators for filtering in the action table. E.g. if there is a number or a date column, to give the possiblity to filter every thing > or < than the number or date.

pgrill79 avatar Jun 16 '24 09:06 pgrill79

This fits into a larger complex of "Business Intelligence" like functions. At the moment, we only support equality in the underlying all(db, table, filters) call where filter is a map of field=value.

see https://marmelab.com/react-admin/FilterList.html

aeberhart avatar Jun 17 '24 08:06 aeberhart

we can maybe re-use the query editor logic

aeberhart avatar Jun 19 '24 07:06 aeberhart

in table and actionTable widgets, you can prefix the filter with one of the following operators followed by a space:

  • <
  • <=
  • >
  • >=
  • != or <>
image

This does not work on the table pages, where filters are pushed down to the database. The filters are applied on the UI only

aeberhart avatar Oct 07 '24 18:10 aeberhart