DynamicQueryDto
tableNamestringrequired
columnsstring[]required
filters object[]
Array [
columnstringrequired
operatorstringrequired
Possible values: [equals, contains, gte, lte, isNull, isNotNull]
valuestring
]
sortBystring
sortOrderstring
Possible values: [ASC, DESC]
offsetnumber
Default value:
0limitnumber
Default value:
50DynamicQueryDto
{
"tableName": "string",
"columns": [
"string"
],
"filters": [
{
"column": "string",
"operator": "equals",
"value": "string"
}
],
"sortBy": "string",
"sortOrder": "ASC",
"offset": 0,
"limit": 50
}