Latest Contributions by Trippetoe

I'll open up a tech support case and get back to you with the number. Unfortunately the view is based on a hosted feature service that contains three related tables.  I am not certain of how to create the view in a way that does not automatically contain the related tables. If such a thing is possible, please let me know.  Thank you. ... View more

Hi khaled hassan‌. I tried the 'DeleteFromDefinition' approach as suggested by you, i.e. dropping the three related tables from the service definition.  Indeed the three related tables were dropped from the View.  However, there have been some very 'interesting' side effects from doing that. 1) When on the service's Item Details > Visualization tab of the View, i am unable to configure the pop-up because there are no fields listed in any of the inputs of the Configure Pop-up dialog: 2) When executing a query from the WAB Query widget, no results are returned - and there is some additional odd behavior - and by that i mean that the query is executed against the layer ids of the related tables that were dropped. I know that probably doesn't make sense the way i typed it.  Here's a screen shot from the Chrome browser tools showing what i mean.  The app sends off requests against FeatureServer layers 1, 2, and 3 --- none of those layers exist.  The response for the queries is not unsurprising:   {"error":{"code":400,"message":"","details":["The requested layer (layerId: 1) was not found."]}} I have verified that if i create the View they way you had me do it before - drop the relationship from the layer then drop the layer from service - that i can configure the popup and i can execute a query against the View as expected. If it's time to move this to a new thread or submit an Tech Support request, please let me know. Thank you. ... View more

Hey Shana. Alas, I have not yet found a way to create a 'performance' index on an attribute field in AGOL (doesn't mean there isnt one though  ).  Let me know if you do find a way. I was feeling lucky just to get a unique index.  I wonder if an index you created on the local feature layer (before posting to AGOL) would be respected when you published to AGOL or not. I suspect not.... Good luck, Tom ... View more

Hi Shana.   You can add a unique constraint on an attribute field.  Here's the right link: Add a unique constraint to a field—ArcGIS Online Help | ArcGIS  ... View more

Hi Philip. thank you for following up.  The issue is no longer relevant to our workflow, so i won't be able to test on our production survey. but when the chance comes up for any new surveys, i'll give it a go and let you know how it works out. ... View more

Hi Kelly Gerrow‌ After your earlier clues, i tracked down the 'queryAttachments' REST endpoint.  That shows some promise but i am running into some unexpected behavior.  If i execute a query with the following parameter value: Definition Expression: 1=1 I get the expect results - info about the attachments for all features with attachments. An abbreviated version of the response looks like this: {       "parentObjectId" : 15,        "parentGlobalId" : "7432c245-6fd8-413a-b2d2-1d43a3dd15cf",               "attachmentInfos" : [         {           "id" : 1025,            "globalId" : "ee2e72a7-11b0-4310-af6b-212cd9a4efcd",            "name" : "Photo2.jpg",            "contentType" : "image/jpeg",            "size" : 660136,            "keywords" : ""         }, If i change the parameters to include 'Attachments Definition Expression' like below: Definition Expression: 1=1 Attachments Definition Expression: name='Photo2.jpg' I get an empty attachmentGroups element where i am expecting at least one record to be returned based on the previous response that shows 1 record with a name = Photo2.jpg. Instead, the response looks like this: {   "fields" : [     {       "name" : "OBJECTID",        "type" : "esriFieldTypeOID",        "alias" : "OBJECTID",        "sqlType" : "sqlTypeOther",        "domain" : null,        "defaultValue" : null     },      {       "name" : "GlobalID",        "type" : "esriFieldTypeGlobalID",        "alias" : "GlobalID",        "sqlType" : "sqlTypeOther",        "length" : 38,        "domain" : null,        "defaultValue" : null     }   ],    "attachmentGroups" : [] } In messing around with some of the other parameters like Size and Attachment Types, i see the expected behavior - only attachments that match the parameters are returned. Is the parameter 'Attachments Definition Expression' valid on the back end? If so, is there some special syntax i need to use? ** EDIT ** I played around a bit more and discovered that if i set the parameter Attachments Definition Expression: 1=1 i get the expected results, i.e. all attachments, and if i set the parameter like so Attachments Definition Expression: 1=2 i also get the expected results, i.e. no attachments returned.  So it seems like the parameter is valid, but i am not setting it correctly? ** END EDIT ** One more side question -- i see that there is an Attachment Info field 'keywords'; is there some place in AGOL where i can set\edit that value for each attachment? thanks again for your help. ... View more

Hi Kelly. I wasn't aware of the 'Attachment Info' endpoint. Thanks for pointing that out to me. I played around with the endpoint for a bit,  but as best as i can tell i don't get information about creation date or edit date (those fields were part of the Attach table of the file geodatabase that i published to agol).  Additionally, the Attachments endpoint works on a per feature basis.  I am trying to discover features (if any) had a new attachment added since some previous date, e.g. in the last 7 days.  Is there a way to do something like that......As an example, the SQL query would look something like SELECT features FROM featureclass INNER JOIN featureclass__ATTACH ON featureclass.GlobalId = featureclass__ATTACH.parentGlobalId WHERE featureclass__ATTACH.CreationDate > DATEADD(day,-7, GETDATE()) Thank you, Tom ... View more

Hi Kelly Gerrow‌ Initial testing this morning shows that the functionality is working as expected. Thank you for the quick fix. Tom ... View more

Excellent news. I am looking forward to checking it out on Monday morning. Thank you. ... View more

Thanks for looking into the issue. No UC for me; for better or worse i am a fairly strict Dev Summit only person. Our Org will definitely be represented at the UC though if you are interested in meeting some of our users. ... View more

Hi Kelly Gerrow‌ The functionality you described above does not seem to be working in the current version of AGOL.  I am the owner of a hosted feature layer with 'Keep track of who created and last updated features' enabled.  I have created a VIEW on that hosted feature layer, and in the 'Set View Definition > Define Fields' interface i have unchecked the 4 editor fields.   However, the four editor fields still show up, although unchecked, when i use the Data tab in the View's item details and in the popup on the view's features.  Any idea what is going on, or what else i need to try? We really don't want the editor/creator info displayed in the popup. Thank you. ... View more

Hi Derek Law Our development staff have created a pretty interesting/useful operations dashboard. When we took the dashboard to our supervisors for review/approval, the first thing each of the supervisors did was try to view the dashboard on their phones.  Our project has been delayed/canceled because the supervisors couldn't access the dashboard from their phones. One of the purposes of the dashboard is to have the public report issues and see their reports on the dashboard along with some other stats about the program. The supervisors reasoning is that the public will be submitting reports from their phone and will expect to see the dashboard from there as well. It turns out that mobile phone accessibility is a very critical piece to adoption within our agency. Thanks, Tom ... View more

Esri Tech Support has verified that this is a bug in AGOL.  The bug number is #BUG-000114175 ... View more