Related Table Information in Pop-up

10-28-2019 10:37 AM
Occasional Contributor III

I have a service that has a polygon feature class representing parcels, and a related table populated with tax history data.  Using Arcade, I'm able to build a pop-up in a web map that displays the tax information for each tax authority.

However, this only seems to work in ArcGIS Online (AGO).  If I use the same service, and the same Arcade expressions within Portal (10.7.1), the pop-up does not display, or seem to retrieve any of the related table information, specifically when calling an iterator to get the individual rows within the related table feature set.

If I use the Console function to test if the FeatureSet is returning/finding anything, it seems to indicate that the related records are being found in Portal, as the number of related tax records found is correct...but none of the individual rows within the related table feature set are being returned.

Is this a known issue/bug in Portal...? there some sort of performance issue in Portal when it comes to retrieving the data?

Any ideas...?

Below is the Arcade expression being used, and console returns between both AGO and Portal.  AGO returns what I want, Portal does not ... like I said, seems to be specific to the iterator.

// get gpn
var gpn = $feature.GPN;
// construct sql
var sql = "GPN=" + "'" + gpn + "'";

// create feature set
var fsTaxBill = FeatureSetByName($map, "Tax Bill Distribution");
// order feature set
var fs = OrderBy(Filter(fsTaxBill, sql), "TaxGross DESC");
// get feature set count
var cnt = Count(fs);

// display number of related records found
Console('Number of related tax records found: ' + cnt)

// create return place holder
var p = "";

// check if any related records were found
if (cnt > 0) {
    // create iterator
    Console("Start iterator...")
    for (var x in fs) {
        Console("Within iterator...")
        // get tax authority
        var a = x.TaxAuthority;
        // get and format gross tax
        var g = "$" + Text(x.TaxGross, "#,###.00");
        // add authority and gross tax to place holder
        p += a + ": " + g + TextFormatting.NewLine
    Console("End interator...")
} else {
    // no related tax information found
    p = "No tax information found..."

// display return value
// return value
return p‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Related table pop-up working in ArcGIS Online


AGO console test --- iterator working

Related table pop-up NOT working in Portal

Portal console test --- iterator NOT working

0 Kudos
0 Replies