Advanced Filtering Conditions on Reports

[Madhan007]

Hi Everyone!

In the Workplace Reservation (WSD) table, some reservation records created via integration are being generated with an incorrect Subject value. Specifically, the Subject is populated as Requested for User's Last name , first name

To identify and report on these records, we attempted to schedule a report with a filter condition. A Script Include was created to return the relevant sys_id values, and the report filter was configured using:
sys_id is one of javascript&colon; new <ScriptInclude>().<method>()
However, the filter is returning null.

We also attempted to use a Dynamic Filter, but the dynamic operator is not available when selecting the sys_id field in the report filter conditions.

 

 

Any Insights into this are highly Appreciable.

Thanks in Advance!!

[brianlan25]

I have a report that calls a script include that returns an array. I just use is instead of is one of. Also I notice that your script include is trying to lookup data after you go into your while loop. However I do not see you passing that information to the script include. So were would it get the data to know who the first and last name of the requested for is?