Filter is not working on calculated field

转载于 2019-01-11 14:33:26 发布 · 75 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://blog.51cto.com/13716461/2341571

文章标签：

#数据库

本文介绍如何在ServiceNow中使用脚本批量更新已存在的记录，以保存计算字段的值到数据库。此方法适用于那些在创建计算字段时，已有记录存在于系统中的情况。通过运行特定的GlideRecord脚本，可以确保所有现有记录的计算字段被正确存储。

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?)

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();
}

转载于:https://blog.51cto.com/13716461/2341571