Too long URL with User Attributes

nestor1
Participant II

Hey there (and happy new year!) 

I'm using a user_attribute to filter access, e.g., allowing a user to see only a subset of products.

access_filter: {
    field: products.id
    user_attribute: allowed_ids
 }

The dashboard is embedded on my application, and the allowed_ids array is built before each request. In a edge case, a user can see 1k+ products, which is already too much for the URL limit (as commas are encoded). And I get: “URL query exceeds 10k length limit: 10578

Is there a better way to filter such access? I could store the allowed_id on the database before the request, but how can I query it in the access filter? 

Additional info:  I can't use sql_always_where, cause I'm extending an explorer which already uses it.

Regards, 

Nestor

0 0 440