View Layer in ArcGIS Rest Service

Discussion created by aht4321 on Apr 7, 2014
Latest reply on Aug 12, 2014 by mminami-esristaff
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