topic Re: Data Driven content with parameters in SAS Visual Analytics

Data Driven content with parameters

acordes — Tue, 02 Jun 2020 06:50:06 GMT

I just tried to implement some DDC out-of-box solutions posted at the github page.

With most of them I succeed but one is resisting my efforts.

https://github.com/sassoftware/sas-visualanalytics-thirdpartyvisualizations/blob/master/samples/dataUpdate.html

@Renato_sas , can you see at first glance what I am missing out?

Because the array looks fine what is retrieved from the DDC object in VA.

{
    "version": "1",
    "resultName": "dd264",
    "rowCount": 4,
    "availableRowCount": 4,
    "data": [
        [
            "A150"
        ],
        [
            "A366"
        ],
        [
            "A77"
        ],
        [
            "A78"
        ]
    ],
    "columns": [
        {
            "name": "bi265",
            "label": "obs",
            "type": "string"
        }
    ],
    "parameters": [
        {
            "name": "pr50",
            "label": "caslib",
            "dataType": "string",
            "value": "DNA"
        },
        {
            "name": "pr51",
            "label": "castab",
            "dataType": "string",
            "value": "RYAN2"
        },
        {
            "name": "pr52",
            "label": "target_column_name",
            "dataType": "string",
            "value": "MODELO"
        },
        {
            "name": "pr53",
            "label": "id_column_name",
            "dataType": "string",
            "value": "obs"
        },
        {
            "name": "pr68",
            "label": "target_column_type",
            "dataType": "string",
            "value": "$50."
        }
    ]
}

Re: Data Driven content with parameters

Renato_sas — Tue, 02 Jun 2020 18:34:57 GMT

Based on your first screenshot, it seems that you are not passing the required parameters in the data-driven content URL. It should be something like this:

http://your.host.server/github/samples/dataUpdate.html?caslib=<your-cas-library>&castab=<your-table>&target_column_name=<column-to-be-updated-with-user-input>&target_column_type=<string-or-number>&id_column_name=<the-unique-id-column>

You must also set a link action from the list table at the top to the data-driven content object, so it will flag/select the desired row to be changed.

Re: Data Driven content with parameters

Renato_sas — Tue, 02 Jun 2020 18:37:52 GMT

I think this is easier to read:

http://m-sbrrzl-gerghe.gtp-americas.sashq-d.openstack.sas.com/github/samples/dataUpdate.html?caslib=public&castab=hmeq&target_column_name=reason&target_column_type=string&id_column_name=_id

Re: Data Driven content with parameters

acordes — Wed, 03 Jun 2020 15:03:15 GMT

Thanks Renato.

Applying your parameter passing technique via URL and selecting only one row in the list table that performs a linked action on the DDC object, I don't get any longer the error message.

I can write to the text box but after pushing the bottom nothing happens.

I suppose that I cannot perform this kind of table update coming from outside as I put the link from the github page.

I had tried to host your code as job execution wrapping it in a data _null_ statement and put ' ' statements. Shouldn't it work like this?

Regarding the way I tried to send the parameters I followed your post

https://communities.sas.com/t5/SAS-Communities-Library/Using-parameters-with-Data-Driven-Content-in-SAS-Visual/ta-p/609557

I suppose it didn't work because the name of these parameters is like "pr52" and only the label matches the parameters your code requires.

Re: Data Driven content with parameters

Renato_sas — Wed, 03 Jun 2020 16:38:11 GMT

I don't think this is an issue. Do you see any error messages related to this DDC in your browser's devtools (Ctrl+Shift+I)?

Re: Data Driven content with parameters

acordes — Wed, 03 Jun 2020 17:23:13 GMT

the error message calling from a browser window is:

And should I pass "string" for the format parameter or "$30." alike?

id_column_name=obs dataUpdate.html:73:12

TypeError: jq is undefinedcasUtil.js:25:3

getCasServerName https://sassoftware.github.io/sas-visualanalytics-thirdpartyvisualizations/util/casUtil.js:25

startCasSession https://sassoftware.github.io/sas-visualanalytics-thirdpartyvisualizations/util/casUtil.js:88

<anonymous> https://sassoftware.github.io/sas-visualanalytics-thirdpartyvisualizations/samples/dataUpdate.html?caslib=dna&castab=ryan2&target_column_name=MODELO&target_column_type=string&id_column_name=obs:160

Re: Data Driven content with parameters

Renato_sas — Thu, 04 Jun 2020 01:09:21 GMT

I'm not sure I understand this error. If I interpreted it correctly, it's saying jq is not defined, but it would only happen if the DDC URL is called directly from the browser, instead of being embedded in a VA report.

What format parameter are you asking about? If it's target_column_type, it accepts those values: string/number/date/datetime/time