Dynamic parameter

Description

Hello Support,
I have a PLAY SQL query page that is working well. It accepts a parameter which is entered through a PLAY SQL form that is displayed in-line.

I would like to pass a parameter to the page from the URL e.g.
/display/TM/R03.01+%3A+Team+Report?srch1=nick

is this possible?

Environment

None

Observations

None

Activity

Show:
Nick McEwen
June 9, 2020, 6:44 AM
Edited

Confirmed working in latest release
e.g. report?user-parameter-team=tt1002&user-parameter-todate=2020-12-31

 

Note: this will work ONLY if the RICH display form is used and the option to display a form is selected
e.g.



Many thanks for your help Adrien

Adrien Ragot (Play SQL / Requirement Yogi)
June 3, 2020, 3:18 PM

Hi Satya and Nick,

I have just published (version Play SQL Base 3.1.10) which allows you to use ?user-parameter-param1=... to set the value of $param1.

Best regards,
Adrien

Adrien Ragot (Play SQL / Requirement Yogi)
June 3, 2020, 2:19 PM

Hi Satya,

You're right, it didn't take the URL parameter. When I publish the version where I'll fix this, the user parameters will be read as follows:

  • The default value defined in the query editor,

  • The value defined at the level of the macro (it is possible to override it),

  • The value defined in the URL, ...&user-parameter-param1=...

  • The value defined by the user on the page.

I'll tell you when I publish this fix. There is nothing else you can try for the moment.

Best regards,
Adrien

Nick McEwen
June 2, 2020, 9:07 AM

… can you suggest any other things that I might try Adrien?

Satya Inteti
May 29, 2020, 1:45 PM

Hello Adrien,

Is there any suggestion or help on my last query? thank you

Resolved

Assignee

Unassigned

Reporter

Satya Inteti

Labels

None

Participants

None

Fix versions

Priority

Matter of months