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.
上次发布: March 6, 2020Portal for ArcGIS
漏洞 ID 编号
BUG-000127655
已提交
December 31, 2019
上次修改时间
July 17, 2025
适用范围
Portal for ArcGIS
找到的版本
10.7.1
操作系统
Windows OS
操作系统版本
2012 R2
修正版本
10.8
状态
Fixed
此漏洞已得到修复。 有关详细信息,请参阅“版本修复”和“其他信息”(如果适用)。
附加信息
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