ApplyEdits on a TABLE

SaraEL_MALKI — Tue, 13 Jun 2017 10:16:08 GMT

Hi guys,

I wanna display a table (it's the result of a many to many relationship) then be able to updated it (editing the editable inputs),

My first question is will the function of "Attribute table" work for my table?

my second question what's the kind of query to send to the server in order to updated it ? (should be a graphic ) ?

( the image below)

Thomas Solow‌ Rebecca Strauch, GISP Robert Scheitlin, GISP‌ John Zhang

ArcGIS for Server‌

Re: ApplyEdits on a TABLE

RobertScheitlin__GISP — Tue, 13 Jun 2017 12:49:36 GMT

Sara,

You might have guessed from the lack of response to your two other previous posts on this, there are not many attempting this. What you send to the update method of the rest end point depends on the type of feature the relate points to. If the relate is just a table then the update would be a graphic without any geometry specified.

Re: ApplyEdits on a TABLE

SaraEL_MALKI — Wed, 14 Jun 2017 10:24:00 GMT

I have used the 'attribute table' widget to display the table, and it worked but when I set the property 'editable' to true, and I start editing nothing is edited and I get an error in the console saying "Can't complete this operation" meanwhile editing works for layers.

<!DOCTYPE html>

<html>

<head>

<title>FeatureTable - Custom Menu Items</title>

<style>

html, body, #map {

width: 100%;

height: 100%;

margin: 0;

padding: 0;

}

</style>

require([

"esri/layers/FeatureLayer",

"esri/dijit/FeatureTable",

"esri/geometry/Extent",

"esri/graphicsUtils",

"esri/tasks/query",

"esri/symbols/PictureMarkerSymbol",

"esri/map",

"dojo/dom",

"dojo/parser",

"dojo/ready",

"dojo/on",

"dijit/layout/ContentPane",

"dijit/layout/BorderContainer"

], function (

FeatureLayer, FeatureTable, Extent, graphicsUtils, Query, PictureMarkerSymbol, Map,

dom, parser, ready, on, ContentPane, BorderContainer

) {

parser.parse();

ready(function(){

var map = new Map("map",{

basemap: "dark-gray",

center: [-5.80, 35.75],

zoom: 12

});

//Load a FeatureTable to the application once map loads

map.on("load", loadTable);

function loadTable(){

// editable FeatureLayer

var myFeatureLayer = new FeatureLayer("......./FeatureServer/4", {

mode: FeatureLayer.MODE_ONDEMAND,

outFields: ["*"],

visible: true,

id: "fLayer2"

});

// set a selection symbol for the featurelayer

var selectionSymbol = new PictureMarkerSymbol("https://sampleserver6.arcgisonline.com/arcgis/rest/services/RedlandsEmergencyVehicles/FeatureServer/1/images/3540cfc7a09a7bd66f9b7b2114d24eee", 48 ,48);

myFeatureLayer.setSelectionSymbol(selectionSymbol);

// listen to featurelayer click event to handle selection

// from layer to the table.

// when user clicks on a feature on the map, the corresponding

// record will be selected in the table.

myFeatureLayer.on("click", function(evt) {

var idProperty = myFeatureLayer.objectIdField,

feature,

featureId,

query;

if (evt.graphic && evt.graphic.attributes && evt.graphic.attributes[idProperty]) {

feature = evt.graphic,

featureId = feature.attributes[idProperty];

query = new Query();

query.returnGeometry = false;

query.objectIds = [featureId];

query.where = "1=1";

myFeatureLayer.selectFeatures(query, FeatureLayer.SELECTION_NEW);

}

});

// Redlands police vehicle locations layer

// this layer is an editable layer

map.addLayer(myFeatureLayer);

//create new FeatureTable and set its properties

var myFeatureTable = new FeatureTable({

featureLayer : myFeatureLayer,

map : map,

editable: true,

syncSelection: true,

dateOptions: {

datePattern: 'M/d/y',

timeEnabled: true,

timePattern: 'H:mm',

// use fieldInfos object to change field's label (column header),

// change the editability of the field, and to format how field values are displayed

// you will not be able to edit callnumber field in this example.

fieldInfos: [

{

alias: 'Identifiant',

editable: false //disable editing on this field

{

alias: "Zone",

format: {

}

{

alias: "le type"

{

alias: 'Etat abimé'

}

// add custom menu functions to the 'Options' drop-down Menu

menuFunctions: [

{

label: "Filter Available Emergency Vehicles",

callback: function(evt){

console.log(" -- evt: ", evt);

// set definition expression on the layer

// show only available emergency vehicles

myFeatureLayer.setDefinitionExpression("type = '240L'");

// call FeatureTable.refresh() method to re-fetch features

// from the layer. Table will only show records that meet

// layer's definition expression creteria.

myFeatureTable.refresh();

}

},{

label: "Show All Emergency Vehicles",

callback: function(evt){

console.log(" -- evt: ", evt);

myFeatureLayer.setDefinitionExpression("1=1");

myFeatureTable.refresh();

}

}]

}, 'myTableNode');

myFeatureTable.startup();

// listen to refresh event

myFeatureTable.on("refresh", function(evt){

console.log("refresh event - ", evt);

});

}

});

</script>

</head>

</div>

</div>

</body>

</html>

topic Re: ApplyEdits on a TABLE in ArcGIS JavaScript Maps SDK Questions

ApplyEdits on a TABLE

Re: ApplyEdits on a TABLE

Re: ApplyEdits on a TABLE