@whitneyas Hi Alex. Several thoughts here.
The dataset1 you are using is empty so it’s hard to see what impact it is having on your page.
Based on your other comments it sounds like you have two datasets involved in the output you are seeing. The different out put you are seeing may have nothing to do with the filter or be a side effect of the filter failing.
The most important thing is how you have wired up the reference field. A reference field needs to be populated with the ‘_id’ value of the table row it is referencing. You can’t pick a random column such as ‘title’ or ‘email’. You have to think of each reference as being the whole row of a table. The only unique value in a Rowe entry of a data collection isn’t its ID. This is accessed using the ‘_id’ field key in Code.
I would reread the data collection docs on reference fields if I was you.
The value that is displayed in the reference field comes from the primary field of the specific item in the referenced collection. The actual value that is stored in the database is the ID of the referenced item (in other words, the value in the ID system field of the referenced collection).
Also you need to look at why the table is empty. It may be a side effect of the incorrect use of the reference field or not syncing all sandbox dat collections to live. You may also have a permissions problem on one or other of the data collections that stops access to the dataset.
Hope this helps
Cheers
Steve