I have one model that I am trying to only show the records where field A doesn't equal field B (on the same record). Both fields are lookups to the user object. Is there a way to do this with conditions? I'm not sure if I'm having a brain fart or if this just isn't possible.
that's not an issue either, as you had not mentioned you were using a table, I thought this would not be relevant.
You have to change the value from "Fields from the First row" to "Fields From any row returned...."
Not sure what is the "official way to do that" , but I do it this way:
-Create condition as i showed above , then Change content (in value) to "result of a subquery", then without saving, change it back to "Fields from another model", and now you will see the "from any row..." condition appear