Content block (interactive filter)
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-24-2024 06:10 AM
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