Getting Record Producer to add fields to external table

[AM24]

Hello,

I have the incident table. I created another table just to add fields to that incident table, called incident _fields, since it takes too long to add changes to incident in the production environment. The incident table has a reference to that incident_fields table, so I can access any additional fields. Now, this is only for a particular type of incident, for which we are creating a specific record producer. How would I map a field from record producer to that incident_fields table? How would I ensure that an incident_fields record is created? Just needed a little advice planning out development.

[Ankur Bawiskar]

@AM24 

you can use an after insert BR on incident table and check if this incident got created from record producer or not.

if yes then create a new record into the other table with relevant fields and set the reference field on incident with the newly created record

BR Condition: After Insert

Condition: Your Specific Type logic

1) to check if record got created from record producer or not check in this table if your incident is present or not

Query the table "sc_item_produced_record" with Task = INC SysId

If my response helped please mark it correct and close the thread so that it benefits future readers.

[AM24]

Ok. I can add a business rule to check if my incident was created by the record producer. How would I get those fields from the record producer into the external table?