Need to trigger notification like a reminder to catalog variable users .

[Shweta Gupta]

Hi Experts,

We have to trigger Notification like a reminder to catalog variable users just a day before the variable To Date .

I tried using event registry but it is not working. Can I ask for any other or simple approach to achieve it . 

Thanks in Advance .

Shweta 

[rishabh katari1]

Hi @Shweta Gupta,

You need to create an event from event registry, then make scheduled job to perform the necessary action, fill the requirement when you want to trigger notification, and in scheduled job trigger the event. Notification should be run on trigger of event.

Let me know if you have anything further query.

Thanks,

Rishabh

[Shweta Gupta]

Hi @rishabh katari1 

I tried creating Event on Sc_req_item which run on Scheduled JOB but not able to figure out table to query in schedule JOB as variables generally store in different table sc_item_option_mtom . Can you please help me to nail this.

Thanks in Advance,

Shweta 

[rishabh katari1]

Hi @Shweta Gupta,

You don't need to query on sc_item_option_mtom table.

You can do this in following manner:
1.  Create Event

2. Create Scheduled Job:

here, I am checking if today's date matches with the date submitted by requestor, then trigger the event and also, I am doing this to be for specific catalog item.

3. Create Notification:

Hope this helps.

Do give a thumps up if solution is good enough.

Thank you,

Rishabh

[Shweta Gupta]

Hi @rishabh katari1 

if in case we want to trigger notification 7 days before the submitted variable date we have to just change this line right .

CapturedDate.addDays(-7);

Thanks in Advance

Shweta Gupta