POST
|
@JustinReynolds , Just wanted to let you know that Esri has fixed this issue: Updates have been made to the following defect which you are associated with: BUG-000157546 - Querying a feature in the ArcGIS Field Maps mobile app fails if there is an apostrophe in the attribute data of the feature called by an Arcade expression. Status: Fixed (Learn More) Version Fixed: 23.3.0 Alternate Solution: Remove the apostrophes from the features and do not use the Arcade expression since querying works. Regards, Frank
... View more
10-11-2023
07:30 AM
|
1
|
1
|
670
|
BLOG
|
Hi @IsmaelChivite , I'm having trouble with the constraint message for the geopoint location in a point in polygon verification using multiple languages. The constraint messages for other types are working correctly with multiple languages. I'm using Survey123 Connect version 3.18.124. My XLSForm is configured as shown below: I tested just using with just using a "constraint_message" column for the geopoint and the the message appeared correctly for a constraint vilolation. It appears that the constraint_message with a language designation is not working for the a geopoint type constraint. Am I missing something? Regards, Frank
... View more
10-11-2023
07:22 AM
|
0
|
0
|
21068
|
POST
|
Yes. I have submitted a case for this issue. In the meantime, I'll try your approach to create a workaround until this gets addressed. Thanks so much for you insights. I'll post any resolution that I receive from Esri. Regards, Frank Martin
... View more
02-07-2023
07:53 AM
|
2
|
2
|
843
|
POST
|
Yes, I agree. I think it's a bug. Here is the log from the Field Maps application. This function is being used in expression to retrieve attributes from a specific feature to prepopulate attributes in an inspection report (related table). You can see that the apostrophe is not escaped in the where clause. FYI, I replaced some of the information with xxxx for security. Name: expr/park-or-preserve-name Error: Error Domain=com.esri.arcgis.runtime.services.error Code=500 "Syntax error [(1=1) AND (caves = 'Pricilla's Well Cave')]." UserInfo={NSURL=https://xxxxx.xxx/maps/rest/services/Hosted/Parks_xxxxx_Caves/FeatureServer/0/query?outSR=3857&returnGeometry=true&returnZ=true&where=%281%3D1%29%20AND%20%28caves%20%3D%20'Pricilla's%20Well%20Cave'%29&outFields=%2A&returnDistinctValues=false&resultRecordCount=1&f=json&returnM=true, responseJSON={ error = { code = 500; details = ( ); message = "Syntax error [(1=1) AND (caves = 'Pricilla's Well Cave')]."; }; }, AGSCredentialErrorKey=username: xxxxxx token: GH_VLtRuJDZjSejMCR4klNuXZw_K4UU98HqJ-H-7QzPeMv8p6_D7bNwIXUhuYrSwNckjMkl89iAehiTGe4Xpm-ySRQkHxm30a7z9pgMJtwQrHM2sIVZYl2YaeegJeb4c_ziJMSc42nevHo4Au599YVlLXrwnFUo0DGqiWJO0w6WNnfK_g_0X4gApSOc7dIyDJtut0jJDpDY2LMT6q6HzVMHZAE5giYaZe8VJlCz1dMnIH9N-H3BMmkxdojv6Jy3I8hiVer58Y1JqOyyz0HdzAH7Qg5r7Nwkk5qjj_acxQdQ. tokenURL: xxxxxxxx tokenExpiration: 2023-02-03 23:24:10 +0000 , NSLocalizedDescription=Syntax error [(1=1) AND (caves = 'Pricilla's Well Cave')].}
... View more
02-07-2023
07:11 AM
|
0
|
4
|
854
|
POST
|
Thanks @JustinReynolds, Since this function uses the feature which is immutable as an argument, i don't think the value can be changed. I can see in the Field Maps log that the query fails because the apostrophe isn't escaped. Since the apostrophe is a legal character, I was hoping that the Arcade function, FeatureSetByRelationshipName, would account for this since it uses a string to match the feature. Thanks again for your idea.
... View more
02-03-2023
01:57 PM
|
0
|
6
|
861
|
POST
|
We have data that includes values that contain apostrophes. When using the Arcade FeatureSetByRelationshipName function is fails because the sql query where clause that is created is structured like this: name = 'Billy Bob's Cavern' The single apostrophe in the value needs to be escaped by a second apostrophe to be an expectable where clause: name = 'Billy Bob''s Cavern' Can the FeatureSetByRelationshipName be updated to account for this situation? Is there another way to handle this short of changing the value to remove the apostrophe?
... View more
01-27-2023
11:59 AM
|
0
|
8
|
1015
|
BLOG
|
@Anonymous User , I have question with regard to fetching an attribute from a related record using the FeatureSetByRelationshipName. I'm not sure where to to find the relationshipName. In Arcade, there is a "Related Records" chevron for the $feature that shows the folowing: FeatureSetByRelationshipName($feature,"gisedit.GIS.parks_tree_inventory"). This relationship (feature, table) was created in an SDE enterprise geodatabase, published to an ArcGIS Server, and the added to AGOL as a feature layer. The line within the Arcade expression, FeatureSetByRelationshipName($feature,"wgisedit.GIS.parks_tree_inventory",['Location'], false);, does not fail, but in the field maps application there is an error "Failed to evaluate". Is this the correct relationshipName? Does the function work with this type of relationship? Thanks, Frank
... View more
05-27-2022
10:26 AM
|
1
|
0
|
1332
|
BLOG
|
@Anonymous User , Thanks for the update. I'm looking forward to using this functionality in our Enterprise applications. Wish it was sooner. 🙂
... View more
05-19-2022
12:20 PM
|
0
|
0
|
1403
|
BLOG
|
Are these calculated expressions available in Enterprise 10.9.1? If not, is there a timeline for updating Enterprise to include this functionality? Thanks, Frank
... View more
05-19-2022
12:05 PM
|
0
|
0
|
1420
|
BLOG
|
Hi @JeffShaner When will the March 2022 release be available for ArcGIS Enterprise? For example, the GetUser function doesn't seem to be available in the Enterprise Field Maps Arcade expression editor. Thanks, Frank
... View more
04-08-2022
09:17 AM
|
2
|
0
|
1505
|
POST
|
I've been trying to implement attaching multiple Survey123 file attachments (pdf, xlsx, docx) using the Survey123 Tricks of the Trade: Working with attachments in Microsoft Power Automate posted by @IsmaelChivite. I'm able to Append to array from the HTTP content using the base64ToBinary (body('HTTP').$content) expression and the feature attachments name. However, when the email is received, the attachments are unreadable. This conversion doesn't seem to work for file attachments. The blog post was based on photo image, so I wondering if the same content expression above is suitable for file attachments. I've tried just using body('HTTP').$content as the expression, but this doesn't seem to work either. Are Survey123 file attachments stored as a different filetype? Do they need to be converted to something other than Binary? Any help would be greatly appreciated Example of the issue when opening the attachment: Thanks, Frank
... View more
08-31-2021
12:15 PM
|
4
|
1
|
446
|
BLOG
|
Does anyone know if this base64ToBinary (body('HTTP').$content) works with other attachment types such as pdf, docx, or xlsx formats? Are all attachment stored in the same format ( base64) as the photo? This command for accessing the content doesn't work for me when try to attach other media types. Thanks, Frank
... View more
08-26-2021
11:34 AM
|
2
|
0
|
15930
|
BLOG
|
@JamesChan1 , Could you fill me in on your user error. I seem to be having the same issue in attaching files such as excel and pdf files. Wonder if I making the same mistake. 🙂 Thanks, Frank
... View more
08-13-2021
01:57 PM
|
0
|
0
|
16338
|
POST
|
We've switched to using Azure AD authentication for ArcGIS Online. For guest users (not in organization), Azure AD creates a username (User principal name) that includes special characters (#'s), ex. somebody.somewhere.org#EXT#@acme365.onmicrosoft.com. This username cannot be use for the SAML ID when adding a member to ArcGIS Online. See image below. Has anyone seen this problem before, and is there a solution? Thanks, Frank
... View more
06-30-2021
11:23 AM
|
0
|
3
|
2649
|
POST
|
I just wonder if anyone had found an answer to this issue. I have the same problem with Flows that I previously created that now do not show the dynamic content.
... View more
04-23-2021
07:12 AM
|
0
|
0
|
14601
|
Title | Kudos | Posted |
---|---|---|
1 | 10-11-2023 07:30 AM | |
1 | 05-27-2022 10:26 AM | |
2 | 02-07-2023 07:53 AM | |
2 | 04-08-2022 09:17 AM | |
1 | 09-23-2020 02:01 PM |
Online Status |
Offline
|
Date Last Visited |
2 weeks ago
|