After publishing a joined feature class with a table containing date fields, the time zone advanced parameter is not respected for the feature class in a server service.
上次发布: February 15, 2018ArcGIS GIS Server
漏洞 ID 编号
BUG-000104985
已提交
May 8, 2017
上次修改时间
August 17, 2025
适用范围
ArcGIS GIS Server
找到的版本
10.4
操作系统
Windows OS
操作系统版本
2012
修正版本
10.6.1
状态
Fixed
此漏洞已得到修复。 有关详细信息,请参阅“版本修复”和“其他信息”(如果适用)。
解决办法
1. Create static data from the dynamic table by using the Join tool to append the desired fields to the feature class.2. If using a single database i. Create a relationship class with a one to one relationship between the feature class and table. ii. Publish the related data (in advanced parameters use Pacific Standard Time or the local time zone in the time properties), and configure the popups in the web viewer to display features from the related table.3. If using two separate databases i. Create a dblink in the sde database to the database containing the table. ii. Create a view directly in the sde database to pull data from the external database into sde. iii. Create a relationship class using the new view in the same database as the feature class. iv. Publish the related data (in advanced parameters use Pacific Standard Time or the local time zone in the time properties), and configure the popups in the web viewer to display features from the related table.4. Add a time component to that date field, and append '12:00' to existing non-null date entries. i. If entering a date without a time component, add 12 hours to the date - instead of entering '5/27/2014', enter '5/27/2014 12:00PM' or '5/27/2014 12:00'. This offsets the UTC time.