Hey All: I have an issue filtering on Boolean values with this query. Any assistance is appreciated. My query is:

{"function":"suiteQLRun","sql":  "SELECT * from item where itemid = '10092783' or upccode = '10092783' and BUILTIN.DF(isinactive) = 'F'" }

However it is returning records where

isinactive = 'T'

, even when that

BUILTIN.DF(isinactive)

in the select clearly returns a

'T'

. Any ideas? TIA!

can you sort your

and

/

or

out first so they are logically paired within paranthesis how you would like them to be evaluated?

why not using simple where isinactive='F'

@Zoran Roncevic I tried that, also did not work.

what did you think the parenthesis should look like

@CD That did the trick... Thanks, sorry for my oversight on that one. Got too deep into it to see the simplest answer.