Dynamic parameter

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.

Open

Many thanks for your help Adrien

Hi Satya and Nick,

I have just published https://playsql.atlassian.net/browse/PLAYSQL-292#icft=PLAYSQL-292 (version Play SQL Base 3.1.10) which allows you to use ?user-parameter-param1=... to set the value of $param1.

Best regards,
Adrien

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

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

Hello Adrien,

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