How to get record producer name in incident form

[raj149]

Hello Experts,

I wish you good health .

From the incident module it isn't possible to in an easy manner to determine which self-service portal form was used to that specific incident. we can not see which forms were used to create which incidents.

How to get record producer name in incident form ...?

There is one table sc_item_produced_record this will store all incident data but there is no recent data in this table .

How to achieve this  ...?

Best Regards,

Raj

[priyasunku]

@raj149 

Ya one way is to include that line of script in all the record producers.

Other way is to write After BR on the 'sc_item_produced_record' as it shows which incident is created by which RP.

In After BR you can write condition Task Type as incident.

var gr = new GlideRecord('incident');

gr.get(current.task);

gr.u_record_producer=current.producer.name;

gr.update();

If my answer solved your issue, please mark my answer as ✅Correct & 👍Helpful

[raj149]

Hello @priyasunku 

In sc_item_produced_record table recent data is not coming . Last record created on 2020 

I don't know what is the issue 

If you know please tell me.

Best Regards,

Raj

[priyasunku]

@raj149 

It is working in my PDI. could you please check once what is the issue.

If my answer solved your issue, please mark my answer as ✅Correct & 👍Helpful

[Martin Grosskop]

Hi Raj,

The Item Produced Record (sc_item_produced_record) should hold all the records that were produced via record producers:

Regards,

Martin