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.
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:
-
Add an action
-
Set the action type to “Run Query”
-
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
027f3462-2f80-1cab-d100-940a140170a9
run javascript
{ "creationDate": "Tue, 16 Nov 2021 17:28:40 GMT",
"lastUpdateDate": "Tue, 16 Nov 2021 17:43:11 GMT", "tags": []
}
{ "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 // javascript
goes 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 }
I hope this is helpful for you.
Kind regards,
Leah