Need to generate RITM based on Variables value in Record Producer

[Rekha Tiwari]

Hi All,

I have Record Producer. which has variable called Will you require IT's assistance for your meeting? or "it_requirement". It is multiple choice type with Values: Yes, No, Do not know.

If its variable value is 'yes' then I have to auto create a RITMXXXXXX with already created catalog item:

Requirement is:

• If Will you require IT's assistance for your meeting? = Yes a new catalog item is created with the following information:
  
  • Item type: Can't Find What I Need   (This is a catalog item existed)
  • (Field on RITM) Requested for: Event Host (Employee Name) - variable in Record producer
  • (Field on RITM) Due date: When is your event? (1st Choice) - variable in Record producer
  • Assignment Group: SG_SN-IT-ServiceDesk Tier I
  • State: Open
  • Approval: Not Required
  • Parent: WPS record created (show in Request Item form)
  • Short Description: IT Assistance for {Event Type} for {Requested for}
  • Area you need assistance with? Other
  • Provide a short description of your request: Same as short Description
  • Provide a detailed explanation and justification of your request:
    
    • Reference {WPE #}
    • Event Host:
    • Event type: 
    • Event Format:
    • Event Title Name: 
    • Event Description = Describe this event, including its purpose
    • Event 1st Choice:
    • Event 2nd Choice:
    • Expected Number of Attendees:
    • Requested Country:
    • Other Requests/Notes: 

Attached is the Catalog item form

Please help me how to proceed.

[Ankur Bawiskar]

@Rekha Tiwari 

Glad to know that my script worked.

Please mark response helpful as well.

Regards
Ankur

[Rekha Tiwari]

Hi @Ankur Bawiskar 

I need to set workplace record reference on RITM record's item variable.

if (producer.it_requirement == 'yes') {
    try {
        var desc;
        var cartId = GlideGuid.generate(null);
        var cart = new Cart(cartId);
        //add your requested item to the cart by sys_id of the catalog item
        var item = cart.addItem('ed8e941a1bee9010f5bef5f61a4bcb82', 1); //sys_id of Can't Find What I Need

        //Set variables on the catalog item form
        
        cart.setVariable(item, "category", '7cf1c22d1bd46810217f54651a4bcbb1');   //Others
        cart.setVariable(item, "short_description", current.short_description);
        desc = "Reference {WPE #} " + current.sys_id() + "\nEvent Host: " + producer.event_host.getDisplayValue() + "\nEvent type: " + producer.event_type + "\nEvent Format: " + producer.event_format + "\nEvent Title Name: " + producer.event_name + "\nEvent Description: " + producer.event_description + "\nEvent 1st Choice: " + producer.virtual_event_choice_1 + "\nEvent 2nd Choice: " + producer.virtual_event_choice_2 + "\nExpected Number of Attendees: " + producer.expected_number_of_attendees + "\nRequested Country: " + producer.requested_country.getDisplayValue() + "\nOther Requests/Notes: " + producer.other_requests_notes + "\nWPE Assignment Group:: " + current.assignment_group.getDisplayValue();
        cart.setVariable(item, "description", desc);
        var rc = cart.placeOrder();
        gs.info(rc.number);
        //Set RITM fields values
        
        var ritm = new GlideRecord('sc_req_item');
        ritm.addQuery('request', rc.sys_id);
        ritm.query();
        if(ritm.next()){
            ritm.parent = current.sys_id;

    } catch (ex) {
        gs.info(ex);
    }
}

but this line is not working: "Reference {WPE #} " + current.sys_id()

Please suggest what is wrong.

FYI: this description variable is on Catalog item which is creating RITM

[Ankur Bawiskar]

Hi,

then create the RITM using after insert BR on that table

You will get sysId of current record in that BR

regards
Ankur

[Rekha Tiwari]

Hi,

Then all field mapping that I did using Cart API and Gliding sc_req_item table. All should be from BR?

[Ankur Bawiskar]

yes that's correct. after insert BR on that custom table.