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

[jagannalla]

Josh,

It is working now. But I want to stop displaying all values of product in URL.

Say for example

Select=LB01,A1,A2,A3,A4,A5,,,,,,,,,,,,,,,,A100

Is it possible?

Thanks,

jagan

[Josh_Good]

Hi Jagan,

Can you please share how you resolve the issue so if someone else has the same problem they will know what to do.

If do not want to show the list then you could activate a bookmark in the target document.  This will make your selection set fix thought.  Your other option would be to use the Open Document action and transfer the state. The details on both of these is covered above.

Regards,

Josh

[#4]

Hi Josh,

Do u know how to show the parameters DIRECTLY on Url ? Because I need to catch the parameters  via url to do another program.

For example, when I  select productID='AA01' in a listbox, then the url could show  http://myserver//QvAJAXZfc/opendoc.htm?document=DocumentName.qvw&host=Local&select=LB01,"AA01"

Furthermore, If I could select many parameters(ex,productid,year,month,....) and ALL show on URL is better!!

Could it possible? please help!

Thanks a lot

Regards,

Nina

[Josh_Good]

Hi Nina,

As far as I know it is not possible to have the URL change as selections are made in the app.

-Josh

[#6]

Hi, How did you fix the problem with the selection? I have a URL that has product_id where product_id is a number. If I do select=LB18,1 I'm getting all products that have a 1 (1, 10, 11, 110, etc.)

Any ideas?

[Josh_Good]

You need to use this style of notation (value|value). So you your case it would be:

select=LB18,(1)

or

select=LB18,(1|15|35) would select 1, 15, 35 only.

[#8]

Thanks Josh!!!

[ChristofSchwarz]

Hi Josh. Cool explanation. Can you also pass a variable value in the querystring?

Together with QV11.2 SR4 the surprising behaviour of the "select=LBxx" has changed a bit. There shouldn't be multiple selections any more. The best syntax I have seen and tested so far is the one mentioned by you:

select=LBxx,(value1|value2|valuex)

Only a few things to mention: if the value in this list contains a space or a comma, you have to replace it with '?'. Sideeffect: This syntax allows to pass also '*' wildcards, for example

select=LBxx,(*)  will select all

select=LBxx,(Josh*)  will select all starting with Josh

select=LBxx,(*Good*|*Bad*)  will select containing either Good or Bad

isn't this cool? I have created a URL composer which should make it easier for mortals to compute a valid querystring here: URL Composer = compute an Access-Point link and pass selection values, open sheets etc.

[bill_mtc]

Wow! Great tips. I'm looking for this a year ago.

[Josh_Good]

Thanks for the additional info Christof.