laptop and a wrench

Bug

Arcades expression in a pop-up fails to return result when the Filter() function is using the 'For' loop condition on the feature service in Portal for ArcGIS 10.7.1.

Last Published: March 6, 2020 Portal for ArcGIS
Bug ID Number BUG-000127655
SubmittedDecember 31, 2019
Last ModifiedJuly 17, 2025
Applies toPortal for ArcGIS
Version found10.7.1
Operating SystemWindows OS
Operating System Version2012 R2
Version Fixed10.8
StatusFixed

Additional Information

The SQL query syntax is invalid in the following line of the expression. var sql = 'STATE_FIPS = 15' The field 'STATE_FIPS' is a string field and the value being passed is not contained in quotations. The line above must be updated to provide quotations around the query value. The correct syntax for the entire expression is below: var tbl = FeatureSetByName($map,"Test.DBO.cities1") var ftr = $feature.STATE_FIPS; var sql = 'STATE_FIPS =' + TextFormatting.SingleQuote+ '15'+TextFormatting.SingleQuote; var txt = Filter(tbl,sql) Console(Count(txt)) Console(TypeOf(txt)) var outtxt = "" if (Count(txt)>0){ for (var test in txt){ Console("THIS IS NEVER REACHED") outtxt += $feature.STATE_NAME + " " + test["POP1990"] + " " + test["CITY_NAME"] + TextFormatting.NewLine}} return outtxt

Steps to Reproduce

Bug ID: BUG-000127655

Software:

  • Portal for ArcGIS

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options