Select query for excel

[sheetal_Bora]

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

Tia

[prasath_S]

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

[sheetal_Bora]

Getting this error
@

[prasath_S]

@sheetal_Bora updated the query, please try now.

Thanks