https://community.esri.com/t5/arcgis-dashboards-ideas/allow-option-to-write-sql-query-code-for-filters/idi-p/1504797 <P>Currently in dashboards, if you want to apply a filter to data in an indicator or other widget, you need to click through all of the options (field, condition, and value). While this is a good no-code option for many users, if creating a complex or repetitive filter in a dashboard, it's a super time-consuming process.</P><P>There should be an option that allows users to write a SQL query for a filter, much like the option in ArcGIS Pro now for definition queries so it can be more reproducible and less of a headache when creating longer, complex filters based on many fields.</P> Fri, 12 Jul 2024 14:14:07 GMT CameronLacelle 2024-07-12T14:14:07Z https://community.esri.com/t5/arcgis-dashboards-ideas/allow-option-to-write-sql-query-code-for-filters/idi-p/1504797 <P>Currently in dashboards, if you want to apply a filter to data in an indicator or other widget, you need to click through all of the options (field, condition, and value). While this is a good no-code option for many users, if creating a complex or repetitive filter in a dashboard, it's a super time-consuming process.</P><P>There should be an option that allows users to write a SQL query for a filter, much like the option in ArcGIS Pro now for definition queries so it can be more reproducible and less of a headache when creating longer, complex filters based on many fields.</P> Fri, 12 Jul 2024 14:14:07 GMT https://community.esri.com/t5/arcgis-dashboards-ideas/allow-option-to-write-sql-query-code-for-filters/idi-p/1504797 CameronLacelle 2024-07-12T14:14:07Z https://community.esri.com/t5/arcgis-dashboards-ideas/allow-option-to-write-sql-query-code-for-filters/idc-p/1504803#M2532 <P>Yes, PLEASE. I have a couple dashboards with <EM>bonkers</EM> filters, and adjusting them is awful.</P><P><a href="https://community.esri.com/t5/user/viewprofilepage/user-id/719853">@CameronLacelle</a>you <EM>could </EM>edit the dashboard JSON directly to write the SQL yourself, but that approach always makes me nervous that I'm going to break something! <span class="lia-unicode-emoji" title=":grinning_face_with_sweat:">😅</span></P> Fri, 12 Jul 2024 14:18:33 GMT https://community.esri.com/t5/arcgis-dashboards-ideas/allow-option-to-write-sql-query-code-for-filters/idc-p/1504803#M2532 jcarlson 2024-07-12T14:18:33Z https://community.esri.com/t5/arcgis-dashboards-ideas/allow-option-to-write-sql-query-code-for-filters/idc-p/1504805#M2533 <P><a href="https://community.esri.com/t5/user/viewprofilepage/user-id/363906">@jcarlson</a>&nbsp;I already break things way too often and have to be a repair man for our apps, I'll just deal with the pains of also creating bonkers filters lol</P> Fri, 12 Jul 2024 14:21:28 GMT https://community.esri.com/t5/arcgis-dashboards-ideas/allow-option-to-write-sql-query-code-for-filters/idc-p/1504805#M2533 CameronLacelle 2024-07-12T14:21:28Z https://community.esri.com/t5/arcgis-dashboards-ideas/allow-option-to-write-sql-query-code-for-filters/idc-p/1584381#M2707 <P>Yes SQL filters for dashboards would be very helpful to have.</P> Wed, 12 Feb 2025 10:05:04 GMT https://community.esri.com/t5/arcgis-dashboards-ideas/allow-option-to-write-sql-query-code-for-filters/idc-p/1584381#M2707 MathiasKPoulsen 2025-02-12T10:05:04Z