|
IDEA
|
When editing in the attribute table, there are times when the attribute table refresh button is greyed-out, yet a refresh is needed/wanted. Example: One-to-many join - editing duplicate input table rows Bud_0-1674501875896.gif It’s slightly annoying when the refresh button is unavailable. I need to click around in the attribute table to get it to be enabled again, which seems arbitrary. Could that behavior be changed so that the refresh button is always available? Thanks. ArcGIS Pro 3.0.3
... View more
01-23-2023
11:34 AM
|
1
|
4
|
1496
|
|
POST
|
We can use the Add Join (Data Management) tool to make a one-to-many join. The resulting attribute table will have duplicate input table rows. From the docs: Bud_0-1674484866543.png Questions: Does Esri recommend editing the duplicate input table rows? Are there any known issues? Is the behavior demonstrated in the below example/GIF expected? Example: Source data: Bud_3-1674485521861.png Joined: Bud_5-1674485702251.png Editing: Notes: I'm aware that's an unusual usage pattern. But if users can do it, then they will do it. The duplicate rows don't auto-refresh. Users might find that confusing. Selecting one duplicate row will automatically select all of the corresponding duplicates. It took me a while to get used to that behavior.
... View more
01-23-2023
07:25 AM
|
0
|
3
|
4853
|
|
POST
|
In ArcGIS Pro, using an enterprise geodatabase: What are the options for dynamically joining from a FC to a related query? Use the Add Join GP tool to join to a database view. Fields from the joined view are shown in attribute table. Use the Add Join GP tool to join to a query layer. Fields from the joined query layer are shown in attribute table. Use a definition query and a subquery to filter rows. Example: EVENT_ID IN (SELECT EVENT_ID FROM …). See #1 in a similar post here. No fields from the “joined” subquery are shown in the attribute table. The nice thing about this option is that it avoids the Add Join GP tool. In my experience, joins are sometimes buggy in ArcGIS Pro. This approach avoids those issues. Use the Add Join GP tool to join to a table that has a definition query. Example: One-to-first joins: Control what related record is used Fields from the joined table are shown in attribute table. For 1-4 above, the fields from the source FC are editable. The fields in the join table aren’t editable. Join using SQL in a database view or a query layer. Fields from the joined table can be included in the result. None of the fields are editable. Any comments or other options? Oracle 18c 10.7.1 EGDB.
... View more
01-23-2023
04:03 AM
|
0
|
2
|
2557
|
|
POST
|
Regarding: Esri Community > My settings > Preferences > Private Messenger Bud_1-1674231804135.png Bud_0-1674231716506.png There is a setting called Receive email notifications for new private messages. I believe that setting is disabled by default. A while back, I noticed I wasn't getting email notifications about private messages. So I enabled that setting. But even with that setting enabled, I'm still not getting email notifications about private messages. So it seems like that setting isn't working properly. I checked my junk mail -- nothing there. Could that issue be investigated? Thanks.
... View more
01-20-2023
08:27 AM
|
0
|
6
|
2152
|
|
POST
|
Regarding Esri blog posts like this one: Introducing new Arcade documentation In a new comment, I'm trying to paste a URL or create a hyperlink. But nothing happens when I do either of those things -- I can't create a hyperlink. Bud_1-1674230007343.png Hyperlink: https://community.esri.com/t5/arcgis-pro-ideas/arcade-docs-working-with-vertices/idi-p/1152038 Blog Comment Issue.gif I have the issue in Chrome Desktop 109.0.5414.75 and Safari/iPad. Could that issue be investigated? Thanks.
... View more
01-20-2023
07:59 AM
|
0
|
3
|
1479
|
|
IDEA
|
@KoryKramer Yes, I believe so, but with the addition of automatic editor tracking. It needs to be easy to use. I.e., easy to add rows and columns.
... View more
01-19-2023
08:34 AM
|
0
|
0
|
2527
|
|
IDEA
|
(edited) @KoryKramer I mocked up an example: Bud_0-1674143088030.png
... View more
01-19-2023
07:40 AM
|
0
|
0
|
2549
|
|
IDEA
|
Thanks Kory. I basically want to add a spreadsheet-like table/grid as a section in the metadata. And manually enter a list of dependencies into it. It would be ideal if there could be editor tracking of sorts within the list -- for each entry, automatically enter the date and user. It could be thought of as a sort of dependency log or a FC usage log. I figure, metadata would be an ideal place to store such information. If a user has access to the FC, then they'd have access to the metadata too, rather than needing to hunt down a spreadsheet on the network somewhere (and deal with file locks and privileges). In other words, metadata is the perfect place to inform users how and where a FC is used -- aka a list of dependencies.
... View more
01-19-2023
07:11 AM
|
0
|
0
|
2559
|
|
POST
|
For what it's worth, I don't use AGOL either, and experience the issue occasionally too.
... View more
01-19-2023
06:18 AM
|
1
|
1
|
2710
|
|
POST
|
ArcGIS Pro 3.0.3 I've created a standalone table in a file geodatabase. And I've created a view on the table: Bud_0-1674058192344.png select * from table_a The view has been created successfully: Bud_1-1674058214128.png However, when I try to add the view to the map, I get an error: Failed to add data, unsupported data type. vw1 Bud_2-1674058307543.png And I can't rename the view. I get a blank error message: Bud_4-1674058659967.png Question for Esri: Are those known issues? Workaround: Copy the table to a new file geodatabase and create a view on the new FGDB table. Now, I can add the view in the new FGDB to the map without issue. Bud_3-1674058631410.png But I don't know why copying the table to a new FGDB fixes the issue. Related: https://community.esri.com/t5/arcgis-pro-ideas/sql-syntax-in-fgdb-api-should-be-supported-in/idc-p/1248551/highlight/true#M22862
... View more
01-18-2023
08:25 AM
|
0
|
1
|
1263
|
|
IDEA
|
Thanks @KoryKramer. As far as I can tell, after populating a cell, I need to hit enter three times in order to create & enter the next row/value. create new rows using keyboard.gif To me, hitting enter three times seems slightly excessive. I think in ArcMap it was easier -- just hit the down key and start typing.
... View more
01-18-2023
07:17 AM
|
0
|
0
|
1448
|
|
IDEA
|
Merged from a separate idea. I want to track all dependencies my organization has on a given FC — via a list of dependencies in the FC metadata. For example, track these columns in a "table"/grid in a section in the metadata: Dependency Name Date (automatically populated) Entered By (automatically populated) In this case, I consider a "dependency" to be something that is hardcoded to domain values in a column of the FC. Examples of dependencies include: ArcGIS Pro maps: definition queries, symbology, labels, display queries, other? Web Maps: AGOL and Portal; Field Maps app Integrations and data translation tables Database views and .SQL files Layer files Names of GIS initiatives that are built on the FC ODBC queries in MS Access and Excel More Use Case: A stakeholder requested the following: “In layer x, can we split TYPE=CROSSWALK into two separate domain values: CROSSWALK and TRAIL CROSSING OVER ROAD?” My answer was essentially: “No, there are too many dependencies (known and unknown).” All existing references to CROSSWALK would need to be updated/split out into CROSSWALK and TRAIL CROSSING OVER ROAD. That would be too difficult to implement. Unfortunately, we've created an unmaintainable monster of dependencies. So we can't justify the work involved to make the change at this time. With that said, it doesn't need to be that way. If we had a centralized list of dependencies that users could easily find and update, then we wouldn't be in this predicament. We'd be able to refer to the dependency list and update all hardcoded mechanisms as needed, reducing risk and making the request more manageable.
... View more
01-18-2023
06:59 AM
|
0
|
5
|
2626
|
|
IDEA
|
I wonder if you could do something similar to what you want by creating a flag column, populate the flag column, then disallow edits to rows that are flagged -- via an attribute rule. (Although, I'm not sure how you would subsequently un-flag the row afterwards, since the row would be un-editable.) But I assume the attribute rule would throw an error if your "automated edits" tried to edit those rows. Whereas it sounds like you want your automated edits to ignore the locked rows, not error-out. Is that right? Can you elaborate on your "automated edits"? Hopefully someone with more experience with Attribute Rules can provide some insight. @JohannesLindner might find this interesting.
... View more
01-17-2023
08:06 PM
|
0
|
0
|
1038
|
|
IDEA
|
ArcGIS Pro 3.0.3 file geodatabase standalone table: I've created a new row by clicking the "Click to add new row" pseudo-row. Bud_0-1674013279031.png I've entered the number 4 using the keyboard. Bud_0-1674012355745.png Now, I want to create an additional row by hitting the down arrow key. Bud_1-1674012542448.png But when I hit enter or the down key, the only thing that happens is the "Click to add new row" pseudo-row gets highlighted. I can't proceed to create a new row using the keyboard; typing has no effect. Could that behavior be changed so that hitting the down key after creating a new row automatically creates a new row? (highlighting the cell in that same column) Like this: Bud_2-1674012681142.png Additionally, clicking or double-clicking "Click to add new row" has inconsistent results. Sometimes, clicking or double-clicking that pseudo-row works as expected: the row becomes editable with the cell value selected. But other times, clicking or double-clicking that row has no effect. The user needs to smash the mouse a few times to make the row editable, which is a frustrating experience. Could that behavior be improved as well?
... View more
01-17-2023
07:39 PM
|
3
|
3
|
1856
|
|
IDEA
|
ArcGIS 3.0.3 file geodatabase or mobile geodatabase When creating a view in a geodatabase using the Create Database View tool: We can't paste text into the View Definition textbox using the right-click menu. We can only paste text using CTRL+V. Right-click menu: Bud_0-1674011121892.png CTRL+V: Bud_1-1674011280301.png Sample text for copying: select * from table_a a inner join table_b b on a.id_a = b.id_b Could that behavior be changed so that pasting using the right-click menu works too? Thanks.
... View more
01-17-2023
07:08 PM
|
0
|
1
|
1056
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 03-20-2026 02:12 PM | |
| 1 | 03-19-2026 11:42 AM | |
| 1 | 06-03-2026 04:02 AM | |
| 1 | 03-18-2026 07:08 PM | |
| 2 | 07-08-2026 01:29 PM |