Hi
Quick question - I set up a one record working table that looks up a customer’s rowID based on the logged in User profile.
A relationship column in this working table brings in all related records for that customer.
I have a query on that relationship, that filters for records that match criteria specific to the logged in user.
Will ALL the records in the Customer Relationship be downloaded to the user’s device, or only the records that match the query’s criteria?
If only the query results, would this not then be considered a “security” measure protecting against downloading more than the current user is entitled to see?
Both relations and queries are computed columns. All computed columns are evaluated on the client device*. In order to evaluate a computed column, a device must first download the data.
No. If it was that easy, nobody would bother with Row Owners.
* there are a small number of computed columns that are evaluated server side. This applies with Big tables only, and it’s unclear - to me at least - how this works (or not) with Row Owners. For now, I continue to assume that any data that isn’t protected by row owners can be potentially exposed.