Content block (interactive filter)

Andrew_TND
Mega Sage
Mega Sage

Hi all,

I want to filter on both Number and u_workstream reference using this content block, however I can either do one or the other it wont seem to look at both. Any ideas?

<?xml version="1.0" encoding="utf-8" ?>
<j:jelly trim="false" xmlns:j="jelly:core" xmlns:g="glide" xmlns:j2="null" xmlns:g2="null">
	
 <script>
	 
     var my_dashboardMessageHandler = new DashboardMessageHandler("FilterNumber");
    
    function publishFilter (searchTerm) {
        var filter_message = {};
        filter_message.id = "FilterNumber";
        filter_message.table = "pm_project";
	 
	 if (searchTerm == ""){
	 clearFilter();
	 } 
	 else {
	 filter_message.filter = "numberSTARTSWITH"+ searchTerm+" OR u_workstream_referenceSTARTSWITH" + searchTerm;
	 }
        SNC.canvas.interactiveFilters.setDefaultValue({
                id: filter_message.id,
                filters: [filter_message]
            }, false);
        my_dashboardMessageHandler.publishFilter(filter_message.table, filter_message.filter);
    }
    
    function clearFilter() {
        var filter_message = {};
        filter_message.id = "FilterNumber";
        filter_message.table = "pm_project";
        filter_message.filter = "";
        SNC.canvas.interactiveFilters.setDefaultValue({
                id: filter_message.id,
                filters: [filter_message]
            }, false);
        my_dashboardMessageHandler.removeFilter();
    }
 </script>   
	
            <input id="searchTerm" type="text" class="form-control" value="" onchange="publishFilter(this.value);"></input>
   
</j:jelly>
0 REPLIES 0