Filter featured not working as expected

[Mateo]

Hi, can anyone tell me with my collection is not being filtered correctly.

I’ll explain what I did. I created a user-specific column to hold a city, i named that column selected city

Then i created a query to filter all services where city is equal to selected city (i used a query instead of a relation because there are a couple of more filters)

In my table everything is fine, the query is filtering the results based on my selected city

The problem is, when i add that same filter to my collection, I’m only getting one result. What im doing is filtering the results using the filtered data feature and putting city equal to selected city

Since it is a user-specific column, i should get the same results as query column but I’m only getting the first row, is like if the filtering is not understanding that the city for all the other rows should be the selected city

Anyone knows why this happens??

btw, i was able to work around by simply selecting my query column as the data source, but i would love to understand why my first approach did not work ?

[Jeff_Hager]

Your filter only returns 1 result because only the first row has a city that matches the selected city in that same row. Your filter should be using the screen value (value from the first row, which is the row the screen is currently connected to).

I would definitely stick with using the query column as the collection source.