-
Hello RV,
Reverting with feedback for you.
Please find attached the JPG File with a demo on how to do this.
In your data grid:
1. Add an action
2. Set the action type to “Run Query”
3. Set the Datasource property, set the query editor, set the type to “Virtual” and set the 1st parameter as a viewstate.
And here is the javascript.xml
<ui><name>027f3462-2f80-1cab-d100-940a140170a9</name><displayname>run javascript</displayname><description>{ “creationDate”: “Tue, 16 Nov 2021 17:28:40 GMT”,“lastUpdateDate”: “Tue, 16 Nov 2021 17:43:11 GMT”, “tags”: []}</description><data>{ “id”: “027f3462-2f80-1cab-d100-940a140170a9”, “name”:“run javascript”, “creationDate”: “Tue, 16 Nov 2021 17:28:40 GMT”,“lastUpdateDate”: “Tue, 16 Nov 2021 17:43:11 GMT”, “thumb”: null,“screenDetails”: [ { “label”: “Screen 1”, “value”:“c6f806d4-7510-0675-d8cf-c29aa2545da2” } ], “screens”: [ { “id”:“c6f806d4-7510-0675-d8cf-c29aa2545da2”, “name”: “Screen 1”, “thumb”:null, “widgets”: [ { “id”: “c027a14d-3a3c-a89c-9d17-5edeb9d45ef5”,“layout”: { “row”: 0, “column”: 0, “rowSpan”: 21, “colSpan”: 19 },“component”: { “id”: “55bf3782-28a5-65ee-c3f5-dca3a5fbdd18”, “key”:“Datagrid”, “options”: { “version”: “4.7.0”, “datagridPossibleColumns”:[ “id”, “col1”, “col2” ], “datagridPossibleColumnsWithItself”: [“<this>”, “id”, “col1”, “col2” ], “selectedColumnPossibleValues”:[ “id”, “col1”, “col2” ], “highlightTargetPossibleValues”: [ “id”,“col1”, “col2”, “*” ], “sortingPossibleValues”: [ “”, “id”, “col1”,“col2” ], “Basics”: { “Data”: { “_dashboardsType”: “data”, “value”:“data” } }, “ColumnsConfiguration”: [ { “Field”: “id”, “DisplayName”:“id”, “Format”: “Formatted Number”, “Precision”: 0, “WidthWeight”: 165,“MinWidthAbsolute”: 165, “TextAlign”: “right” }, { “Field”: “col1”,“DisplayName”: “col1”, “Format”: “Formatted Number”, “Precision”: 0,“WidthWeight”: 165, “MinWidthAbsolute”: 165, “TextAlign”: “right” }, {“Field”: “col2”, “DisplayName”: “col2”, “Format”: “Formatted Number”,“Precision”: 0, “WidthWeight”: 165, “MinWidthAbsolute”: 165,“TextAlign”: “right” } ], “Selection”: { “RowSelectionColumn”: “id”,“Actions”: { “0”: { “DataSource”: { “_dashboardsType”: “data”, “value”:“runQuery” }, “_Type”: “query”, “TriggerColumn”: “*”, “Trigger”: “Click”} }, “Mode”: “Single Row”, “SelectedValue”: { “_dashboardsType”:“viewstate”, “value”: “selected” } }, “Alignment”: { “paddingLeft”: 0,“paddingRight”: 0, “paddingTop”: 0, “paddingBottom”: 0,“innerPaddingLeft”: 0, “innerPaddingRight”: 0, “innerPaddingTop”: 0,“innerPaddingBottom”: 0, “titlePaddingLeft”: 0, “titlePaddingRight”: 0}, “format”: { “tileBorderWidth”: 0, “tileBorderRounding”: 0,“tileBorderColor”: “#000000”, “tileBackgroundColor”: “#000000”,“tileTransparentBackground”: true, “tileShadow”: false } },“containerId”: null, “components”: [], “widgets”: [], “definitionId”:“21”, “hasOnSettingsChange”: true } } ], “relativeHeight”: true,“rowCount”: 24, “rowHeight”: 25, “colCount”: 36, “floatable”: true,“isDefault”: true } ], “popups”: [], “tags”: [], “dashboardTheme”:“Dark”, “themeSwitchable”: true, “saveTimestamp”: null,“relativeHeight”: true, “rowCount”: 24, “rowHeight”: 25, “colCount”: 36,“floatable”: true, “viewState”: { “selected”: { “_viewType”: true,“_default”: “”, “_type”: “symbol” }, “.settings”: {} }, “data”: {“data”: { “_pagingType”: “NONE”, “_autoExecute”: true, “_autoExec”:true, “_columns”: [ “id”, “col1”, “col2” ], “_dataType”: “query”,“_dataSource”: “kdb”, “_connection”: “html5evalcongroup”, “_mappings”: {“key”: “id”, “mappings”: {}, “value”: “col1” }, “_maxRows”: 2000,“_subscriptionType”: “static”, “_subscriptionInterval”: 3, “_layout”: [{ “isExpanded”: true, “weight”: 2 }, { “isExpanded”: false, “weight”: 1}, { “isExpanded”: false, “weight”: 1 }, { “isExpanded”: true, “weight”:1 }, { “isExpanded”: true, “weight”: 2 } ], “_queryString”:“([]rn id:1 + 1 * til 20;rn col1:20?10;rn col2:20?10)”, “_queryParams”:[], “_subscriptionKey”: “”, “_hasUpdateQuery”: false,“_updateQueryParams”: [], “_updateQueryString”: “”, “_updateType”:“query”, “_pageSize”: 2000, “_serverPaging”: false }, “runQuery”: {“_autoExec”: true, “_autoExecute”: true, “_columns”: [], “_dataType”:“virtual”, “_dataSource”: “kdb”, “_connection”: “html5evalcongroup”,“_mappings”: {}, “_maxRows”: 2000, “_subscriptionType”: “static”,“_subscriptionInterval”: 3, “_layout”: [ { “isExpanded”: true, “weight”:2.5159010600706715 }, { “isExpanded”: false, “weight”: 1 }, {“isExpanded”: false, “weight”: 1 }, { “isExpanded”: true, “weight”: 0 },{ “isExpanded”: true, “weight”: 1.4840989399293287 } ],“_subscriptionKey”: “”, “_virtualParams”: [ { “name”: “viewstate”,“index”: 0, “type”: “viewstate”, “value”: “selected” } ],“_virtualQueryString”: “function (viewstate, callback) {nn // javascriptgoes heren // e.gn window.open(“https://www.google.com/search?q=”+viewstate,”_blank”);n callback({meta:{}, cols:[], rows:{}});nn}” } },“permissionEntity”: { “class”: “api.entity.PermissionEntity”,“permissions”: { “DeltaMonAdmin”: [ false, false ], “all”: [ false,false ], “PowerUser”: [ false, false ], “BSU”: [ false, false ],“ActionTrackerAdmins”: [ false, false ], “DeltaMonUsers”: [ false, false], “Analyst”: [ false, false ], “ActionTrackerUsers”: [ false, false ],“Administrators”: [ true, true ], “DashboardUsers”: [ false, false ],“BSUManagers”: [ false, false ], “DeltaDocGenRestrictions”: [ false,false ], “ReportAdminUserGroup”: [ false, false ] } },“worksheetPadding”: 10, “widgetsSpacing”: 0, “borderColor”: “000000”,“borderBackground”: “000000”, “transparentBackground”: true,“borderWidth”: 0, “borderRounding”: 0, “borderSpacing”: 0,“borderShadow”: false, “saveViewerState”: “enabled”,“enableShareDashboard”: false, “notifications”: null,“showLoadingIndicators”: true, “unsavedViewerPrompt”: false,“advancedCss”: “”, “cssClasses”: “”, “version”: “4.6.0P1”, “wasChanged”:false }</data></ui>I hope this is helpful for you.
Kind regards,
Leah