How set filters form the external website

[Saurabh Dixit]

How we use Filtering function form external website Javascript.

 

https://docs.tibco.com/pub/sfire_dev/area/doc/api/TIB_sfire_Web_Player_J...!

[Rayees Wani]

This may be implemented when you are loading the web player analysis using the Web player javaScript API as documented below:

https://community.spotfire.com/wiki/tibco-spotfire-javascript-api-overview

Example implementation:

function SetFiltersTest() {

 

var filterVal = ["ABW"];

//alert(filterVal);

 

var filterColumns = new Array();

filterColumns[0] = {

 

filteringSchemeName: "Filtering scheme",

 

dataTableName: "World Bank Data",

 

dataColumnName: "Country Code",

 

//filteringOperation: spotfire.webPlayer.filteringOperation.ADD,

 

filterSettings: {

 

values: filterVal,

 

includeEmpty: false

}

}

filterColumns[1] = {

 

filteringSchemeName: "Filtering example",

 

dataTableName: "World Bank Data",

 

dataColumnName: "Country Name",

 

filterSettings: {

 

includeEmpty: false,

 

values: ["Angola"]

}

}

 

 

alert("SetFiltersTest !!");

_analysisDocument.filtering.setFilters(filterColumns, spotfire.webPlayer.filteringOperation.REPLACE);

 

}

[Tyger Guzman 2]

How I this done with date range filters I've tried setting the highValue and lowValue with date() or "12/31/1999" and cannot get date ranges to be set.

[Tyger Guzman 2]

I've tried using the same method to set the range on a date range filter but doesn't seem to be working. Any suggestions 

 

    function SetFilterValues1() {
                                   var filterColumns = new Array();
                                   filterColumns[0] = {
                                       filteringSchemeName: 'Filtering scheme',
                                       dataTableName: 'CustomQuery',
                                       dataColumnName: 'DB_LoadDate',
                                       filterSettings: {

                                           highValue:'12/03/2019',
                                           lowValue: '12/05/2019'


                                       },
                                       filterType: 3
                                   }
                                 //console.log(mysel);
                                 console.log(filterColumns)
                                       viewOne0.filtering.setFilters(filterColumns,2);
                                       console.log('test2');
                               }