Hello everyone,
I would like to solve this issue I recently have had when trying to set a default filter within a record type. The problem is basically that I can't set this filter by the owner (List of strings) field when it includes the loggedInUser(). I'm setting the filter exactly as I described before and it doesn't solve the mentioned problem, it keeps throwing the error over and over no matter even what operator I use (have tried with IN, = as well). I would thank to anyone who can give me and suggestion to solve this problem.
Note: I already know it has something to do with relational database relationship which creates a new table when setting a List of Strings as a child value in a parent table and within this new table it storage a reference to the father table. It seems like a!queryFilter() (which is the used function in these cases) doesn't make the usual map of hibernate to turn the Relational data to Object data and it gets impossible to make this filter. Nonetheless, if someone has any way to solve this problem, I would like to see it and will be thankful for that.
Discussion posts and replies are publicly visible
Yes - you are right: cannot filter because it is a complex, or child of a multiple data type. My take is, the only workaround is to create a view in the database with all the fields in it with a 'flat' structure. Then you will be able to filter to your demands.
Thank you! I really appreciate your help. I'm going to try this interesting approach soon and let you know the results of it.