Filtering of Table

Elsevər Musalı 0
Viewed 32

I have a requestParameter like this for filtering on a table, the all filtering process is behind, server-side, can you advise me how to filter on multiple fields and have multi-select parameter, thanks in advance

{
  "pageNumber": 1,
  "pageSize": 10,
  "invoiceNumber": [
    "test1",
    "test2"
  ],
  "date": [
    "date1",
    "date2"
  ],
  "beginDate": [
    "string"
  ],
  "endDate": [
    "string"
  ],
  "sh": [
    0
  ],
  "signatureStatus": [
    0
  ],
  "paymentType": [
    0
  ]
}
multivalue multi-select filtering c#
1 Answers

I think you can use WhereIf() function to filter this request.

query.WhereIf(input.signatureStatus != 0,a=>a.signatureStatus == 
input.signatureStatus)
.WhereIf(input.paymentType != 0,a=>a.paymentType == input.paymentType)

and finally use skip and take to return the data you want depend on page size

userfh2i10
Related