topic Re: Pre-filter next clause in Query-widget in ArcGIS Experience Builder Questions

Pre-filter next clause in Query-widget

Anonymous User — Fri, 27 Aug 2021 16:16:00 GMT

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?

Re: Pre-filter next clause in Query-widget

TonghuiMing — Mon, 30 Aug 2021 02:33:39 GMT

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:

Re: Pre-filter next clause in Query-widget

Anonymous User — Tue, 31 Aug 2021 08:50:25 GMT

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

Re: Pre-filter next clause in Query-widget

Ellie_Linden — Fri, 10 Apr 2026 13:30:58 GMT

Hi @TonghuiMing, I know this is an old thread but I have a very similar related question. I can see how a filter query can be configured so it is pre-filtered by earlier expressions within the filter. However, if a Filter widget has multiple filters (as set up using the "New filter" button), can the different filters limit the value lists of one another?