We have lots of relational fields and want to filter records based on that. ut when we try to filter records with relation field we get error . W e tried this tewnty cloud and self hosted solution both . Have attached screen shots for the error and query details.
We basically want to filter the relation fields . Please let us know if there is something wrong in the syntax we used.