filter condition in a report
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-21-2023 12:45 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-21-2023 01:03 PM - edited 11-21-2023 01:04 PM
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 ✔️👍