Shulou(Shulou.com)06/02 Report--

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.