# It takes too long to retrieve the pick values from a filter which is not part of the dashboard

**URL:** <https://community.omni.co/t/it-takes-too-long-to-retrieve-the-pick-values-from-a-filter-which-is-not-part-of-the-dashboard/461>\
**Category:** Workbooks\
**Tags:** filtering\
**Created:** [June 2, 2026, 11:50pm UTC](https://community.omni.co/t/it-takes-too-long-to-retrieve-the-pick-values-from-a-filter-which-is-not-part-of-the-dashboard/461 "2026-06-02T23:50:24Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Isma](https://avatars.discourse-cdn.com/v4/letter/i/4af34b/32.png) [@Isma](https://community.omni.co/u/Isma)\
**Post date:** [June 2, 2026, 11:50pm UTC](https://community.omni.co/t/it-takes-too-long-to-retrieve-the-pick-values-from-a-filter-which-is-not-part-of-the-dashboard/461/1 "2026-06-02T23:50:24Z")

</div>

Hello,

I would like to know what is the behavior(executed query) at the time I want to pick some value from a filter which is not part of the dashboard(main query), because it is taking too long and it does not work at the end. Thank you.

Regards!

---

<div class="post-metadata">

**Author:** ![James](https://avatars.discourse-cdn.com/v4/letter/j/bc8723/32.png) [@James](https://community.omni.co/u/James)\
**Post date:** [June 3, 2026, 5:42pm UTC](https://community.omni.co/t/it-takes-too-long-to-retrieve-the-pick-values-from-a-filter-which-is-not-part-of-the-dashboard/461/2 "2026-06-03T17:42:14Z")

</div>

Hi Isma! Filter suggestions will run a select \* against the field being filtered to populate the suggestion list [Building point-and-click queries - Omni Docs](https://docs.omni.co/analyze-explore/point-click-queries#filter-suggestions)

There are other ways to get that list to appear, such as

[Suggestion List](https://docs.omni.co/modeling/dimensions/parameters/suggestion-list#suggestion_list) - describe a list of suggestion options  
[Suggest From Field](https://docs.omni.co/modeling/dimensions/parameters/suggest-from-field#suggest_from_field) - populate suggestions from a different field

Happy to take a closer look if you don’t mind reaching out to Support via your Teams/Slack channel or by email [support@omni.co](mailto:support@omni.co)

---

<div class="post-metadata">

**Author:** ![Isma](https://avatars.discourse-cdn.com/v4/letter/i/4af34b/32.png) [@Isma](https://community.omni.co/u/Isma)\
**Post date:** [June 9, 2026, 11:45pm UTC](https://community.omni.co/t/it-takes-too-long-to-retrieve-the-pick-values-from-a-filter-which-is-not-part-of-the-dashboard/461/3 "2026-06-09T23:45:00Z")

</div>

Thank you for the reply, but unfortunately what you suggested is using hard coded data right?, and I want it to be dynamically, so I am still facing an issue at the time I want to pick some value in the filter, this is the story:

There is a topic that looks for 1 year of data. While it performs well and handles adding new columns as expected, I’ve encountered an issue with data filtering.  
When applying a new filter and trying to pick a value, Omni appears to ignore any existing dashboard filters. Instead, it retrieves filter values based solely on the initial “always\_where\_sql” setting of one year. This doesn’t make sense to me, especially since I have already limited the dashboard view to two days, as shown in the image below. The filter continues to query the full year regardless of those active constraints, but it never loads the values.

![image.png](https://mail.google.com/mail/u/6?ui=2&ik=15ddf43d0e&attid=0.1&permmsgid=msg-a:r-8025132031680556744&th=19eaeb4f320a9186&view=fimg&fur=ip&permmsgid=msg-a:r-8025132031680556744&sz=s0-l75-ft&attbid=ANGjdJ80MHIwbeqtOhOFVRwAppOlUd0cw9AOX_LhztVVePoMysn2njKv-Htyyqh2hcxOnAAbaZbQcdJEcZwwXZ8SS_qS4DJdhaMAArctcqbkUIeuSGO10_YvYW3x260&disp=emb&realattid=ii_mq79kqtz0&zw)

Regardless of the filters applied on the dashboard, the query Omni executes to fetch filter values remains structured like this:

![image.png](https://mail.google.com/mail/u/6?ui=2&ik=15ddf43d0e&attid=0.2&permmsgid=msg-a:r-8025132031680556744&th=19eaeb4f320a9186&view=fimg&fur=ip&permmsgid=msg-a:r-8025132031680556744&sz=s0-l75-ft&attbid=ANGjdJ8ENZ8sjhl5-7ko5RBCNuTQ4GdQGBVoJY88eQYU2mTI3TQ0gxGdD6y4MTvFXtJhQAoxcOeWSrepijelseJsYNmjdJ4CVineYzdEpAqRfVNCR7H8HFcDmbaaj28&disp=emb&realattid=ii_mq79l8w51&zw)

Thank you.

---

<div class="post-metadata">

**Author:** ![James](https://avatars.discourse-cdn.com/v4/letter/j/bc8723/32.png) [@James](https://community.omni.co/u/James)\
**Post date:** [June 15, 2026, 7:21pm UTC](https://community.omni.co/t/it-takes-too-long-to-retrieve-the-pick-values-from-a-filter-which-is-not-part-of-the-dashboard/461/4 "2026-06-15T19:21:37Z")

</div>

Hi Isma, I’m having trouble viewing those images, would you mind reaching out to Support via your Teams/Slack channel or by email [support@omni.co](mailto:support@omni.co)? Happy to continue the thread there and take a closer look.

---

<div class="post-metadata">

**Author:** ![Isma](https://avatars.discourse-cdn.com/v4/letter/i/4af34b/32.png) [@Isma](https://community.omni.co/u/Isma)\
**Post date:** [June 16, 2026, 3:36pm UTC](https://community.omni.co/t/it-takes-too-long-to-retrieve-the-pick-values-from-a-filter-which-is-not-part-of-the-dashboard/461/5 "2026-06-16T15:36:07Z")

</div>

Hi James,

Sure, let me send this by email. Thank you so much for your response.

Regards!
