We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

Content block (interactive filter)

Not applicable

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