Custom Interactive Filter (Dynamic Content Block) - What needs to be configured to work with a Database view

[Glen3]

I'm trying to create a Custom Interactive Filter for a dashboard that filters against a database view. Out of Box Interactive filter works against the database view because you have an option to check the 'Apply to both database views and tables' check box. Also you can use extended tables with the 'Apply to all tables in hierarchy' check box checked.
When I debug the filter for the Out of Box Interactive filter and the Custom Interactive Filter (Dynamic Content Block), I get this.

[[{"filter":"cont_active=true","allow_database_view_filter":true,"allow_extended_table":true,"table":"u_csm_contact_team_member_join"}],[{"id":"my_unique_id8602","table":"u_csm_contact_team_member_join","filter":"u_csm_contact_team_member_join.name=AIO"}]]

I need the custom filter to query as.
{"id":"my_unique_id8602","table":"u_csm_contact_team_member_join","filter":"u_csm_contact_team_member_join.name=AIO","allow_database_view_filter":true,"allow_extended_table":true}

Does anyone know how to get a Dynamic Content Block to work with database views and extended tables?
Thanks,
Glen

[AvinashDevadass · Accepted solution]

Hi use publishMessage() instead of publishFilter()

var filtermessage = [{"table":"u_csm_contact_team_member_join","filter":"u_csm_contact_team_member_join.name=AIO","allow_extended_table":true,"allow_database_view_filter":true}]

SNC.canvas.interactiveFilters.setDefaultValue({
id: filter_message.id,
filters: filtermessage,
}, false);
my_dashboardMessageHandler.publishMessage(filtermessage);

my_dashboardMessageHandler.publishMessage(filtermessage);

Regards

Avinash Devadass

Let me know if it works

[Glen3]

Thanks Avinash, problem solved.