send notification to who created on idea when user comment on idea through idea portal
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-24-2024 04:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-26-2024 06:57 PM
Hi, I don't see an update to sys_journal_field when an idea is commented, so triggering a notification from the idea table would not be straight forward - unless someone else provides a better answer.
But checking sysevent, I see a sysevent for im_idea_activity which is linked to the table 'sn_actsub_activity' and looking at this table it appears to have links to the idea and the added comments.
I have not tested but I would think you could created your notification based on insert of sn_actsub_activity where when verb or activity type matches your requirement (IE comments), and then dot.walk to 'Object' to get the comments detail, then use a notification email script to lookup and populate the details from the idea record via addl_sub_obj2 and addl_sub_obj2_name
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-27-2024 04:55 AM
Hi @rachuri john ,
Comments made on idea are stored in cf_comment table. You can create a notificaiton when an entry is made on this table with source table as 'idea' and commended user will be in user field.
I hope this helps..
☑️ Please mark responses as HELPFUL or ACCEPT SOLUTION to assist future users in finding the right solution....