Dinamyc content block as interctive filter fiel business department

Reporting Team — Sat, 04 May 2024 07:54:09 GMT

Hi Community,

I need a dinamyc content block that works as intercative filter using cmdb_ci_business_app.u_business_department.

I defined an script, butt it doens't work 😞

The script code is:

<?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("my_unique_id");

function publishFilter () {
var filter_message = {};
filter_message.id = "my_unique_id";
filter_message.table = "cmdb_ci_business_app";
var value = gel('cfBusiness Department').value;
filter_message.filter = "u_business_departmentLIKE" + value;
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 = "my_unique_id";
filter_message.table = "cmdb_ci_business_app";
filter_message.filter = "";
gel('cfBusiness Department').value = '';
SNC.canvas.interactiveFilters.setDefaultValue({
id: filter_message.id,
filters: [filter_message]
}, false);
my_dashboardMessageHandler.removeFilter();
}
</script>

Short Description:
<input id="cfBusiness Department" type="input" value="" /><br/>
<input id="removeCustomFilter" type="button" value="Clear" onclick="clearFilter();" />
<input id="addCustomFilter" type="button" value="Search" onclick="publishFilter();" />

</j:jelly>

But it doesn't work. I use a similar dinamyc content block to filter incident.short_description and it works! I cna't find my error with thisnew content block.

Any idea to help me?

Thanks in advance!!!

MEF

Re: Dinamyc content block as interctive filter fiel business department

Reporting Team — Tue, 07 May 2024 16:47:25 GMT

Hello again,

I continue working with dinamyc content block and I have realized that the problem is that I use a database view as a table.

If I use this dinamyc content block with a report that uses a table , it's working! but if I use a database view , the dinamic content block, Any idea to help us?

Thanks in advance,

MEF

question Dinamyc content block as interctive filter fiel business department in Community Central forum

Dinamyc content block as interctive filter fiel business department

Re: Dinamyc content block as interctive filter fiel business department