Filter: Return a row with two matching columns?


#1

Is there a way to GET a record where two columns in the same row match? For example, If FIELD1 and FIELD13 both had the name Bob in the same row in a mysql database, could I return that record?

I’m trying to return all rows where FIELD1 and FIELD13 are equal to each other.


#2

I guess you can implement that feature using a script service which accesses the DB directly.