Parameters Button Not Fully Functioning

[Bart A. Lewin]

Good Day!
Allow me to start with a compliment. I have successfully used ART for a number of years now, and find it a very well conceived product brilliantly implemented.

I have recently upgraded to version 6.22, and have found that the Parameters button no longer seems to function properly. When clicking on the down arrow on the button, I no longer get the options to save and or clear parameters; the parameters simply become invisible. Please see the attached screen snips. Any hints?

Many thanks for your attention to this.

[Timothy Anyona]

Which version were you upgrading from?

[Bart A. Lewin]

We went from Ver 5.14 to 6.22; performing the updates to 5.26, 6.0 along the way, @tanyona.

[Timothy Anyona]

I believe the save/clear parameters option was removed in 5.24. I guess it could be returned as an option in a future release. In the meantime you can use the Clone button/option to create a new report with saved parameter selection.

[Bart A. Lewin]

I will give cloning the report a try in V6.22 and report back to you, @tanyona.

In the meantime, there is a table in ART_db called ART_db.ART_SAVED_PARAMETERS; with this specification:

CREATE TABLE IF NOT EXISTS `ART_SAVED_PARAMETERS` (
  `USER_ID` int(11) NOT NULL,
  `REPORT_ID` int(11) NOT NULL,
  `PARAM_NAME` varchar(60) NOT NULL,
  `PARAM_VALUE` varchar(4000) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

It currently contains records, and for those that did save parameters at one time, the saved parameters are apparently read from that table and override the default values specified for the parameter. Is it safe to empty ART_SAVED_PARAMETERS to remove the saved parameters?

Thank you again, sir, for your assistance.

[Timothy Anyona]

Yes, the saved_parameters table can be cleared to clear saved parameter values.

[Bart A. Lewin]

@tanyona, I cloned the reports as you suggested and found it did not affect the report's operation at all--the Parameters button behaved the same as on the original report. I also checked your online demo, and the parameter button behaves the same way there. It looks like the save and clear parameters feature has been removed. This is fine for, my use cases. I suggest only removing the down arrow from the button label to reduce confusion.

I also emptied the ART_SAVED_PARAMETERS tables, and the reports work well for all users with the parameters defaulting to the values specified. So, I now consider my issue resolved. Thank you very much for your timely responses.

[Timothy Anyona]

The just released 7.3 version has an allowSaveSelectedParameters option that can be set in the Settings Options to reinstate the save/clear parameters feature.

[Bart A. Lewin]

Brilliant. Thank you, sir.