filter condition in a report

sam43
Tera Contributor

I have to run a report on certification elements table.

Certifications are created on Cis.

The requirement is select a ci  configuration items that were rejected( custom approval field) and certified from the most recent certification element . For example in the below image,

both of the records should not picked up as the approval is approved for in recent certification(see certified first column). This is example for one ci. How to customize/include the condition in report

sam43_0-1700597759879.png

 

1 REPLY 1

Shubham Singh
Mega Guru

Hi @sam43 

 

Use Condition on report as below:

Sys ID is one of javascript: new script_include_name().function_name();

 

Create a script include and its function accordingly and return the SysIDs of the required records in the function.

 

Thanks!

 

Please mark this response as correct and helpful if it works ✔️👍