nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Can a hosted feature layer view exclude related tables

Trippetoe

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

Find more posts tagged with

Accepted answers

Trippetoe

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.

All comments

MarkBennett

Hi Hassen,

I read your replays to this post and "add related table" post using "addToDefinition". Can the same rest api be used to remove(hide) feature layers and/or tables in a AGOL hosted feature layer? I have a feature layer service containing many layers and relation tables. I created layer views for deferent maps or apps that only uses a few layers and table in that feature layer service.

Thanks,

Ming

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.

KhaledHassen

Yes pl. work with Tech support so they can provide me with a repro case and I will take a look and work toward fixing this issue. Until then pl. create view with only the layer you need to avoid having to delete the layers after creating the view.

KhaledHassen

You should be able to do this now. Just drop the layer or related layer you do not want in the view. This should not affect the source feature service or layers.

EmilyRayner_0-1632104502753.png

jvenables_0-1632104712473.png

Anonymous User

Has there been any updates on disabling related tables from a feature layer view?

Anonymous User

Thanks again, working as expected.

Gee

KhaledHassen

We are planning online 6.2 release in the next couple of weeks in June.

Anonymous User

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

Trippetoe

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

Anonymous User

Has anyone heard any updates on this?

Thanks,

Gee

Trippetoe

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?

KhaledHassen

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.

Trippetoe

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.

KhaledHassen

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.

Trippetoe

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,
}
],
...
}

KhaledHassen

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

Trippetoe

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

KhaledHassen

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

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.