# Views Based on a Query - Is

**URL:** https://community.glideapps.com/t/views-based-on-a-query-is/67225
**Category:** Ask for Help
**Tags:** data-sync
**Created:** [October 23, 2023, 7:14pm UTC](https://community.glideapps.com/t/views-based-on-a-query-is/67225 "2023-10-23T19:14:05Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![mwza](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mwza/32/43529_2.png) [@mwza](https://community.glideapps.com/u/mwza)
#### Post date: [October 23, 2023, 7:14pm UTC](https://community.glideapps.com/t/views-based-on-a-query-is/67225/1 "2023-10-23T19:14:05Z")

</div>

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?

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [October 24, 2023, 12:52am UTC](https://community.glideapps.com/t/views-based-on-a-query-is/67225/2 "2023-10-24T00:52:01Z")

</div>

> [@mwza](#):
>
> 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?

Simple answer: All records will be downloaded.

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.

> [@mwza](#):
>
> 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?

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._

---

<div class="post-metadata">

### Author: ![mwza](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mwza/32/43529_2.png) [@mwza](https://community.glideapps.com/u/mwza)
#### Post date: [October 25, 2023, 5:29am UTC](https://community.glideapps.com/t/views-based-on-a-query-is/67225/3 "2023-10-25T05:29:12Z")

</div>

Thank you Darren!

Understood.

I am battling to implement Row Owners and will submit my scenario on one of the existing threads.
