The CreatorCon Call for Content is officially open! Get started here.

Multiple Notification Variable

TashfiqueH
Tera Contributor

Hi, 

I am working with an Application. That has different approvals by different users. The very first approval should capture a unique ISET number. There will be multiple ISET numbers, user will select a unique ISET number. 

Once selected and approved the next user will receive a notification with that ISET, followed by the following user with that same ISET number. I would like to know how can I proceed with this? I am able to make notifications for different users. But not sure on how to bring that "ISET" thru the flow. I am just using notification, event and business rules. 

 

Kindly assist. 

1 ACCEPTED SOLUTION

@TashfiqueH 

on your price list table you can have a reference field pointing to Import Set table which you can then use to inform users which ISET was used for this row/record

Then use onBefore or onAfter to set that

Something like this in onBefore

(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {

	// Add your code here
	target.u_importSetField = import_set.sys_id;

})(source, map, log, target);

If you are using onAfter then use target.update() to update the target record

But remember import sets are cleaned up OOB every 7 days

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

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

5 REPLIES 5

Ankur Bawiskar
Tera Patron
Tera Patron

@TashfiqueH 

so you have different approval for different users

How are you determining that currently?

What did you build so far and where are you stuck?

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

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

TashfiqueH
Tera Contributor

I have not built yet, as I am still thinking of how to implement it. 

 

So there is Import Set Table and MyPriceList table. 

 

So I have thought of 2 business rules. 

1)

Condition:

When the state is processed in Import Set Table>MyPriceList

Notify uploader that upload is successful also notify manager that he has to review. 

ISET number I am going to pass thru event.parm1 in gs.eventQueue.

 

2. Second Business rule 

I am thinking of doing the script of different conditions and what event it should trigger. 

 

What I am struggling with, is the ISET from the very beginning I want to carry it all the way through out for notifications. I am not sure how to bring the ISET stored in a variable in business rule 1 to business rule 2. I am not writing on import set source either. 

 

 

@TashfiqueH 

so you want to notify once import set is successfule

what is the 2nd requirement?

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

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

TashfiqueH
Tera Contributor

1)

Import set is processed.  (in my application it just means when a price list file is uploaded) Once its processed it will trigger a notification.  I am able to do this. 

Table: Import Set Table 

 

2)MyPriceList status changes. There are various statuses such as pending review, pending approval and approved. 

Table: MyPriceList

 

This should have the same ISET number from the time it processed. I am not sure how to carry this variable throughout. So far I have thought of having 2 business rules, however I am not sure how to pass the variable from one business rule to another