BAQ how to set to filter only integer is shown from specific field

andrew.phiss · January 5, 2020, 4:48am

hi all, please help how to set criteria of selecting only integer from specific field as below, Many thanks

Zoher_Ali · January 5, 2020, 11:18am

Hi @andrew.phiss, you can use IsNumeric(TranGLC.Key2) function of SQL.

andrew.phiss · January 6, 2020, 3:50am

Thanks but it still doesnt work well, please help to check syntax as below and it prompt error of “Possible unauthorized query” thx