Filterisnotworkingoncalculatedfield

Did you create the field with the calculated value after the table was already in production (i.e. did records exist before they had this field available?)

创新互联是专业的祥符网站建设公司,祥符接单;提供网站建设、成都网站制作,网页设计,网站设计,建网站,PHP网站建设等专业做网站服务;采用PHP框架,可快速的进行祥符网站开发网页制作和功能扩展;专业做搜索引擎喜爱的网站,专业的做网站团队,希望更多企业前来合作!

If so, then they are calculating the value for list display only and don't have anything stored in the database (where the filter is querying from.)

You'll need to run a script in scripts-background to update all existing records to save the calculated field in the database for each record (and be sure to use autoSysFields(false) and setWorkflow(false) and setForceUpdate(true)) to go in stealth mode.

var r = new GlideRecord('task');
r.addQuery('sys_class_name','pm_project');
r.query();
while (r.next()) {

         r.setForceUpdate(true);

         r.autoSysFields(false);

         r.setWorkflow(false);

         r.update();
}

当前文章:Filterisnotworkingoncalculatedfield
文章来源:http://csdahua.cn/article/gepgdi.html
扫二维码与项目经理沟通

我们在微信上24小时期待你的声音

解答本文疑问/技术咨询/运营咨询/技术建议/互联网交流