Catalog item records insertion

[Rahul84]

Hi @Ankur Bawiskar /team

I have another requirement as - I need to create a catalog item which consists of 3-4 fields like manager name , employee name , address and email

Upon submission I need to create a task for one of the group to review the request.

Once any member from this group reviewed the request and closed it. I need to insert this data into a particular table "u_abc".

if the records already exists in the table "u_abc" then we need to skip this catalog request data.

## I am cleared till catalog item creation and task creation for one of the group via workflow.

But how we can have this below requirement fulfilled 

Once any member from this group reviewed the request and closed it. I need to insert this data into a particular table "u_abc".

if the records already exists in the table "u_abc" then we need to skip this catalog request data.

Thanks !

[Rahul84]

Hi @Ankur Bawiskar ,

I have replied your query, can you pls help to get this requirement covered by the steps and logic...

[Ankur Bawiskar]

What script have you started and what debugging is done?

[Rahul84]

not able to apply the logic for the same. That's why asked community to help.

 It would be great if you can help to provide me the sample script for the asked requirement so that I can refer that..

[Ankur Bawiskar]

Unless you start how will you learn

Community members can help you but they may not be aware of the exact requirement.

[chsumit]

Hi,

You can write a BR where you can check first request state changes to Resolved/Closed and Assignment group ='Required group'.

After Update BR, Query the ABC table and add query by which you need to check the unique record and if not available then Initialize the record.

Thanks,

Sumit