Support Multiple Per-Column Search - Advanced Search

[geekz-reno]

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,

[iammukeshm]

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?

[frankyjquintero]

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

[iammukeshm]

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

[geekz-reno]

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,

[iammukeshm]

Will keep this open till I add this feature.

[frankyjquintero]

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