hi @Gopal14
To automatically create a Requested Item (RITM) when a certain date is expired, you can use a combination of a scheduled job and a script.
Create a New Scheduled Job:
Run: Select how often you want this job to run (e.g., Daily, Hourly).
Condition: You can set a condition if you only want to check for specific criteria, but typically you will just run the job on a schedule.
Script: write script to create RITM
(function() {
// Define the table where you are checking for expiration dates
var gr = new GlideRecord('your_table_name'); // Replace with your table name
gr.addQuery('expiration_date', '<=', new GlideDateTime()); // Adjust the field name
gr.addQuery('state', '!=', 'closed'); // Optionally check that the state is not closed
gr.query();
while (gr.next()) {
// Create the Requested Item (RITM)
var ritm = new GlideRecord('sc_req_item');
ritm.initialize();
ritm.short_description = 'Auto-generated RITM for ' + gr.getDisplayValue('field_name'); // Adjust as needed
ritm.request = gr.sys_id; // Associate with a request if needed
ritm.u_custom_field = gr.u_custom_field; // Map any other fields as necessary
ritm.insert(); // Insert the RITM
// Optionally, you can log or handle errors
}
})();
i hope my answer helps you to resolve your issue, if yes please mark my answer helpful and correct.
thank you
rajesh
