Hello! I'm exploring workspace hierarchies and I w...
# gooddata-cloud
s
Hello! I'm exploring workspace hierarchies and I was curious if there is a limit to how many values a workspace data filter can hold?
k
The knowledge sources do not explicitly mention a documented limit on the number of filter values a Workspace Data Filter (WDF) can hold. What is documented is that the API schema for
filterValues
is simply defined as an array of strings with no explicit maximum count specified. [API Reference] However, from community discussions, there is a practical limit of approximately 1,200 values when sending filter values via API requests — beyond that, requests appear to fail, seemingly due to payload size constraints rather than a strict SQL-level limit. [Community Slack] It's worth noting that this is a separate limit from the dashboard attribute filter limit of 500 selected values, which applies to UI-level attribute filters on dashboards. [Filter Limits] If you're working with a large number of filter values (e.g., thousands of user IDs), GoodData support recommends considering alternative approaches such as: â€ĸ Adjusting the LDM to model the relationship (e.g., a
UserManager
dataset linking users to managers), and using User Data Filters (UDFs) with an
IN
expression. â€ĸ Workspace Data Filters applied at the dataset level for tenant-based data separation. For the most accurate and up-to-date limit, I'd recommend reaching out to GoodData support directly, as this may vary by deployment. 👍 0 button 👎 0 button â„šī¸ Tip: Mention @kapa.ai in the thread for follow-ups. 👀 Our Support team monitors all messages and will jump in if needed.
s
Hi Sam, Thank you for your question. I can confirm the AI's answer. The limit indeed looks to be 1,2k.
🙌 1
s
Thank you Shamil!
👍 1