topic Re: Can a hosted feature layer view exclude related tables in ArcGIS Online Questions

Can a hosted feature layer view exclude related tables

Trippetoe — Fri, 19 Jan 2018 21:28:10 GMT

Hello.

We have a private hosted feature layer that has 3 related tables. We want to make some of the 'spatial' data available to the public, but we don't want any of the related data visible to the public.

Is there a way to create a hosted feature layer view that excludes the related tables? I tried not including the join field in the list of fields for the view, but related tables and their data are still present in the view.

thank you

Re: Can a hosted feature layer view exclude related tables

KhaledHassen — Mon, 22 Jan 2018 20:15:13 GMT

Yes you can exclude the related tables from the view and this has nothing to do with the join field. The UX clones the source and create a view with all layers. But you can drop the related table by using the deleteFromDefinition API on the feature service view.

Admin API can only be used by the admin or the owner of the feature service view.

http://serviceUrl/rest/admin/services/myViewName/FeatureServer/deleteFromDefinition

You can pass the following json:

{"layers" : [

{

"id" : <relatedTableId1>

{

"id" : <relatedTableId2>

} ]

}

Pl. let us know if you have any issue with the above.

Khaled

Re: Can a hosted feature layer view exclude related tables

Trippetoe — Mon, 22 Jan 2018 21:01:02 GMT

In the source\origin layer definition do i need to drop the 'relationships' element?

Re: Can a hosted feature layer view exclude related tables

KhaledHassen — Mon, 22 Jan 2018 21:06:58 GMT

No. Nothing needs to be done in the source. You just need to drop the related tables from the view and this would remove the relationships from the view also.

Pl. note deleting these layers from the source would delete the related tables permanently and also this would delete all the source data.

Khaled

Re: Can a hosted feature layer view exclude related tables

Trippetoe — Mon, 22 Jan 2018 21:13:44 GMT

I think i confused the issues. I apologize for that.

Within my view, the 'main' layer, id=0, has a json element named 'relationships' which references the 3 related tables that i want to drop from the view. Do i need to remove that element (relationships) from the view definition as well?

{
"layers" : [

"id" : 0
...
"relationships" : [
{
"id" : 0,
"name" : "",
"relatedTableId" : 3,
},
{
"id" : 1,
"name" : "",
"relatedTableId" : 2,
},
{
"id" : 2,
"name" : "",
"relatedTableId" : 1,
}
],
...
}

Re: Can a hosted feature layer view exclude related tables

KhaledHassen — Mon, 22 Jan 2018 21:19:23 GMT

No. Deleting the related table should take care of deleting the relationships between that table and the view layer. Once you delete all related tables in the view, you should see no relationships in the view layer.

Re: Can a hosted feature layer view exclude related tables

Trippetoe — Tue, 23 Jan 2018 20:03:17 GMT

It turns out that the 'relationships' element is not removed from the view layer json. I discovered this because our maps which use the hosted feature layer of the view started reporting an error about missing table id=3. And "3" was the id of one of the related tables. When i went back to review the hosted feature services json, this is still there:

"layers" : [
{
...
"id" : 0,
...
"relationships" : [
{
"id" : 0,
"name" : "",
"relatedTableId" : 3,
...
},
{
"id" : 1,
"name" : "",
"relatedTableId" : 2,
...
},
{
"id" : 2,
"name" : "",
"relatedTableId" : 1,
...
}
]
}

There is also a relationships element in the json of the hosted feature service's layer, i.e. <servicename>/0

How can i remove the relationships element from the service definition?

thank you

Re: Can a hosted feature layer view exclude related tables

KhaledHassen — Tue, 23 Jan 2018 20:16:21 GMT

We do not support deleting the relationships directly. We are supposed to delete the relationships when deleting the layer. What is the status of the view service now. Have been able to delete all tables you do not need in the view? Is it possible you have an order issue when deleting. You are supposed to delete the destination table that is not a source of a relationship first.

Re: Can a hosted feature layer view exclude related tables

Trippetoe — Tue, 23 Jan 2018 21:16:52 GMT

I have deleted all the related tables that i do not need in the view. I deleted the 3 related tables from the view first.

I can make the view available to you if you'd like to look at it.

Since it's a view, i can also start all over just to make sure that i followed the correct procedure.

Let me know what you'd like me to try, or if there is any additional information you'd like. I can also re-open the support ticket i had opened for this question as well.

Re: Can a hosted feature layer view exclude related tables

KhaledHassen — Tue, 23 Jan 2018 21:31:10 GMT

Sure pl. recreate the view and share it with me. I can take a look and maybe send you the json you need to use.

Re: Can a hosted feature layer view exclude related tables

Trippetoe — Tue, 23 Jan 2018 22:13:28 GMT

I have re-created the view; it contains the three related tables. Do you have an email address or some other way that i can contact you directly so i can give you access to the view?

Re: Can a hosted feature layer view exclude related tables

KhaledHassen — Tue, 23 Jan 2018 22:16:43 GMT

khassen@esri.com

Re: Can a hosted feature layer view exclude related tables

Trippetoe — Fri, 26 Jan 2018 16:55:06 GMT

As a quick update, after some additional investigation, Esri staff has confirmed that using the 'deleteFromDefinition' method does not successfully remove related tables from a hosted feature layer view. They are working on debugging the problem and hopefully a worked around until the bug is fixed.

Re: Can a hosted feature layer view exclude related tables

Anonymous User — Thu, 05 Apr 2018 22:23:55 GMT

Has anyone heard any updates on this?

Thanks,

Gee

Re: Can a hosted feature layer view exclude related tables

Trippetoe — Thu, 05 Apr 2018 23:08:25 GMT

This is the response i got from khassen10 from Esri. the process worked for me.

Hi Tom,

I have looked/debugged this issue. The following workaround works for me in my dev env.
For deleting a table, you will need to delete the relationship first, then delete the related table. Not sure if you have tried this.

For instance to delete related table with Id = 2.
Use http://.../ArcGIS/rest/admin/services/exporttestingView/FeatureServer/2/deleteFromDefinition
Pass the following json to delete the relationship between table Id=2 and layer Id = 0
{
"relationships" : [
    {
      "id" : 1,
      "name" : "Test_Table_2",
      "relatedTableId" : 0,
      "cardinality" : "esriRelCardinalityOneToMany",
      "role" : "esriRelRoleDestination",
      "keyField" : "CaseNumber",
      "composite" : false
    }
]}

Use service deleteFromDefinition to delete table with Id=2
Use http://.../ArcGIS/rest/admin/services/exporttestingView/FeatureServer/deleteFromDefinition
Pass the following json to delete the table with Id=2
{
"layers" : [
    {
      "id" : 2
    }
]}

Pl. try this out and let me know if you still see the issue.

Thanks

Re: Can a hosted feature layer view exclude related tables

Anonymous User — Fri, 20 Apr 2018 11:24:56 GMT

Thanks Tom Rippetoe‌ and Khaled Hassen,

Do you know if there a is a workaround for deleting attachments from a feature layer view?

Thanks,

Gee

Re: Can a hosted feature layer view exclude related tables

KhaledHassen — Fri, 20 Apr 2018 14:40:56 GMT

Currently the attachments can only be disabled from the source and that would propagate to all views.

So the short answer is not currently supported. But I will add this as a future enhancement (maybe June online release).

Re: Can a hosted feature layer view exclude related tables

Anonymous User — Sat, 21 Apr 2018 04:14:58 GMT

Thanks KHassen-esristaff‌

This feature would be so helpful for our team.

Thanks again,

Gee

Re: Can a hosted feature layer view exclude related tables

Anonymous User — Thu, 17 May 2018 01:16:09 GMT

Hi Khaled Hassen‌

Is this still on track for the June online release?

Thanks,

Gee

Re: Can a hosted feature layer view exclude related tables

KhaledHassen — Thu, 17 May 2018 01:19:50 GMT

Most likely, Will update you shortly. It is still in development.