Pre-filter next clause in Query-widget

[Anonymous User]

Hello, 

I have multiple query's with multiple clauses to filter records. In the same query I would want to pre-filter the next clauses in the same filter. 

For example in this instance: if I select one bachelor program, I only want to filter the teachers that teach that program and not other teachers. 

Is that possible?

[TonghuiMing · Accepted solution]

Hi @Anonymous User - in SQL Expression Builder, we support various logics when it comes to the clause relationship. If you want to filter the next clause by the previous one(s), use the "Values filtered by previous expressions" feature in the "Ask for value" setting panel for unique values:

By configuring like that, you can see the following behavior of only the USA cities in MI being displayed in the dropdown list, which is filtered by the previously chosen value in the US State clause:

[Anonymous User]

Hello TonghuiMing, 

Ofcourse, I thought I have seen the option when I was looking at all the different options, but could not find it anymore. Thank you very much!

Kind regards, 

Geert