|
Home > Archive > BizTalk Server Orchestration > February 2005 > message filtering within an orchestration - help!
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
message filtering within an orchestration - help!
|
|
|
| Hello,
My problem is the following. I have a message with several repeating
elements, as follows:
<elementslist>
<customers maxOccurs=unbounded>
<name></name>
<address></address>
| |
| Matt Milner 2005-02-17, 2:46 am |
| You should be able to use the logical functoids iin a map n combination with
the looping functoid to get only those items that match your criteria.
Matt
"Theo" <Theo@discussions.microsoft.com> wrote in message
news:606BB86E-CFDD-4FBF-A350-CB130259ED4A@microsoft.com...
> Hello,
>
> My problem is the following. I have a message with several repeating
> elements, as follows:
>
> <elementslist>
> <customers maxOccurs=unbounded>
> <name></name>
> <address></address>
> .
> .
> </customers>
> </elementslist>
>
> where customers can appear an unbounded number of times within the
> message.
> If the number of letters in address is higher than some value I don't map
> this record (this customers-record) into the outgoing message.
>
> I am stuck on two problems:
> 1. How can I access the "address" field within my orchestration, I cannot
> promote it because it can appear several times.
> 2. How can I skip some "customers" records from the ingoing message to the
> outgoing message. Should this be done with a map?
>
> Any ideas?
| |
| Michel Prévost 2005-02-17, 2:46 am |
| 1. Use xpath, within a loop. Initialize a variable with an xpath expression,
like xpath(count(/elementslist/customers)) [I am not too familiar with using
XPath within an orchestration, so this is the basic idea taht may put you on
track]. In each loop, initialize another variable using the xpath position()
function xpath(/elementslist/customers[position() = myloopcounter]).
2. A map seems a good choice here, if you can figure out which customers to
skip based on some values within a customers node.
Michel
"Theo" <Theo@discussions.microsoft.com> wrote in message
news:606BB86E-CFDD-4FBF-A350-CB130259ED4A@microsoft.com...
> Hello,
>
> My problem is the following. I have a message with several repeating
> elements, as follows:
>
> <elementslist>
> <customers maxOccurs=unbounded>
> <name></name>
> <address></address>
> .
> .
> </customers>
> </elementslist>
>
> where customers can appear an unbounded number of times within the
> message.
> If the number of letters in address is higher than some value I don't map
> this record (this customers-record) into the outgoing message.
>
> I am stuck on two problems:
> 1. How can I access the "address" field within my orchestration, I cannot
> promote it because it can appear several times.
> 2. How can I skip some "customers" records from the ingoing message to the
> outgoing message. Should this be done with a map?
>
> Any ideas?
|
|
|
|
|