Latest Contributions by Bud

I was playing around with default values in a integer column in a hosted feature layer. 1+1 worked as a default value: { "fields": [ { "name" : "MyID6", "type" : "esriFieldTypeInteger", "alias" : "My ID 6", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : "1+1" } ] }   But when I tried OBJECTID+1, I got an error message: { "fields": [ { "name" : "MyID7", "type" : "esriFieldTypeInteger", "alias" : "My ID 7", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : "OBJECTID+1" } ] } The name \"OBJECTID\" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted. I googled the second sentence of that error message, and it appears to be a SQL Server message.  This message is a specific SQL Server error (Msg 128) that occurs when you attempt to use a column name in a database context where it is not allowed, such as within a DEFAULT constraint or during a data insertion where string quotes are missing. Using Columns in Default Constraints: You cannot set a column's DEFAULT value to equal the value of another column in the same table. https://share.google/aimode/tmot43yg8Iehd54KU  So I guess that's more evidence that we're dealing with SQL Server? Additionally, I've seen some JSON examples online that have "defaultValue": "GetDate() WITH VALUES".  GetDate() appears to be a SQL Server thing too. ... View more

Would someone with DBA privileges in an on-prem Portal datastore database be able to poke around in a table to see if there are any database sequences used that would also be available in AGOL? (This is more of an “out of curiosity” thing to see if we can learn anything interesting, not necessarily something that should be done in a mission-critical AGOL feature layer without testing.) ... View more

Idea: Expression field in advanced AGOL view without join ... View more

Based on comments in Support for Attribute rules in ArcGIS Online: @Allison_Hockey  @IvanKozoletov1  @PaulBarr  @RichardLittlefield  @KevinMayall  @CalvinHarmin  @LeviCecil might find this post interesting.   You might also like Expression field in view using AGOL UI.   Also: Since you mentioned Survey123 if you are using Connect, there is uuid() function you can use to populate a unique id https://community.esri.com/t5/arcgis-online-questions/auto-populate-unique-id-field-in-hosted-feature/m-p/1698270/highlight/true#M68512  And Understanding Relationship Classes in ArcGIS Online Hosted Feature Services ... View more

For anyone who’s interested, it sounds like we can add calculated expression fields to “advanced views” in AGOL via the Admin REST API. The view would be uneditable. And this only seems to work for views with joins. Add to Definition (Feature Service) "sourceLayerFields": [ { "name": "zipcode", "source": "zipcode" }, { "name": "salesavg", "alias": "SaleAveragePerCustomer", "expression": "(Total_Sales_FY13 + Total_Sales_FY14) / Customers", "type": "esriFieldTypeDouble" } ] Abdillahi Hassan shows it in a video on LinkedIn: https://www.linkedin.com/posts/abdillahi-hassan-56a020134_esri-arcgis-ugcPost-7360636518803152896-NnkQ/  That’s not the same as attribute rules. But is related. Ideas: Expression field in view using AGOL UI Expression field in advanced AGOL view without join ... View more

[Esri, please delete this comment too.] ... View more

[Esri, please delete this comment too.] ... View more

@MobiusSnake  You mentioned T-SQL. Is the AGOL database SQL Server? I assumed it was PostgreSQL. But not my area of expertise. ... View more

@MobiusSnake This really helped me. Thanks. Any idea where we can find documentation on NEWID() ? ... View more

Would a EGDB constraint attribute rule error message be passed to the Portal ExB Editor widget? ... View more

BUG-000184633: Edit widget in ArcGIS Experience builder does not copy attachments when using the copy/past feature and does not allow you to add attachments until creating the point. BUG-000184633 has been marked as a duplicate of ENH-000170575 (In Product Plan). ... View more

BUG-000184633: Edit widget in ArcGIS Experience builder does not copy attachments when using the copy/past feature and does not allow you to add attachments until creating the point. BUG-000184633 has been marked as a duplicate of ENH-000170575 (In Product Plan). ... View more

BUG-000184634: Pressing the “Windows + :” shortcut does not insert symbols into text fields within the ArcGIS Pro attribute table. ... View more