BizTalk's Cumulative Functoids and their Scope

BizTalk's Cumulative Functoids and their Scope

  • Comments 1

Biztalk’s powerful mapper tool, allows the reduction of multiple values into a single value. For instance it allows the user to sum up the values of all orders. However what if we are only interested in summing up the value of all the orders in the scope of their parent order book? Well in that case, we can specify a second input parameter to the cumulative functoid which defines the scope of the operation.  

The values for the scoping parameter are:

Value

Description

0

This forces the operation over the entire document instance

1

This applies the operation in the scope of the first parameter’s parent

2

Same as 1 but in the scope of the value’s grandparent

3 or greater

You can guess the rest! (Tip: great-grandparent, great-great-grandparent, etc.)

 

In the example below, I have a cumulative sum functoid which calculates the total quantity of items for order books.

Notice the second constant parameter to the cumulative sum functoid specifying the scope of the operation.

Leave a Comment
  • Please add 7 and 8 and type the answer here:
  • Post
  • Hi Pedram,

    Thanks for your archive, this really resolve my issue.

    Cheers

    Eric.Xu

Page 1 of 1 (1 items)