<>ALL not working for me!

Umb

ok - so I have a date variable and 2 lists in my form and the idea is that for any particular date to show all engineers with jobs assigned to them in the first list (which works fine) and the second list should show all engineers that do not have a job assigned to them (which does not work) - I have a sub query which filters the jobs by the start date = date variable and returns the engineer id's ... my filter is engineer id <>ALL sub query - so my expected list output is every engineer whose id is not assigned to a job but I get no results ... but here's the weird bit ... it works just fine if there is either 0 or 1 engineer with an assigned job but if there are any more than 1 then I get '-no results- ' ... if I change <>ALL to =ALL it produces a list of the engineers that have jobs so I don't think it's my sub query to blame

Any ideas?

gabriel

It does not look like an obvious issue - stuff like using sub queries wrong or the like.

Unfortunately, if it´s not an obvious issue, it´s probably something related to data structure - which takes much more details to figure out why your filters do not work as you expect.

My suggestion: Try to replicate the filter by using raw SQL. Then you can see if your filter does what you expect and can troubleshoot each sub query individually. If it works in SQL, it should work in r3.