Need to send an approval from request table based on the variable selection in Catalog item
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-26-2024 08:05 AM
I have to send an approval to the user based on the value selected in the order guide.
But I have to send an approval for the request.
Once the user submits the catalog with the field as ABC as an value which is referenced to custom table.
After submission, I want to send an approval to the person selected and that should trigger from Request table not from RITM table. How to look up RITM table from Req table and get the values and send it for the approval.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-29-2024 05:47 PM
Hello @Aswin Chandras1
I hope you're creating the notification on the sc_request table.
If so, you can query the sc_req_item table for the request and then get the variable value.
Let me know what you've tried so far and where you stuck.
Murthy
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-29-2024 10:29 PM
Hi Murthy,
Yes am trying to create in sc_request table.
The variable is in the RITM variables section called Approver. Based on the selection over there I need to send an approval to the user selected.
Am stuck at how to get the variables and send notification.
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-29-2024 11:28 PM
Hello @Aswin Chandras1
I need some inputs before I suggest you:
1) Why do you need to create the notification on sc_request rather than sc_req_item?
2) Do you want to send approval or notification or both?
3) Is this specific to the one catalog item?
If you are sending the notification for the request then where do you want to add the approver?
In the sc_request flow?
Murthy
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-30-2024 02:39 AM
1) Why do you need to create the notification on sc_request rather than sc_req_item? - We have some tasks on the request level and not on the RITM level.
2) Do you want to send approval or notification or both? - Need to send an approval and we have notification where it send it OOB.
3) Is this specific to the one catalog item? - Yes
If you are sending the notification for the request then where do you want to add the approver?
In the sc_request flow? yes in sc_request flow. Workflow is on the sc_request table.
