Google app engine gql query two properties with same string
Note that there is no gain of performance in using Drew's schema, because queries in list properties must check for equality against all the elements of the list.
I have a data model called Game.
In the Game model, I have two properties called player1 and player2 which are their names.
I want to find a player in gamebut I don't know how to buil the query because gql does not support OR clause and then I can't use select * from Game where player1 = 'tom' or player2 = 'tom' statement.
So, how can I solve this question?
Do I have to modify my data model?