Table filters not working with subquery conditions

  • 1
  • Question
  • Updated 2 years ago
Is there something special that has to be done to get a default off subquery condition to work with table filters?

If I turn the subquery condition to always on the information in the table is filtered correctly. When the subquery condition is set to default off and a value is entered through a table filter nothing happens. It is like the table is not being refreshed to pull the data in. 

Thanks!
Photo of Tami Lust

Tami Lust

  • 5,280 Points 5k badge 2x thumb

Posted 2 years ago

  • 1
Photo of Karl Li

Karl Li, Employee

  • 708 Points 500 badge 2x thumb
Hi Tami, could you post a screenshot of your filter set-up? 
Photo of Tami Lust

Tami Lust

  • 5,280 Points 5k badge 2x thumb
Here are screen shots of the setup.

The subquery setup:



The filter condition setup:


Photo of Matt Brown

Matt Brown, Employee

  • 798 Points 500 badge 2x thumb
Tami, it looks like you need to make the primary condition filterable in order to affect it, as shown in this Community thread: https://community.skuid.com/skuid/topics/cant-deactivate-filterable-sub-condition-on-subquery
Photo of Tami Lust

Tami Lust

  • 5,280 Points 5k badge 2x thumb
Matt,

Thanks for the input. That did not fix the issue. I moved to building a button based on the link you provided but it is not filtering the data properly in the subquery. Are there any field restrictions with sub query conditions?