Hello @SK07 ,
Just got some time to replicate your use case and wanted to share a simple working example I tried in my PDI—it should help you get started quickly.
I kept this in a separate topic and structured it in two main steps:
🔹 Step 1 – Ask user for timeframe
Create a text question (open-ended input) like:
"How many days back do you want to check for incidents?"
-
Variable Name: "get_days_range"
-
Input Format: Text (you can later enhance it to use quick replies like 5, 10, 15, etc.)
🔹 Step 2 – Scripted Table Response
Use the "Table" response type to display incidents in a clean tabular format.
Here’s the script I used inside the table’s Populate with Script section:
(function execute(table) {
var daysRange = parseInt(vaInputs.get_days_range);
var userId = gs.getUserID(); // Logged-in user
// Relative date filter (X days ago)
var relativeDate = '@dayofweek@ago@' + daysRange;
// Encoded query to fetch created or updated incidents
var encodedQuery = 'caller_id=' + userId +
'^NQsys_created_onONRELATIVEGE' + relativeDate +
'^ORsys_updated_onONRELATIVEGE' + relativeDate;
var gr = new GlideRecordSecure(table);
gr.addEncodedQuery(encodedQuery);
gr.query();
return gr;
})(table);
In the Columns section of the table, I displayed:
-
Number
-
Assigned to
-
State
Feel free to adjust based on your needs.
Final Output:
Best regards,
Aniket Chavan
🏆 ServiceNow MVP 2025 | 🌟 ServiceNow Rising Star 2024
