Hi all can someone write a select query for this filter condition!
Tia
Please try this,
dtOutput = dtClaimhistory.select("(Status = 'Open' or Status = 'Pending') and [Benefit Type] = '" + Benefittype + "' and [Insured] = '" + row("insured").tostring + "' and [Denial Reason] = 'Eligible for pauments' or [ispaymentrecieved] = 'True'").copytodatatable
Thanks
@sheetal_Bora updated the query, please try now.
Thanks