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

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: