Where match

[Anonymous]

Hi,

Can you use a WHERE MATCH statement in an expression?

I tried the following: WHERE MATCH ( {$<OrderType={15}>} SupplierName )

But it didn't work.

I wanted the table to show the supplierNAme for all orders with type 15. Is there any other way to make this selection in a table?

Thank you!

[arulsettu · Accepted solution]

try this

if(OrderType=15,SupplierName )

[Anonymous]

Thank you, it worked!