Skip to main content
Solved

FSM : MPM : Trigger multiple times using HierarchySelect data

  • Jun 27, 2022 9:14 AM UTC
  • 9 replies
  • 219 views

Forum|alt.badge.img+15

Hi Team,

We have a requirement to trigger MPM multiple times depending on the result of the Hierarchy Select of certain data. Can anyone share any examples of the same.

Best answer by Shneor Cheshin

@CKOppBox 

What I did is update another filed and that filed will trigger another BR.

So lets say you hierarchy select returns X records → Update UDF_N to 1

Create another BR when UDF_N changes to 1 and there use the MPM.

Like that MPM will run X times. 1 for each record that UDF_N changed to 1.

Cheers!

View original

9 replies

Shneor Cheshin
Superhero (Employee)
Forum|alt.badge.img+28
  • Superhero (Employee)
  • Jun 27, 2022 9:25 AM UTC

Hi @CKOppBox 

What do you mean trigger multiple times?

Cheers!


Forum|alt.badge.img+15
  • Author
  • Hero (Partner)
  • Jun 27, 2022 9:27 AM UTC

For Example the MPM uses input as TaskID, we want to trigger the MPM from "Monitor Schedule” for multiple tasks, using Hierarchy Select of TASK with some other Task properties.


AdrianEgley
Hero (Customer)
Forum|alt.badge.img+14
  • Hero (Customer)
  • Jun 27, 2022 11:38 AM UTC

@CKOppBox 

Hi, are you wanting the Hierarchy Select to say return 10 tasks as a dataset, and it uses that data to loop through the MPM that many times? You then map the returned values to the parameters of the MPM and it does each one individually?

Ady


Forum|alt.badge.img+15
  • Author
  • Hero (Partner)
  • Jun 27, 2022 11:26 PM UTC

Hi @AdrianEgley ,

That’s the intention.

Is there some way to achieve the same


Shneor Cheshin
Superhero (Employee)
Forum|alt.badge.img+28
  • Superhero (Employee)
  • Jun 27, 2022 11:37 PM UTC

@CKOppBox 

Look at this post.

Is this what you are looking for?

Cheers!


Forum|alt.badge.img+15
  • Author
  • Hero (Partner)
  • Jun 28, 2022 12:13 AM UTC

Hi @Shneor,

Thanks for the post details.

My requirement is similar, but instead of updating any object, need to trigger a MPM which has some additional logic.

I think @SanjeewaJ 's statement "In very brief, there is no iteration/looping in FSM XML messaging unless it is a Mass update.”, kind of confirms that I cant trigger MPM multiple times using HierarchySelect result.


Shneor Cheshin
Superhero (Employee)
Forum|alt.badge.img+28
  • Superhero (Employee)
  • Answer
  • Jun 28, 2022 12:18 AM UTC

@CKOppBox 

What I did is update another filed and that filed will trigger another BR.

So lets say you hierarchy select returns X records → Update UDF_N to 1

Create another BR when UDF_N changes to 1 and there use the MPM.

Like that MPM will run X times. 1 for each record that UDF_N changed to 1.

Cheers!


Forum|alt.badge.img+15
  • Author
  • Hero (Partner)
  • Jun 28, 2022 12:55 AM UTC

Thanks @Shneor ,

Will explore doing it as u suggested, seems feasible for our scenario as well.


AdrianEgley
Hero (Customer)
Forum|alt.badge.img+14
  • Hero (Customer)
  • Jun 28, 2022 7:37 AM UTC

@CKOppBox 

I understand the business rule process is one option.

We’ve been using Powershell as another way of doing that for some time.

Within the Powershell is a SQL script that would obtain the dataset, a column is then allocated to a variable in a MPM or standard XML insert / update. We have this run from a scheduled task on the server and they just run at the set times. 

More than happy to go into more detail, but I think the concept would be great as an idea going forward (not sure if this is available in the latest versions). I can see the option for Scheduled Processes in the Admin menu, and this is just an extension of that. We’re still posting the XML on a schedule, but able to do multiple processes in one hit and also do the ‘looping’.

Ady