How to autocreate RITM once date is expired

[Gopal14]

Hi Team,

How to auto create RITM once date is expired.

Ex:

Date is expired, then automatically needs to create Requested Item.

How to create automatically Requested Item

[Rajesh Chopade1]

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

[Dr Atul G- LNG]

Hi @Gopal14 

You can do this via Flow designer easily. In Flow designer you can schedule and put the condition.

[Gopal14]

Hi @Dr Atul G- LNG 

On this variable I want logged in user name needs to populate.  How can I achieve this in flow designer

[Dr Atul G- LNG]

Expert @Rajesh Chopade1  already provide the script.