AX query/filter with other relative field

One of my colleague posted a question, how do we filter Dynamics AX table with value from another field.

The solution is to put the field name in the query criteria.

An example is better than explaining in words, here goes the sample.

*Remember to put the parentheses () around the query criteria else you'll get error.

This is the data before any filter

Then apply this filter

You’ll get this

So it looks like it does return the correct result