# \[Solved\] Filtering results for Data Viewer List **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** dynamic-filter, data-viewer\ **Created:** [November 3, 2021, 5:55pm UTC](https://community.thunkable.com/t/solved-filtering-results-for-data-viewer-list/1595919 "2021-11-03T17:55:01Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![vvaroczii](https://avatars.discourse-cdn.com/v4/letter/v/48db29/32.png) [@vvaroczii](https://community.thunkable.com/u/vvaroczii)\ **Post date:** [November 3, 2021, 5:55pm UTC](https://community.thunkable.com/t/solved-filtering-results-for-data-viewer-list/1595919/1 "2021-11-03T17:55:01Z")
Hi, I am trying to return a list of items created by the user in the data viewer list. I can do this in the list viewer by filtering based on the user\_id however I wasnt able to work out how can I do the same using the data viewer list. Anyone has any experience with this? Many thanks in advance! V ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [November 3, 2021, 6:37pm UTC](https://community.thunkable.com/t/solved-filtering-results-for-data-viewer-list/1595919/2 "2021-11-03T18:37:05Z")
If you want to filter data using a Data Viewer List (DVL), you will need to change the data itself within the data source. The only way to have a full data set and display a portion of it in a DVL is to have two sheets/tables and have one filtered with certain data using views/formulas in the data source itself. The full data gets updated by you/users and the fitered data is synced to the DVL. (Thanks to @muneer for this suggestion.) ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [November 3, 2021, 6:55pm UTC](https://community.thunkable.com/t/solved-filtering-results-for-data-viewer-list/1595919/3 "2021-11-03T18:55:40Z")
Remember that filtering is a function of the data source itself so it will work with Google sheet and Airtable but will not work with local tables. ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [November 3, 2021, 7:19pm UTC](https://community.thunkable.com/t/solved-filtering-results-for-data-viewer-list/1595919/4 "2021-11-03T19:19:10Z")
If you want to filter a DVL connected to a local table, you can use this trick that I’m implementing in this project. (not suitable for large data). Of course this trick will work for Google sheet and Airtable too. [https://x.thunkable.com/projectPage/6182dddab8ae1a001142ac60](https://x.thunkable.com/projectPage/6182dddab8ae1a001142ac60) ---
**Author:** ![vvaroczii](https://avatars.discourse-cdn.com/v4/letter/v/48db29/32.png) [@vvaroczii](https://community.thunkable.com/u/vvaroczii)\ **Post date:** [November 4, 2021, 4:25am UTC](https://community.thunkable.com/t/solved-filtering-results-for-data-viewer-list/1595919/5 "2021-11-04T04:25:31Z")
Thanks @muneer ! I am experimenting with something else I have seen and learnt from one of your other projects. Basically I am using a Temp Local Table and implemented the following workflow: 1. Clear all rows in Temp Local Table when screen opens 2. Create a list from my Google Sheet using the filter criteria when screen opens 3. Populate the Temp Local Table with the list of values when screen opens 4. Data Viewer calls Temp Local Table For some reason works on the companion app but crashes on the web viewer. ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [November 4, 2021, 9:50am UTC](https://community.thunkable.com/t/solved-filtering-results-for-data-viewer-list/1595919/6 "2021-11-04T09:50:25Z")
If you share your blocks here or provide a link to your project then I can look into your blocks and maybe I can see the code making it crashes. ---
**Author:** ![vvaroczii](https://avatars.discourse-cdn.com/v4/letter/v/48db29/32.png) [@vvaroczii](https://community.thunkable.com/u/vvaroczii)\ **Post date:** [November 4, 2021, 1:06pm UTC](https://community.thunkable.com/t/solved-filtering-results-for-data-viewer-list/1595919/7 "2021-11-04T13:06:57Z")
Thanks @muneer . I dont thinks it is the blocks…looks like the screen is corrupted? When I duplicate it, it is displayed correctly but the original screen is just showing as blank… ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/c/ec25f99d50c88354a8d4e9902fc22d47e6235622.png) ---
**Author:** ![vvaroczii](https://avatars.discourse-cdn.com/v4/letter/v/48db29/32.png) [@vvaroczii](https://community.thunkable.com/u/vvaroczii)\ **Post date:** [November 4, 2021, 1:10pm UTC](https://community.thunkable.com/t/solved-filtering-results-for-data-viewer-list/1595919/8 "2021-11-04T13:10:40Z")
ahhhh…the duplicate screen doesnt have the blocks 😭 😭 😭 ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [November 4, 2021, 1:51pm UTC](https://community.thunkable.com/t/solved-filtering-results-for-data-viewer-list/1595919/9 "2021-11-04T13:51:29Z")
In DnD UI when you duplicate the screen the notice message says that blocks will not be copied. However, you can go to the blocks in the original screen and use the copy/paste of your computer. Ctrl-C and Ctrl-V to copy over the blocks each group at a time. So you can copy the button click in the original screen by Ctrl-C then go to the new screen and click Ctrl-V. Have fun with it. ---
**Author:** ![vvaroczii](https://avatars.discourse-cdn.com/v4/letter/v/48db29/32.png) [@vvaroczii](https://community.thunkable.com/u/vvaroczii)\ **Post date:** [November 6, 2021, 7:57am UTC](https://community.thunkable.com/t/solved-filtering-results-for-data-viewer-list/1595919/10 "2021-11-06T07:57:29Z")
Thank you. It worked like a treat! ---
**Author:** ![supremefaptechjzgbl](https://avatars.discourse-cdn.com/v4/letter/s/cdc98d/32.png) [@supremefaptechjzgbl](https://community.thunkable.com/u/supremefaptechjzgbl)\ **Post date:** [December 2, 2021, 11:04am UTC](https://community.thunkable.com/t/solved-filtering-results-for-data-viewer-list/1595919/11 "2021-12-02T11:04:55Z")
Thank you sir, But I have difficulty figuring out where you picked these block I marked in the attached below. ![Inkedblock_LI](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/3/e30ede6ebe66a969a62dbd4a6dcf6172f1dfe06f.jpeg) ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [December 2, 2021, 2:19pm UTC](https://community.thunkable.com/t/solved-filtering-results-for-data-viewer-list/1595919/12 "2021-12-02T14:19:47Z")
See this ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/8/e8faf07241cfeb0407f426d5a8d47af9cabf5477.png) Please note that in DnD, there is currently a **BUG** preventing this option from being used. ---
**Author:** ![supremefaptechjzgbl](https://avatars.discourse-cdn.com/v4/letter/s/cdc98d/32.png) [@supremefaptechjzgbl](https://community.thunkable.com/u/supremefaptechjzgbl)\ **Post date:** [December 2, 2021, 9:24pm UTC](https://community.thunkable.com/t/solved-filtering-results-for-data-viewer-list/1595919/13 "2021-12-02T21:24:39Z")
Oh! my fault, I am working with DnD. Thank you sir ---
**Author:** ![vijayakumar.palanisa](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/vijayakumar.palanisa/32/130234_2.png) [@vijayakumar.palanisa](https://community.thunkable.com/u/vijayakumar.palanisa)\ **Post date:** [July 2, 2022, 1:25pm UTC](https://community.thunkable.com/t/solved-filtering-results-for-data-viewer-list/1595919/14 "2022-07-02T13:25:47Z")
Ok once i’m loged in my friend mobile that time how we get the local data ---
**Author:** ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)\ **Post date:** [November 8, 2024, 1:14pm UTC](https://community.thunkable.com/t/solved-filtering-results-for-data-viewer-list/1595919/15 "2024-11-08T13:14:31Z")