Latest Contributions by Bud

I don't have experience with Portal, and I'm not quite following your last paragraph: Is there a way to perform this join in the view layer that will just append the column names of the sub-inspection table to the main inspection table? Obviously with the same column names, that is why it's appending rows, but I would be fine if it just appended to the columns with a suffix "_1", "_2", etc. Can I do this in arcade somehow right in the pop-up for the feature layer? The feature layer itself contains the main feature and the related sub-table. But a database view or query layer might do what you need. There is a Make Aggregation Query Layer that could be used to get a list of playground inspections and also a field that is a count of the related playground equipment sub-inspections. But that tool is buggy. If you are unfamiliar with SQL and you want to share some fake data via Excel or a mobile geodatabase, I could show you how to do it via SQL, which could be used in a database view or query layer. You could share screenshots of fake input data, and mock up the result you want in Excel and share that as a screenshot, to make it clear what you're looking for. What kind of database is your enterprise geodatabase? I.e. Oracle 18c. ... View more

Nested replies in idea comments ... View more

If you can't find a way to do this, you could submit an idea: https://community.esri.com/t5/arcgis-pro-ideas/idb-p/arcgis-pro-ideas It would help to link to it here so that we can see it and upvote it. ... View more

Esri Case #03621411 - Invalid Syntax error when subquery used on unregistered table, query layer, or database view BUG-000168914: Error "The SQL expression has invalid syntax" is encountered when a subquery is used on an unregistered table, query layer, or unregistered database view. That issue applies to definition queries and Select By Attributes. ArcGIS Pro 3.3.0; Oracle 18c 10.7.1 EGDB table_non_reg_gdb.objectid IN (SELECT objectid FROM table_non_reg_gdb t2 WHERE t2.event_id = table_non_reg_gdb.event_id and fund_source =  'TOT' ORDER BY year_fund DESC FETCH FIRST ROW ONLY)   ... View more

Idea: Documentation about new workspace caching functionality in Pro 3.3.0 ... View more

Can you describe the relationship between the points and the polygon vertices? Do the point features have a common ID with the polygons? Does the location of the points exactly coincide with the polygon vertices? Is there a point for each and every polygon vertex? Can you show us a screenshot of the features and any ID attributes in the attribute table? What is the geodatabase type and spatial data type? For example, Oracle enterprise geodatabase, SDE.ST_GEOMETRY. ... View more

You could submit an idea: https://community.esri.com/t5/arcgis-pro-ideas/idb-p/arcgis-pro-ideas  If you do submit an idea, it would help if you could link to it here so that I can follow it. ... View more

Any update? ... View more

Was any new functionality added in this release? ... View more

I didn't get an email notification about @JesseCloutier 's "Thanks for letting us know" reply. But I did get an email notification about @KenBuja response to it. When I get @KenBuja 's "You don't have any notifications" error, I switch browsers (clearing the cache might have the same effect). That way, I can see notifications and avoid the error, but all messages are marked as already read, which isn't ideal. ... View more

For what it’s worth, I got a feed notification about the following reply, but not an email, even though I’m subscribed to that post, so I should be getting emails: https://community.esri.com/t5/arcgis-pro-questions/career-change/m-p/1496242/highlight/true#M84866  ... View more

Perform join at the database level, not the application level, when the datasets are in the same workspace ... View more

Thanks @JMalik. ... View more