hasura where params - create complex where structures easily
const totalGross = 2000;
const input = whereArgs(
whereFilter('fiscalNumber._eq', 'order'),
whereFilter('_or.dailyReportNumber._in', ['user1', 'user2', 'user3']),
whereFilter('_or.printoutNumber._ilike', 'query'),
whereFilter('_or._and.systemNumber._ilike', 'query'),
whereFilter('totalGross._gte', totalGross, totalGross > 3000)
);
const output = {
fiscalNumber: { _eq: 'order' },
_or: [
{ dailyReportNumber: { _in: ['user1', 'user2', 'user3'] } },
{ printoutNumber: { _ilike: 'query' } },
{
_and: [
{
systemNumber: { _ilike: 'query' },
},
],
},
],
};
Available filter fields:
_and, _or, _neq,_and[], _or[], _and{}, _or{}
- If you use_and
or_or
it has the same behaviour as_and[]
and_or[]
, it is just a shortcut.