@TonghuiMing
In this public app, I have 2 group filters. The first for state, the second for counties. It's supposed to list only counties in the state. See screenshots.
https://experience.arcgis.com/experience/0c56c3c5241e47a487531f4a79464ae3/
The SQL for the second group filter states "List values based on Values filtered by all other expressions".
However, it does not. Counties that are not in California are listed e.g., Acadia Parish is in Louisiana.
See earlier post:
Group filter widget - Page 2 - Esri Community