Dashboard filter date format in JAQL | Help and How-To

pswami · 2024-09-22T23:58:39.831000Z

I'm looking for two scenario1. Sort default data filter desc2. in JAQL object to set date filter to 'days', the following script is used and need your help on set date format to 'days' and sort to descending order...Help and How-ToCurrent: without date only format Expect like this - date format and need descending ( max date first) attached the script and if any one suggest to add date format ("level": "days") and filter default display date descending order.... widget.on('initialized', function () { function runHTTP(jaql) { // Use $internalHttp service if exists const $internalHttp = prism.$injector.has("base.factories.internalHttp") ? prism.$injector.get("base.factories.internalHttp") : null; const ajaxConfig = { url: "/api/datasources/" + encodeURIComponent(jaql.datasource.title) + "/jaql", method: "POST", data: JSON.stringify(jaql), contentType: "application/json", dataType: "json", async: false, // Needed for WAT authentication xhrFields: { withCredentials: true } }; const httpPromise = $internalHttp ? $internalHttp(ajaxConfig, false) : $.ajax(ajaxConfig); // Return response return httpPromise; } function generateJAQL(datasourceTitle, dimension, sortOrder) { jaqlObj = { "datasource": { "title": datasourceTitle, }, "metadata": [ { "jaql": { "dim": dimension, "sort": sortOrder } } ], "offset": 0, "count": 1 } return jaqlObj; } //prism.activeDashboard.filters.clear(); //Clears current filters //alert('Dashboard filters cleared'); prism.activeDashboard.defaultFilters.forEach(function (filter, index) { //Loop through each default filter and apply to current dashboard filters if (index != prism.activeDashboard.defaultFilters.length - 1) { //Does not refresh filter if it is not the last filter //alert(index); prism.activeDashboard.filters.update(filter, { save: false, refresh: false, unionIfSameDimensionAndSameType: true }); } else {//Only refresh dashboard on the last filter // alert('last one'); prism.activeDashboard.filters.update(filter, { save: false, refresh: true, unionIfSameDimensionAndSameType: true }); } }) runHTTP(generateJAQL("smodel", "[Date_filter.date_list]", "desc")).then((API_Response) => { const filterObject = prism.activeDashboard.filters.item("[Date_filter.date_list]"); let firstValue = API_Response.data.values[0][0].data; filterObject.jaql.filter = { "explicit": true, "multiSelection": true,"members": [// default select first (max) date firstValue ] } var dashboardRefreshedAfterFilter = false; if (dashboardRefreshedAfterFilter == false) { dashboard.refresh() } var dashboardRefreshedAfterFilter = true; }); })

MoreDiscussions

Dashboard filter date format in JAQL | Help and How-To | Sisense Community