Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

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