Advertisements



Using FLWOR expressions in OSB

As Wikipedia defines FLWOR is an acronym: FOR, LET, WHERE, ORDER BY, RETURN. FLWOR is loosely analogous to SQL’s SELECT-FROM-WHERE. FLWOR expressions can be used in OSB.

If we are creating variables in assign actions for just intermediate XQuery expressions evaluation then ‘let’ can be used multiple assign actions into one to increase proxy service performance.

In the following screenshot, 1st assign action loads contents XQuery resource and stores it in ‘varConfigPayload’ variable. The 2nd assign action gets the proxy name sent in payload using ‘$body/Payload/ProxyName/text()’ and stores it in ‘varProxyName’ variable. And the 3rd assign activity uses ‘$varConfigPayload/ProxyService[@name=$varProxyName]/Flag/text()’ to get the value from XQuery resource and store it in ‘varFlagValue’ variable.

             image

Assume that variable ‘varProxyName’ is not used anywhere else, then we can combine the 2nd and 3rd assign actions by giving the expression as shown in below screenshot.

            image

This is how we can use the FLWOR expressions to combine multiple assign activities into one.

Advertisements

1 Response to “Using FLWOR expressions in OSB”


  1. 1 mani December 14, 2011 at 6:50 PM

    Hi shiva,
    Thanks for nice blog,can you please post the jar file of the project or else can you send it to mail Id mani.pala744@gmail.com


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s




Advertisements

Pages

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 341 other followers

Enter your email address to follow this blog and receive notifications of new posts by email.