Doing a search where the constraint uses both values from the same object

I’m trying to do a search like the following

do a search for “my things” where “my things quantity” < “my things quantity required”

am I missing something as it there doesnt seam to be a viable option to do this

I don’t think you can do that in a search, but you can in a filter using the Advanced option.

Awesome thankyou

I’ve seen the advanced feature but didn’t know what it was

Can you explain a little more about it to me and is there any documentation on it

Btw I’m pretty sure this will solve my problem so thankyou in advance

There’s not much in the docs about this…it’s just a way to apply more complicated constraints. It will usually be slower than a search, but it is sometimes the only way to get exactly what you want.