SAS VA - load List Control with a pre-selected value

DipuRahman — Thu, 07 Dec 2023 19:55:16 GMT

Hi All,

We have a requirement for VA reports to be rerun at a later time that will "remember" and load the previously selected value(s) from the user (based on some unique ID). What does that mean?

For example, there is a report that the user selects a car's make and model, and enters an unique ID for that report. Based on that selection, the report will be run. In this example,

Report ID: 123

Make: Acura

Model: 3 models selected as shown below.

This runs the report and creates outputs. In addition, it updates a table in CAS:

Request from the users:

The report also has a different section where the users can select a Report ID from the past:

And auto populate the previous selection.

So this is where I'm not sure what to do. If the user selects 123 for Report ID, I want the Make List control object to automatically select Acura, and the Model List control to automatically select the three Models (selected the first time):

Reason for request: If they want to go back to rerun a report that had 50 models selected, and this time not have to manually select 50 models again (or select 48 models from the original list). This will help reduce the selection time.

Is there anyway to use that CAS table with user selected values to do this?

Any input is appreciated!

Thanks!

Using SAS® Visual Analytics. Release: 8.5.2,

SAS® Viya® release: V.03.05

Re: SAS VA - load List Control with a pre-selected value

Renato_sas — Fri, 08 Dec 2023 21:16:39 GMT

This is not possible with default VA control objects, but a DDC that implements an HTML form could be used to do it.

The DDC HTML would need to leverage CAS REST API to query the CAS table containing the desired report ID and pull the parameter settings from that report, supposedly stored in that CAS table. Because the custom HTML provides the prompts, you have the ability to manipulate them via JavaScript to pre-set the prompt values according to what had been saved.

I'm not saying it's simple, but it's definitely doable.

topic Re: SAS VA - load List Control with a pre-selected value in SAS Visual Analytics

SAS VA - load List Control with a pre-selected value

Re: SAS VA - load List Control with a pre-selected value