Passing Parameters in a URL and Document Chaining

[Josh_Good]

This videos describes how to pass parameters in a URL and how to leverage this techinque to chain documents when using AJAX.

The genral syntax is as follows:

http://myserver//QvAJAXZfc/opendoc.htm?document=DocumentName.qvw&host=Local&select=LB01,Value

It is also possible to us a similar technique to go directly to a specific sheet within a document using the sheet parameter.

e.g. http://myserver//QvAJAXZfc/opendoc.htm?document=DocumentName.qvw&host=Local&sheet=SH01

http://youtu.be/ESSvm_xMTlE

[#2]

hi,

How do we pass parameter in IE plugin.

Above URL WONT WORK IN IE plugin.

Thanks in advance

[Josh_Good]

I don't believe it is possible.  Have you considered Document chaining?  (See my post above on March 4 2013)

[#4]

Hi,

How about if there is no ListBox in the target document for the field or if it is a filter within Multibox?

Basically how can we select Multibox fields or any other fields which doesn't have LBox in target document?

Thanks

[Josh_Good]

I don't believe you can select on a mulitibox.  Try either use document chaining or create a listbox and hide it.

[#6]

Hi Josh,

I realize this is an old post and I'm hoping that this is still an active discussion.

In my case, I am trying to navigate to a different sheet within the same application by using the above logic. To this effect, I have activated the "HIDE TABROW" properties so that only a single sheet is shown at any given moment of time.

The challenge, is, I need to navigate to a different sheet from different URL's.

To this effect on one of my URL's my code reads..

http://myserver/QVAJAXfc/opendoc.htm?document=DocumentName.qvw&host=Local&select=SH18

(assuming that one of my sheets is SH18)

while on a second URL, my code reads the following.

http://myserver/QVAJAXfc/opendoc.htm?document=DocumentName.qvw&host=Local&select=SH19

(assuming that one of my other sheets is called SH19)

However, this does NOT seem to work as it always calls the sheet that was last displayed.

Can you pls let me know where I am erring and how to get about resolving this issue.

We are on V 11.20.11643.0

[Josh_Good]

Hi Rajsekhar,

I wouldn't recommend using this technique if you are wanting to change sheets within the same document.  If you have the tab row hidden then I would recommend you conditionally show and hide the sheets to move between sheets.  Luckily, I happen to have a video on that too.  Show and Hide Tabs

-Josh

[#8]

Hi Josh,

Is it possible to use document chaining when using both Section Access and Loop and Reduce?

I'm working with large data volumes, which is why we initially implemented LR. Now we would like to chain two applications together, but both will be using LR.

I was looking at the URL solution so I can pass in parameters to navigate to different sheets. But I'm not sure if this can be done with LR apps.

Any advice?

-CT

[#9]

there is nothing wrong if you use section access or loop and reduce

it will work as long as similar fields and their values kept in both documents it should work

[#10]

Let me give you an example. I have App1 with customer data & App2 with sales data. I perform loop and reduce on both apps to divide the original app by region: North, South, East, West. I want to chain the App1_North to the App2_North; App1_South to App2_South, etc.

I would like to use 'open URL' action because I pass sheet parameters into the URL to control tab navigation.

What I am not sure about is how to save the action in the original app which is used to perform loop and reduce, to yield navigation between only the specific regions.

Is this even possible to do in document chaining (URL action or Open Doc action)?

Thanks for your input!

[#11]

I have answered my own question, however if there is a more efficient way to achieve this, I would gladly accept the input.

Solution: In the 'Open URL' action use a nested if statement example:

if([LoopReduce Field]='NORTH', 'http://[myserver]/QvAJAXZfc/opendoc.htm?document=AccessPoint%2APP1_NORTH.qvw&host=Local&sheet=SH02',

      if([LoopReduce Field]='SOUTH', 'http://[myserver]/QvAJAXZfc/opendoc.htm?document=AccessPoint%2APP1_SOUTH.qvw&host=Local&sheet=SH02',

          if([LoopReduce Field]='EAST', 'http://[myserver]/QvAJAXZfc/opendoc.htm?document=AccessPoint%2APP1_EAST.qvw&host=Local&sheet=SH02',

              if([LoopReduce Field]='WEST', 'http://[myserver]/QvAJAXZfc/opendoc.htm?document=AccessPoint%2APP1_WEST.qvw&host=Local&sheet=SH02',

)))