idea Paste/Write SQL values in Filter Widget in ArcGIS Experience Builder Ideas

Paste/Write SQL values in Filter Widget

NielsPerfectPlace — Wed, 06 Apr 2022 09:32:32 GMT

In the Filter Widget, you have to create the entire query/queries manually for new layers. This is also the case if you switch the data layer with another. Even though there is an SQL text box in the window, I cannot edit this or write my own SQL.

I have to sometimes create multiple copies of the same filter/query in different experiences. Being able to paste a query into the box would save a lot of time, as I wouldn't have to manually go through all the clicking.

Re: Paste/Write SQL values in Filter Widget

AngelaSchirck — Tue, 10 Oct 2023 15:13:00 GMT

YES! I have over 2000 values i need to filter out, and i'm having to enter them ONE AT A TIME! It would be nice to be able to TYPE MY OWN SQL expression.

Re: Paste/Write SQL values in Filter Widget

Tiff — Wed, 06 Mar 2024 14:08:50 GMT

This needs to be addressed or submitted officially as an enhancement! This is A LOT of duplicate work especially when the source data changes and the filters are reset.

Re: Paste/Write SQL values in Filter Widget

AndrewWallick — Wed, 27 Mar 2024 19:10:34 GMT

Being able to edit the SQL for filters is huge for us. We have users who need to look for data within the last 2 years. I can set a filter for dates between a range, and the end of the range I can set as "today". But there's no way to set the beginning of the range as "today minus 2 years".

So users have to change the filer every time they use it. Creates a lot of extra clicks and hassle.

Re: Paste/Write SQL values in Filter Widget

Timothy — Mon, 01 Jul 2024 03:39:53 GMT

Is this capability built or planned to be incorporated?
(it's not at 11.1)

Our users would like to copy simple but extensive SQL expressions they've created in ArcGIS Pro.

Seems like a simple implementation, assuming it's not done due to potentially security vulnerability.

Re: Paste/Write SQL values in Filter Widget

DanCopKac — Thu, 07 Nov 2024 19:36:49 GMT

Go into the config.json file and there, AND ONLY THERE, can you write your own SQL queries.

What's with this handholding and treating us like children?