Hey everyone!
I had a really hard time finding any useful material on this topic as most of the links are dead.
The requirement I got from a user was that they should be able to filter their reports on their dashboards by the Short Description of the task.
I ended up creating a dynamic content block to act as an interactive filter. I hope somebody in the future finds this useful!
<?xml version="1.0" encoding="utf-8" ?>
<j:jelly trim="false" xmlns:j="jelly:core" xmlns:g="glide" xmlns:j2="null" xmlns:g2="null">
<style>
</style>
<script>
var my_dashboardMessageHandler = new DashboardMessageHandler("FilterShortDescription");
function publishFilter (searchTerm) {
var filter_message = {};
filter_message.id = "FilterShortDescription";
filter_message.table = "task";
if (searchTerm == ""){
clearFilter();
}
else {
filter_message.filter = "short_descriptionSTARTSWITH"+ 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 = "FilterShortDescription";
filter_message.table = "task";
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>
My end result looked something like this:
Ps.: I removed some parts of the sample script compared to what you can see on the screenshot. The sample script will only work with STARTSWITH search - so it should only act as a base which you can build upon.
You can add a couple of if conditions to make it "smarter", you may add your own CSS and HTML to the content block to make it work better with your own requirement.
Have a nice day!
