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; } } }

View Layer in ArcGIS Rest Service

AshakaThakore1

I have a point-featureclass - myfeatclass and a table -mytable ...
The relationship between myfeatclass and mytable is one-to-many.. i.e. for each point in myfeatclass, there are multiple rows in mytable...
I created a sde-view-layer - mysdeview using sdetable command by joining myfeatclass and mytable .. .

sdetable -o create_view -T mysdeview -t myfeatclass,mytable -c myfeatclass.col1,mytable.col1 -a featclass_col1,table_col1 -w myfeatclass.col1=mytable.col1(+) -i sde:Oracle11g -u myuser -p mypwd@myserver

I published mysdeview on arcgisserver.. I consume it in arcgisonline... When i click to identify those points, it only brings one record.. Since there are multiple rows in mytable for each point in myfeatclass, it should show multiple items in identifywindow... Can somebody help

thanks so much

Finde mehr Beiträge mit dem Tag

Accepted answers

All comments

DavidJenkins

Unfortunately it is not. As a company policy we do not publish externally. I'm probably going to open a support ticket and work directly with technical support. That way we could maybe share screens or something. I'll post any resolution we find here later.

MikeMinamiP1

David,

Is your service public? Can you share the URL to it so we can investigate the issue?

Thanks,

Mike

DavidJenkins

I am posting here because the original post is closest I could find to my problem.

I too have created a SQL view (with objectid and shape columns) with a goal of publishing it on my server and using ArcGIS Online, view the points and see the related information.

Using ArcMap, I added my view (recognized as a feature class) and related several tables to the view. All relationships are one-to-one (for now). I could not use a relationship class in the database because it's a view so I related it in my map document.

I published the service without any problem (MapServer not FeatureServer) and tested it by adding the service to an empty ArcMap document. I was able to successfully identify individual points of the service and see the related (1:1) information as expected. Now on to ArcGIS Online...

I am able to add the service and enable popups. I can identify the points and see the immediate data of the point. I click "Show Related Records" and it prompts me to choose which related table I would like to see the results for; so far so good. However, upon selecting one of the related tables, it generates the display table at the bottom of the map to show my results even though the header on the table indicates (1 feature, 0 selected), it populates the table with ALL of the related table's contents. It appears that ArcGIS Online thinks the relationship is one-to-many but it's not. It does not even select the one record that is related. At least if it did that, I could look the other way and work around it for the time.

I've tried this a couple of different ways including changing relationship identifier and such but I always get the same results. I think this is a bug.

AshakaThakore1

where can i check its status? Thanks so much

MikeMinamiP1

THe popup window in ArcGIS Online doesn't support related records currently. This is a project we're actively working on, but no release date set at this time.

Thanks,

Mike

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

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