dotnet-starter-kit icon indicating copy to clipboard operation
dotnet-starter-kit copied to clipboard

Support Multiple Per-Column Search - Advanced Search

Open geekz-reno opened this issue 3 years ago • 6 comments

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,

geekz-reno avatar Dec 10 '21 09:12 geekz-reno

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?

iammukeshm avatar Dec 11 '21 01:12 iammukeshm

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

frankyjquintero avatar Dec 11 '21 14:12 frankyjquintero

Should be possible to add this feature. Will raise this as an issue to the Backlog.

iammukeshm avatar Dec 11 '21 17:12 iammukeshm

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,

geekz-reno avatar Dec 12 '21 04:12 geekz-reno

Will keep this open till I add this feature.

iammukeshm avatar Dec 12 '21 04:12 iammukeshm

https://github.com/fullstackhero/dotnet-webapi-boilerplate/pull/570

frankyjquintero avatar Mar 13 '22 19:03 frankyjquintero