Latest Contributions by Bud

‎02-08-2023

Esri Canada Case #03259723 - ArcGIS Pro: Modifying existing definition query disables the query Esri inc confirmed that this issue is related to the previous bug [BUG-000155660] so we do not need to make a new one.

‎02-08-2023

Additionally, on the notifications page, why do the notifications only mention the post's old location (ArcGIS Ideas Blog), and not the new location (JavaScript Maps SDK Ideas)? Bud_0-1675880852459.png

‎02-08-2023

@TeresaDolan and @JesseCloutier recently moved an idea someone posted -- from the ArcGIS Ideas Blog to JavaScript Maps SDK Ideas: Finish creating a line or polygone feature on mobile devices I received a notification email about the idea being moved -- because I had commented on it. Question: Why does that notification email say it's my idea? Your post Finish creating a line or polygone feature on mobile devices on Esri Community is modified! Bud_0-1675879118183.png I wonder if that wording could be improved to avoid confusion in the future.

‎02-07-2023

@IrinaVortkamp What product does this idea pertain to? ArcGIS web app builder? Or something else? Unless I'm missing something, it seems like this idea should be moved to product-specific ideas page. Maybe @JesseCloutier can help.

‎02-07-2023

@BradySmith Regarding: It would also be nice if there was a way to add rows in an ArcGIS Online table without using desktop software. Should you submit a separate idea for that to ensure it's seen?

‎02-06-2023

ArcGIS Pro 3.0.3; mobile geodatabase: I want to put SQL comments in definition query SQL expressions. From my testing, these kinds of comments seem to work as expected: Works: Multi-line SQL comments at the beginning or end of the SQL expression: /*multi-line sql comment*/ OBJECTID IN (3, 5, 11) OBJECTID IN (3, 5, 11) /*multi-line sql comment*/ Works: Single-line SQL comments at the beginning of the SQL expression: --single-line sql comment OBJECTID IN (3, 5, 11) Doesn't work: Single-line SQL comments at the end of the SQL expression: OBJECTID IN (3, 5, 11) --single-line sql comment Error: The SQL expression has invalid syntax. Bud_0-1675723063921.png Question: Why don't single-line comments work at the end of SQL expressions in ArcGIS Pro? Is that a bug? I don't have that issue when creating full-blown SELECT queries in database views, query layers, or SQL Developer queries. I only seem to have that problem with ArcGIS Pro SQL expressions. Note: There is a bug in ArcGIS Pro 3.0.3 that can be a nuisance: Modifying existing SQL expression disables definition query. So when testing things like the comments/SQL above, we need to re-enable definition queries after modifying the SQL.

‎02-06-2023

ArcGIS Pro 3.0.3; mobile geodatabase: Using a standalone table like this: . ASSET_ID DATE_ CONDITION -------- ---------- --------- 1 2016-04-01 1 1 2019-03-01 2 1 2022-01-01 3 2 2016-04-01 4 2 2022-01-01 5 3 2022-01-01 6 3 2022-03-01 7 3 2018-03-01 8 3 2013-03-01 9 3 2010-06-01 10 3 2022-03-01 11 3 2022-03-01 11 And using a non-expression builder definition query like this: --sql comment OBJECTID IN (3, 5, 11) ...or like this: objectid IN ( SELECT objectid FROM roadinsptable r2 WHERE r2.asset_id = roadinsptable.asset_id ORDER BY date_ DESC, condition DESC LIMIT 1 ) Both of those definition queries work as-is and are active. But after creating those definition queries, if I were to modify the SQL by doing something like add a few spaces to the end, or change a 1 to a 2, then the definition query would get disabled. For example, if I were to change --sql comment OBJECTID IN (3, 5, 11) to --sql comment OBJECTID IN (3, 5, 12) then that would disable the definition query. That's not the expected result. Here's a video example of adding spaces to the end of an SQL expression: Is that a known issue? Related: Make definition query's toggle more intuitive

‎02-06-2023

Screen recording video (ignore the video title; this video demonstrates multiple issues; I used it in multiple posts):

‎02-05-2023

Anyone using Oracle’s pending statistics functionality in their Oracle enterprise geodatabases? Gather statistics without automatically publishing them https://youtu.be/D_p9AEl0ecE

‎02-03-2023

Related ideas: Raise exception when correlated subquery used in FGDB SQL (not supported) - Feb 3, 2023 Support correlated subqueries in file geodatabase SQL expressions Clarify the docs: Correlated subqueries not supported in FGDB SQL expressions

‎02-03-2023

A correlated subquery is a subquery that depends on a value or table name from the main query that surrounds it. Source: Practical SQL by Anthony Debarros. Example: NOT EXISTS ( SELECT * FROM road_insp r2 WHERE r2.asset_id = road_insp.asset_id AND r2.date_ > road_insp.date_ ) --Demo: https://dbfiddle.uk/gSGjLTCW If we use a correlated subquery in file geodatabase SQL, such as in an FGDB view or SQL expression, then ArcGIS Pro will execute the SQL without throwing an error, but the result will be incorrect. Despite the presence of the subquery in the WHERE clause, either all rows or no rows will be returned, which is not the correct result. The incorrect results are misleading and can cause serious problems in our GIS analysis if not caught. In a community post, an Esri staff member mentioned, "File Geodatabase does not support correlated subqueries." But you'd never know it when writing SQL in ArcGIS Pro. Idea: Could ArcGIS Pro be enhanced so that it raises an exception when a correlated subquery is used in FGDB SQL? Related: Support correlated subqueries in file geodatabase SQL expressions Clarify the docs: Correlated subqueries not supported in FGDB SQL expressions When EXISTS Doesn't: File Geodatabases and Correlated Subqueries Thanks.

‎02-03-2023

@TeresaDolan Out of curiosity, why was this idea moved to the ArcGIS Ideas Blog?

‎02-02-2023

@KoryKramer Feel free to close this idea. From Support (Esri Canada Case #03256325): I was able to reproduce the behaviour that you described. Right-clicking and selecting paste does not work when attempting to paste a value into the query builder in the Select By Attributes tool with ArcGIS Pro 3.0.3. I've identified a bug that was created for this behaviour that was marked as fixed in 3.0, but I will note that it is now occurring in later versions of ArcGIS Pro and push for it to be reopened. BUG-000140702 - Right-clicking and selecting paste does not work when attempting to paste a value into the query builder in the Select By Attributes tool

‎02-02-2023

In the Catalog pane: It would be helpful if we could easily filter objects in a specific geodatabase/connection. For example, search a specific enterprise geodatabase for the word "sewer". I'm aware that there is a search bar in the Catalog pane. But I've never had any luck using it. In ArcGIS Pro 2.6.8, it always just says, "Indexing is in progress. Please wait or search again later." Bud_0-1675350394943.png I posted a related question in July 2022: Searching for an object in Catalog hangs The same thing happens when I search a geodatabase using the Catalog View. Bud_0-1675351505550.png And in ArcGIS 3.0.3 (a different computer), the search doesn't produce any results, even though there are feature classes in a mobile geodatabase with "sewer" in the name: Bud_2-1675350596170.png The same problem happens with file geodatabases. So my assumption is that search functionality isn't designed to work the way I want it to. Notes: I don't really utilize projects much, other than creating a project in order to use ArcGIS Pro. I simply explore data in Catalog and occasionally add objects to the map to see what they look like. One of the reasons is: It's often best to start from scratch when doing testing. I'd rather start with a new project than use an old one, to make sure there aren't any lingering issues in the project that would compromise the test. So I don't want to index a geodatabase in a project file. I want to open a new project and easily search my enterprise geodatabase connection without any other overhead. That kind of thing is possible in a SQL client like SQL Developer (Oracle). No indexes required. So I don't see why an index is needed when searching geodatabase objects in ArcGIS Pro.

‎02-02-2023

@JonathanNeal Does the append tool let you create a feature or row from scratch? As in, manually enter the field values, rather than import from an existing record from a FC or table? I updated the question.

My Ideas

Latest Contributions by Bud

Re: Modifying existing SQL expression disables definition query

Re: Idea moved to different community: Notification email suggests the post is mine, but it isn't

Idea moved to different community: Notification email suggests the post is mine, but it isn't

Re: Finish creating a line or polygone feature on mobile devices

Re: Insert Feature/Row geoprocessing tool

Comments in SQL expressions — Single-line comment at and of statement causes error

Modifying existing SQL expression disables definition query

Re: Join to table with definition query — column name should get prefixed (SQL expression with subquery)

Oracle Pending Statistics

Re: When EXISTS Doesn't: File Geodatabases and Correlated Subqueries

Raise exception when correlated subquery used in FGDB SQL (not supported)

Re: Finish creating a line or polygone feature on mobile devices

Re: Select By Attributes: Allow pasting from right-click context menu

Catalog pane — Easily filter objects in a specific geodatabase/connection

Re: Insert Feature geoprocessing tool

Integrate ArcGIS Data Pipelines in ArcGIS Enterpri...

Send configurable email notifications from ArcGIS ...

Re: How reliable are ArcGIS Online webhooks?

How reliable are ArcGIS Online webhooks?

Sharepoint List Connector

GIS Jobs

Roads and Highways User Group (RHUG)

Local Government Solutions Users

Mapping and Charting Enterprise Databases

ArcGIS Arcade