Fetching data and filtering best practices

Hi @aurelie . How does this depend? You mean adding a filter at the collection level may NOT actually request a filtered response from the data source?

I’m particularly concerned with Airtable.

If I add a filter within the collection configuration, is the intended behavior that the response will only include the filtered results?

Thanks

EDIT: to elaborate a bit further on what specifically I’m seeking to confirm…

I have a users table in airtable that contains a field for auth0 ID, which is what I want to filter by. Based on the editor UI in weweb, it seems apparent that if I want to make a call to my airtable table and retrieve a record for only my authenticated user, I would simply need to add a filter at the user collection level that filters like “where auth0ID = <auth0 ID from auth0 plugin*”.

In the editor, adding that filter results in that collection only returned 1 record, as expected.

Is this how it is intended to behave in a published app too? That only that 1 record that meets the filter conditions would be returned?