dotnet-starter-kit
dotnet-starter-kit copied to clipboard
Support Multiple Per-Column Search - Advanced Search
Its possible to search multiple field using AdvanceSearch? it works when search only one value eg,
{
"advancedSearch": {
"fields": [ "startDate" ],
"keyword": "2022-12-10"
},
"keyword": "",
"pageNumber": 0,
"pageSize": 10,
"orderBy": []
}
Thank you,
you can use something like
{
"advancedSearch": {
"fields": [
"name",
"id"
],
"keyword": "623"
},
"keyword": "",
"pageNumber": 0,
"pageSize": 10,
"orderBy": [
"id"
]
}
to search against multiple columns for a value. Is this your question? Or do you want to search separate columns with different values?
The scenario where advanced search is supported by each field with different data types would be a great advantage, scenarios such as kendo ui tables and entity core framework
Should be possible to add this feature. Will raise this as an issue to the Backlog.
hi @iammukeshm really sorry for late replay, yes, i mean to search multiple field with multiple colom with different value, like i want to search where startDate = '2021-12-12' AND/OR paymentType = 'Credit'
thank you,
Will keep this open till I add this feature.
https://github.com/fullstackhero/dotnet-webapi-boilerplate/pull/570