Latest Contributions by DonSjoboen

‎12-06-2023

You can write your SQL statement (in the SELECT line) to include the following... SELECT ISNULL(CAST(ROW_NUMBER() OVER ( ORDER BY (SELECT NULL) ) AS int), -1) AS vwObjectID [you can call the OID whatever you like] what this SQL statement does is use the databases Row Number function, Is Null function and Cast to assign a unique/not null integer row value for each record in the view. Hope this helps!?

‎10-31-2023

Glad it worked out for you. I amended my previous reply and added the correct description/reason for the ISNULL replacement_value part of the function, along with SQL Server documentation.

‎10-12-2023

Your ROW_NUMBER function is missing one key thing... that is the ISNULL () function needs to be added in front of ROW_NUMBER. SELECT ISNULL(CAST(ROW_NUMBER() OVER ( ORDER BY [field] ) AS int), replacement_value --this value can be 0, since it is highly unlikely that your ID will return a Not NULL value since you are using the ROW_NUMBER function--) AS [ID] Correction to my previous comment about the ISNULL replacement value: the replacement_value for the ISNULL function returns the given value if the expression returns a NULL value. ISNULL (Transact-SQL) - SQL Server | Microsoft Learn You should NOT include OBJECTID from the parent table in your views (see article below). That is why you are seeing the ESRI_OID in Pro when using "Query Layer". Esri needs a unique integer value that is not null. https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-sql-server/views-in-geodatabase.htm

‎07-12-2023

Some GP tools require a service be stopped prior to running them. Can those GP tools be run using python to avoid stopping map or feature services?

‎04-05-2023

@DominicRoberge2 any updates on whether the bug was fixed? I'm having the same issue in the form in the new map viewer.

‎04-03-2023

I ended up solving the issue I was having. When creating the AGO hosted feature layer, I ended up setting the Facility ID field to be not editable. Even though I could control the editing permissions of the form itself, because I still had the field in the table set to not edit, that prevented the form calculation from happening.

‎04-03-2023

Using the updated line of code (below)... I get the following error message; var OtherCB = FeatureSetByName($map, "Other Govt and City Owned Catch Basins", ['FACILITYID'], true) var CBinspected = Intersects($feature, OtherCB) Console(CBinspected) if (!IsEmpty(CBinspected)) { return CBinspected['FACILITYID'] } else { return null } The idea is to write the facility id of an existing catch basin to the new inspection on that catch basin (i.e., hosted feature layer) using a calculated expr in a form in the web map. I'm wondering if I need to (somehow) add the GlobalID of the hosted feature layer in my expression? Or if there's something else at play here? Hoping someone has experience with adding an attribute value from one feature to another when adding a new point in a web map/app.

‎04-03-2023

When I add the !, I don't get [object Object], but I do get an error stating the calculation failed. So, there is something else going on that is causing this to fail.

‎03-31-2023

Thanks, but I have tried that and I get this error... I've also used Console() and it too gave me nothing in the console menu. Just Null in the output. I'm using a blank hosted feature layer to add new inspections on existing catch basins feature layer. I have editing disabled for that field I want to populate too. Wonder if there isn't something else going on. I'm using the first example from this blog as a starting point... https://www.esri.com/arcgis-blog/products/field-maps/field-mobility/common-calculated-expressions-for-arcgis-field-maps/

‎03-31-2023

Hello, I'm trying to add an attribute [FACILITYID] from another feature in my web map form. I have added a form field for this (see above) and have created a calculated arcade expression that seems to work. However, when I test this expression by creating a new point (hosted feature layer), the field just shows [object Object] and not the desired value from the other feature layer. Hoping someone can help with this? @XanderBakker

‎01-04-2021

@XanderBakker Is it possible to symbolize (in Pro) a layer using an Arcade expression with a 1:M related view table? Here's one of the Arcade expressions I am using for the layer's pop-up configuration (in Pro) to show the related customer and their assigned device (i.e. can type)... Hoping I can use/modify this expression to create symbology based on whether a customer has a device or no device (i.e. Gray for none assigned and green for device assigned). Thanks, Don

‎08-20-2020

Kelly Gerrow‌ Would you be able to answer my question (above) about HTTPS switch on AGO? Thanks, -Don

‎08-14-2020

I'm hoping to get some clarification around the AGO switch from HTTP to HTTPS. In particular, the reference (see link) to the Esri Support Services FAQ: What do I need to know about HTTPS Only and the ArcGIS Platform? I would like some clarification around how this switch will affect web map popups that are on AGO. An excerpt from the link (above) is copied below for context. Our organization has links to other websites (within our organization and outside our organization) that don't use HTTPS. My question is, will those other websites (hyperlinks) need to be converted to HTTPS in order to work? 4. Any items added to ArcGIS Online from links external to the ArcGIS platform with HTTP only URLs will be inaccessible via a browser due to mixed-content conflicts. This includes: links in the item details popups, etc. How I interpret the excerpt (above), is that anything that is added as an item (or hosted) on AGO will only be affected, not 3rd party websites (hyperlinks). Is that correct? -Don

‎06-24-2020

Xander Bakker‌ You are correct, I still get the error and the count results are still the same...

‎06-24-2020

Xander Bakker‌ Using the following seemed to work better, as I could see the message returned from the Console('sql: ' + sql);

Online Status	Offline
Date Last Visited	‎12-06-2023 07:54 PM

My Ideas

Latest Contributions by DonSjoboen

Re: Will registering a view with an enterprise geodatabase improve performance?

Re: Adding a Unique ID/ OBJECTID to a SQL Query Layer that uses GroupBy

Re: Adding a Unique ID/ OBJECTID to a SQL Query Layer that uses GroupBy

Bypass locked map/feature services using python

Re: Arcade Generate new Unique ID for new record but not updating existing UID

Re: Calculated Value

Re: Calculated Value

Re: Calculated Value

Re: Calculated Value

Calculated Value

Arcade expression for Symbology using a field in a view table

Re: HTTP to HTTPS

HTTP to HTTPS

Re: Use Distinct in Arcade Expression to return unique rows from table

Re: Use Distinct in Arcade Expression to return unique rows from table

Re: Adding a Unique ID/ OBJECTID to a SQL Query La...

Bypass locked map/feature services using python

Arcade expression for Symbology using a field in a...

Re: Use Distinct in Arcade Expression to return un...