-
KX Dashboard – Data Grid – Actions – Is it possible to call Java script code with selected value?
When I double click / click on a data grid I am able to trigger open URL. Is it possible to call Java script code with selected value from the data grid?
I am trying to pass the selected value from the data grid to an external application.
-
1 Reply
-
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
Log in to reply.