Tilde operator treats values other than true and 1 as false

[kcaashish]

Tilde operator treats values other than true and 1 as false

[tidwall]

In your case, gjson is simply treating ~false as all values that are not true-ish.

I agree that this is probably not desired.

Rather, we likely want to more explicit, where all true-ish values are true, and all false-ish are false.

I made some updates moments ago to the syntax that addresses the ~false issue.

Now vals.#(b==~false)#.a returns [3,4,5,9,10,11].

I also added two more tilde types:

~null      Converts null and non-existent values to true
~*         Converts any existing value to true

Is there a way to get the fields, for which the data is either null or missing?

Yes, using ~null or ~*:

vals.#(b==~null)#.a   => [10,11]
vals.#(b!=~null)#.a   => [1,2,3,4,5,6,7,8,9]
vals.#(b==~*)#.a      => [1,2,3,4,5,6,7,8,9,10]
vals.#(b!=~*)#.a      => [11]

[kcaashish]

Great! Just tried and it works like a charm! ~* is a handy addition too. Thank you!

[tidwall]

No problem. I'm happy to hear it's working. :)