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

Need help Database
1

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

2

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

02%20AM
02%20AM696×207 19.9 KB

3

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

4

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.