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

[Josh_Good]

I think you could simplify you expression by using the LoopReduce Field in your URL like this:

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

[renuka_sasikumar]

Hi,

I have to link one application to another application but to a selected sheet only.

For eg. I have application1 where the sheets are Home, Dashboard, Analytic, Report and the application2 same I have like Home, Dashboard, Analytic(SH06), Report.

So when I click on Analytic of Application1 it should show the sheet of Application2 Analytic.

I have added this URL ::: http://myserver/QvAJAXZfc/opendoc.htm?document=DocumentName.qvw&host=Local&sheeet=SH06

But when clicked on Analytic of Application1 it shows Dashboard of Application2 instead of Analytic.

So I am not able to understand where the mistake is?

How do I go about it.

[#4]

Hi Josh,

The technique that you had applied is good when we try to navigate to different sheets when one is already within the QV application.

In our case, we are trying to get the application to work when we navigate to the application from a External link. Since we have license for just one application, to be displayed on IAS on we are trying to navigate to a specific page/sheet on the same application, depending on which link the user is using...

For Eg ; Using Link 1 on a web page that will take use to SHEET02

and

Using Link 2 on a diff web page should take us to SHEET04.

In fact your first post where you modify the URL and make it to load the default List Box ( on a sheet ) is just what we need, except for the fact that instead of using a LB we are using a SH (Sheet) and no matter whatever SHEET ID I try while testing, it just always opens the default page.

P.S : I do not have any triggers within the application that takes us to the default page.

Pls let us know if there is a way to get around this.

In the example that Caitlin proposes, I see that she is navigating to a different application each time, using the LOOP method. In our case, it needs to use the same application, but different sheet/page.

Thanks

Raj

[Josh_Good]

I don't believe you can use the URL to direct to a specific sheet.  However you could show and hide sheets based on selections so you could have Link1 make a selection on a data island have have that selection drive which sheet is shown.  See Show and Hide Tabs for more info on how to show and hide sheets (aka tabs).

[Josh_Good]

As I stated in my previous post, I don't think that is possible.  The ...&sheet=SH06 is not valid.

[#7]

I have used '&sheet=SH02' to navigate which sheet the application opens up to.

I would check to make sure that you are picking the correct sheet id. Then in your post above you have an extra e in sheet, so I would fix the typo and then retry.

[renuka_sasikumar]

Hi,

My mistake I mentioned here as Sheeet but in my URL it is Sheet.

[#9]

Hello Friends,

Even I was searching this type of eg

Thanks

SD

[amien]

Hi Josh,

The data island and transfer state is a nice solution, but what is the trigger action to be used to active the correct sheet on the returning document? onOpen not right? What trigger action can be used?

[Josh_Good]

I was thinking you wouldn't need an action to change to the correct sheet because the selection on the data island would cause the correct sheet to be the only sheet that is conditionally shown.  Here is a simple example with four sheets that change which sheet is shown based on the listbox selection.