topic ArcGIS Operations Dashboard Arcade Join Table in ArcGIS Dashboards Questions

ArcGIS Operations Dashboard Arcade Join Table

Norchevskyi — Tue, 04 Jan 2022 15:56:32 GMT

Hi,

I'm trying to create Arcade Expression, that will join the feature layer and a feature table for different widgets in Operations Dashboard, but my expression cannot load the data, please help me, as I suspect that something was not provided for in the code of this expression.

Thank you,

Roman

Re: ArcGIS Operations Dashboard Arcade Join Table

jcarlson — Tue, 04 Jan 2022 16:06:22 GMT

I would guess it has something to do with that Filter statement, but since the layers aren't shared publicly, it's hard to say for sure. Usually when referencing a variable in your expression string, you should put it in the string itself in the format @variableName. Try this to see if the output changes.

var i = 0; for (var t in tablefs) { var tableID = t["StreetID"] var filt_poly = Filter(polyfs, "StreetID = @tableID") for (var p in filt_poly){ joinedDict.features[i] = { attributes: StreetID: tableID Name: p["Address"], Depth: t["Depth"], } } } i++ }

Re: ArcGIS Operations Dashboard Arcade Join Table

Norchevskyi — Tue, 04 Jan 2022 16:45:12 GMT

Hi Josh,

Thanks for your answer, I applied your recomendations, but it not working. When I click Test button, I don't see error:

But after click Done button I see error in the expression:

I shared this services as public for everyone,

Thank you,

Roman

Re: ArcGIS Operations Dashboard Arcade Join Table

jcarlson — Tue, 04 Jan 2022 17:09:25 GMT

Ah, I see it now. You are trying to cast the Depth as a "float", which isn't in the list of field types you can use (even though it is a valid data type in other contexts).

Change that to 'esriFieldTypeDouble' and it evaluates just fine:

Re: ArcGIS Operations Dashboard Arcade Join Table

Norchevskyi — Tue, 04 Jan 2022 17:24:13 GMT

Josh, thank you very much, it is working

Roman

Re: ArcGIS Operations Dashboard Arcade Join Table

RussellLundstrumUSACE — Fri, 29 Jul 2022 15:48:39 GMT

A follow up question to data types- when I try to define a date, there is not an error, but nothing is returned. Example below I modified from github here

I added lines 33 and 48 to get the ForecastTime which is a date field in the source, but when it is defined as "esriFieldTypeDate" in line 48, the Test fails. If you change it to "esriFieldTypeString" it works. But I want to have a date type to work with in the dashboard. Are dates not supported or am I missing something else?

EDIT: I found help from a co-worker- added number() in the attribute array on line 33 above:

ForecastTime: number(t["ForecastTime"]),

Re: ArcGIS Operations Dashboard Arcade Join Table

Manager_HMWSSBCDC — Sat, 16 Mar 2024 17:15:23 GMT

var portal = Portal('https://gis.hyderabadwater.gov.in/portal/');

var item_id = '99646c55510049a583bc1fe853c7f5f0';

var fields = ['docketcode','objectid'];

var tankers_table = FeatureSetByPortalItem(portal, item_id, 4, fields, false);

// return tankers_table

var item_id2 = '7a28dc5aad08489ea8ce46f8eeedb51e'

var fields_2 = ['fs_name','docketno','objectid']

var fs_table = FeatureSetByPortalItem(portal, item_id2, 6, fields_2, false)

// return fs_table

var joinedDict = {

fields: [

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

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

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

'geometryType': '',

'features':[]};

var i = 0;

for (var t in fs_table) {

var tableID = t["docketno"]

var filt_tanker = Filter(tankers_table, "docketcode = @tableID")

for (var p in filt_tanker){

joinedDict.features[i] = {

attributes: {

docket: tableID,

Name: p["docketcode"],

fsName: t["fs_name"],

}

i++

}

return FeatureSet(Text(joinedDict));

Error message i'm getting is

Test execution error: Execution error - Out of bounds. Verify test data.

Please help me to find where the error was.