Select query for excel


Hi all can someone write a select query for this filter condition!

Tia

Hi @sheetal_Bora

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

1 Like


Getting this error
@

@sheetal_Bora updated the query, please try now.

Thanks