Hi,
I have two tables, each with a relation to a user from the Users table.
I want to query users which are in one of the two tables, using this query (I am trying in the search bar of the web console, in the Users table):
MotionOperators[user].objectId <> '' OR AeroOperators[user].objectId <> ''
I get the error “Could not perform persistence operation: com.mysql.jdbc.exceptions.jdbc4.MySQ… Not unique table/alias: ‘relateduser’” (part of the error is cut off in the tooltip).
It seems there is some internal variable naming bug or something, because when I change the user property to operatorUser in the AeroOperators table, this code does work as expected:
MotionOperators[user].objectId <> '' OR AeroOperators[operatorUser].objectId <> ''
Kind regards,
Jeroen