topic Editing a related table -help- esri sample in ArcGIS API for Flex Questions

Editing a related table -help- esri sample

LizDaRos — Mon, 07 Nov 2011 12:24:33 GMT

Hi, I was wondering if anyone has used the sample from esri that allows you to edit a related table? I have the application setup and running using one of my own feature services but I need to add more fields from the related table to edit. This sample only allows you to make edits to the agree_with_incident field by clicking on an image. I'm not sure where I need to add in my others fields that I'd like to edit.
Any ideas would greatly be appreciated!

Re: Editing a related table -help- esri sample

LizDaRos — Wed, 09 Nov 2011 11:58:18 GMT

I've found some code that uses the same code as the attribute inspector sample to edit related tables. Here is the link-
access-a-relationship-query-through-Attribute-Inspector
I'm also using points instead of polygons so I've switched some on the code in the attribute inspector sample to select the points.
I think I am close to getting this working, I can see the related table information in the attribute inspector popup but it only shows for about half a second then disappears and another blank popup displays.
Attached is my code... can anyone see what the problem is?

Re: Editing a related table -help- esri sample

RobertScheitlin__GISP — Wed, 09 Nov 2011 12:51:29 GMT

Liz,

Your issue is that both the roomsLayer and the roomsTableLayer featurelayers are firing the tableSelect_selectionCompleteHandler function.

Re: Editing a related table -help- esri sample

LizDaRos — Wed, 09 Nov 2011 13:47:47 GMT

That was it, thank you very much Robert!
Now I just need to add a function that adds a new record to the related table. It looks like the code from the Editing a Related Table sample can do this. If that's the right direction then I'm trying to use this function in my application but not having much luck. Any suggestions?

   private function addImage_clickHandler(event:MouseEvent):void
   {
    const roomsTableLayer:Object = {
     object: selectedGraphic.attributes.objectid,
      datetime: new Date().getTime(),
      agree_with_incident: 1
    };
    const roomsTableLayer:Graphic = new Graphic(null, null, roomsTableLayerAttributes);

    const roomsTableLayer:FeatureLayer = new FeatureLayer("http://sampleserver3.arcgisonline.com/ArcGIS/rest/services/SanFrancisco/311Incidents/FeatureServer/1");
    roomsTableLayer.addEventListener(FeatureLayerEvent.EDITS_COMPLETE, roomsTableLayer_editsCompleteHandler);
    roomsTableLayer.applyEdits([ voteRecord ], null, null);
   }
   private function roomsTableLayer_editsCompleteHandler(event:FeatureLayerEvent):void
   {
    count++;
    peopleCount.text = count + " people think this is important";
   }

Re: Editing a related table -help- esri sample

RobertScheitlin__GISP — Sun, 12 Dec 2021 00:21:11 GMT

Liz,

You have several coding issue here:

private function addImage_clickHandler(event:MouseEvent):void
{
    const roomsTableLayer:Object = {
    object: selectedGraphic.attributes.objectid,
    datetime: new Date().getTime(),
    agree_with_incident: 1
    };

   //And here you are using the same constant name again, this is no good.
    const roomsTableLayer:Graphic = new Graphic(null, null, roomsTableLayerAttributes);

    //And here you are using the same constant name again, this is really no good.
    const roomsTableLayer:FeatureLayer = new FeatureLayer("http://sampleserver3.arcgisonline.com/ArcGIS/rest/services/SanFrancisco/311Incidents/FeatureServer/1");
    roomsTableLayer.addEventListener(FeatureLayerEvent.EDITS_COMPLETE, roomsTableLayer_editsCompleteHandler);
    //Now you are trying to apply voteRecord which does not exist in your code to the table
    roomsTableLayer.applyEdits([ voteRecord ], null, null);
}

private function roomsTableLayer_editsCompleteHandler(event:FeatureLayerEvent):void
{
    count++;
    peopleCount.text = count + " people think this is important";
}

Re: Editing a related table -help- esri sample

LizDaRos — Wed, 09 Nov 2011 14:30:20 GMT

Thanks for looking at it. I guess I was just wondering if the function from that sample would even do what I want? I kind of realized the code I showed wasn't correct and would need some changes.

Re: Editing a related table -help- esri sample

RobertScheitlin__GISP — Wed, 09 Nov 2011 15:14:12 GMT

Liz,

It looks like it should work.

Re: Editing a related table -help- esri sample

R__CraigHolmes — Wed, 14 Mar 2012 13:01:47 GMT

Thanks for looking at it. I guess I was just wondering if the function from that sample would even do what I want? I kind of realized the code I showed wasn't correct and would need some changes.

Greetings Liz,
I am having difficulty with the final step of adding an additional relate entry. Did you you have success with this?
Can you share your code?
Craig

Re: Editing a related table -help- esri sample

LizDaRos — Wed, 14 Mar 2012 13:26:03 GMT

Craig,
No I wasn't able to add an additional relate entry with this flex sample, sorry. Instead I used the Javascript API sample- Citizen Service Request.
I was able to change this sample to just allow the user to create a new record in the related table.
Liz

Re: Editing a related table -help- esri sample

ionarawilson1 — Fri, 06 Dec 2013 12:48:20 GMT

Liz,

I am having a similar issue. Do you think you can share your code to add records to the related table? Thank you!

Re: Editing a related table -help- esri sample

LizDaRos — Fri, 20 Dec 2013 13:26:45 GMT

ionara_wilson,
Are you looking to see how I reconfigured the JavaScript template - Citizen Service Request to allow the user to create a new record in the related table? If so, I can try and give you some more information.
But like I said earlier, unfortunately I wasn't able to do this with the flex template. I really wish there was a flex viewer widget that allowed to you edit related data.

Re: Editing a related table -help- esri sample

ionarawilson1 — Fri, 20 Dec 2013 14:27:00 GMT

Hi Liz,

I actually combined some samples and got it working for me but it was definitely tricky! Thank you!