topic Re: Script runs on test, but displays a table with no values in ArcGIS Dashboards Questions

Script runs on test, but displays a table with no values

MarceloCatalão — Fri, 12 Jul 2024 11:08:33 GMT

Hello

I wanted that in a dashboard list I am presented with the Date of the last record of a certain value and 3 days are added to the date, strange is that there is no script error, sample me a table, but without the desired final values, what can be the problem?

Thanks

// Get the Item Portal FeatureSet
var fs = FeatureSetByPortalItem(Portal('https://sgmai.maps.arcgis.com'), 'cc483edaa0f3457c8cd99149d36c1ced', 0, ['selec', 'CreationDate'], false);

// Filter AEO records and sort by creation date
var fsAEO = Filter(fs, "selec = 'AEO'");
var sortedFS = OrderBy(fsAEO, 'CreationDate DESC');

// Create a list to store the modified records
var updatedFeatures = [];

// Iterate over the records and modify the date
for (var feature in sortedFS) {
// Obter a data de criação
var creationDate = Date(feature.CreationDate);

// Add 3 days to the date
var newDate = DateAdd(creationDate, 3, 'days');

// Create a New Object with the Date Modified
var updatedFeature = {
'attributes': {
'selec': feature.selec,
'CreationDate': newDate
}
};

// Add the new object to the list
Push(updatedFeatures, updatedFeature);
}

// Create a New FeatureSet with the Modified Records
var updatedFeatureSet = {
'fields': [
{'name': 'selec', 'type': 'esriFieldTypeString'},
{'name': 'CreationDate', 'type': 'esriFieldTypeDate'}
],
'geometryType': '',
'features': updatedFeatures
};

// Return the Modified FeatureSet
return FeatureSet(Text(updatedFeatureSet));

Re: Script runs on test, but displays a table with no values

KenBuja — Fri, 12 Jul 2024 13:49:11 GMT

Your code works correctly with a sample dataset (with a couple of modification for different fields). I would check if you're getting the expected records from your filter (line 13).

// Fetches features from a public portal item var fs = FeatureSetByPortalItem( Portal("https://www.arcgis.com"), // portal item id "6200db0b80de4341ae8ee2b62d606e67", 0, // layer id ["*"], // fields to include false // include or exclude geometry ); // Filter AEO records and sort by creation date var fsAEO = Filter(fs, "FeatureCode = 1000"); console(Count(fsAEO)) var sortedFS = OrderBy(fsAEO, "LASTUPDATE DESC"); // Create a list to store the modified records var updatedFeatures = []; // Iterate over the records and modify the date for (var feature in sortedFS) { // Obter a data de criação var creationDate = Date(feature.LASTUPDATE); // Add 3 days to the date var newDate = DateAdd(creationDate, 3, "days"); // Create a New Object with the Date Modified var updatedFeature = { attributes: { selec: feature.FeatureCode, CreationDate: newDate } }; // Add the new object to the list Push(updatedFeatures, updatedFeature); } // Create a New FeatureSet with the Modified Records var updatedFeatureSet = { fields: [ { name: "selec", type: "esriFieldTypeString" }, { name: "CreationDate", type: "esriFieldTypeDate" } ], geometryType: "", features: updatedFeatures }; // Return the Modified FeatureSet return FeatureSet(updatedFeatureSet);

Re: Script runs on test, but displays a table with no values

dgiersz_cuyahoga — Fri, 12 Jul 2024 13:50:17 GMT

I suggest adding Console() statements after each variable declaration to make sure they are returning what you are expecting. Console() can show the object returned and you can also use it to show a count of objects.

Re: Script runs on test, but displays a table with no values

MarceloCatalão — Fri, 12 Jul 2024 18:27:13 GMT

Your data is working fine, when I change it to my portal and go to put the value "Register AEO" it gives an error

(ERRO: Test execution error: Expected "!=", "(", "*", "+", "-", "/", "<", "<=", "<>", "=", ">", ">=", "AND", "OR", "||", [ \t\n\r], or end of input but "A" found.. Verify test data.)

// Fetches features from a public portal item

var fs = FeatureSetByPortalItem(

Portal("https://sgmai.maps.arcgis.com"),

// portal item id

"cc483edaa0f3457c8cd99149d36c1ced",

0, // layer id

['selec','CreationDate'], // fields to include

false // include or exclude geometry

);

// Filter AEO records and sort by creation date

var fsAEO = Filter(fs, "FeatureCode = Registar AEO");

console(Count(fsAEO))

var sortedFS = OrderBy(fsAEO, "selec");

// Create a list to store the modified records

var updatedFeatures = [];

// Iterate over the records and modify the date

for (var feature in sortedFS) {

// Obter a data de criação

var creationDate = Date(feature.LASTUPDATE);

// Add 3 days to the date

var newDate = DateAdd(creationDate, 3, "days");

// Create a New Object with the Date Modified

var updatedFeature = {

attributes: { selec: feature.FeatureCode, CreationDate: newDate }

};

// Add the new object to the list

Push(updatedFeatures, updatedFeature);

}

// Create a New FeatureSet with the Modified Records

var updatedFeatureSet = {

fields: [

{ name: "selec", type: "esriFieldTypeString" },

{ name: "CreationDate", type: "esriFieldTypeDate" }

geometryType: "",

features: updatedFeatures

};

// Return the Modified FeatureSet

return FeatureSet(updatedFeatureSet);

Re: Script runs on test, but displays a table with no values

KenBuja — Fri, 12 Jul 2024 18:30:47 GMT

The Filter sql statement is incorrect. You had it correct in your original code. Did you mean to use this?

var fsAEO = Filter(fs, "selec = 'Registar AEO'");

Re: Script runs on test, but displays a table with no values

MarceloCatalão — Fri, 12 Jul 2024 19:04:03 GMT

Resolvido: Este funciona 🙂

Muito obrigado

// Fetches features from a public portal item

var fs = FeatureSetByPortalItem(

Portal("https://sgmai.maps.arcgis.com"),

// portal item id

"cc483edaa0f3457c8cd99149d36c1ced",

0, // layer id

['selec', 'PGDH2'], // fields to include

false // include or exclude geometry

);

// Filter AEO records and sort by 'PGDH2' descending

var fsAEO = Filter(fs, "selec = 'Registar AEO'");

console("Count of filtered AEO records: " + Count(fsAEO));

var sortedFS = OrderBy(fsAEO, "PGDH2 DESC");

// Create a list to store the modified records

var updatedFeatures = [];

// Iterate over the records and modify the date

for (var feature in sortedFS) {

// Get the PGDH2 date and convert to string to remove time

var creationDate = Text(Date(feature.PGDH2), "YYYY-MM-DD");

// Convert back to date object and add 3 days

var newDate = DateAdd(Date(creationDate), 3, "days");

// Format new date to only include day, month, and year

var formattedDate = Text(newDate, "DD-MM-YYYY");

// Create a new object with the date modified as text

var updatedFeature = {

attributes: { selec: feature.selec, PGDH2: formattedDate }

};

// Add the new object to the list

Push(updatedFeatures, updatedFeature);

}

// Create a new FeatureSet with the modified records

var updatedFeatureSet = {

fields: [

{ name: "selec", type: "esriFieldTypeString" },

{ name: "PGDH2", type: "esriFieldTypeString" }

geometryType: "",

features: updatedFeatures

};

// Log the updated feature set

console("Updated feature set: " + Text(updatedFeatureSet));

// Return the modified FeatureSet

return FeatureSet(updatedFeatureSet);