POST
|
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!?
... View more
12-06-2023
07:52 AM
|
0
|
0
|
1092
|
POST
|
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.
... View more
10-31-2023
08:11 AM
|
0
|
0
|
2597
|
POST
|
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
... View more
10-12-2023
11:22 AM
|
1
|
2
|
2750
|
POST
|
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?
... View more
07-12-2023
02:02 PM
|
2
|
0
|
448
|
POST
|
@DominicRoberge2 any updates on whether the bug was fixed? I'm having the same issue in the form in the new map viewer.
... View more
04-05-2023
12:33 PM
|
0
|
4
|
2917
|
POST
|
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.
... View more
04-03-2023
12:16 PM
|
0
|
0
|
820
|
POST
|
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.
... View more
04-03-2023
12:00 PM
|
0
|
1
|
820
|
POST
|
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.
... View more
04-03-2023
07:08 AM
|
0
|
0
|
830
|
POST
|
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/
... View more
03-31-2023
03:37 PM
|
0
|
0
|
863
|
POST
|
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
... View more
03-31-2023
02:58 PM
|
0
|
6
|
894
|
POST
|
@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
... View more
01-04-2021
11:30 AM
|
1
|
1
|
656
|
POST
|
Kelly Gerrow Would you be able to answer my question (above) about HTTPS switch on AGO? Thanks, -Don
... View more
08-20-2020
10:44 AM
|
0
|
0
|
285
|
POST
|
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
... View more
08-14-2020
12:08 PM
|
0
|
1
|
345
|
POST
|
Xander Bakker You are correct, I still get the error and the count results are still the same...
... View more
06-24-2020
04:05 PM
|
1
|
0
|
5852
|
POST
|
Xander Bakker Using the following seemed to work better, as I could see the message returned from the Console('sql: ' + sql);
... View more
06-24-2020
02:59 PM
|
0
|
0
|
5852
|
Title | Kudos | Posted |
---|---|---|
1 | 10-12-2023 11:22 AM | |
2 | 07-12-2023 02:02 PM | |
1 | 01-04-2021 11:30 AM | |
1 | 06-24-2020 04:05 PM |
Online Status |
Offline
|
Date Last Visited |
8 hours ago
|