Add an interactive filter based on a field from a referenced table

[adilbelahbib]

Hey,

I have created a report on the alm_asset table (a Multilevel Pivot report). the report show the different quantities of assets by product model and by stockroom.

by default, I have as filters the different fields that I chose as rows/columns, but now I need to add some other filters such as product model status.

I found that I can use Interactive filters to add customized filters, but all I can do is to choose a table and a field from that same table, and not from a referenced field (Asset.Product_model.status).

Any ideas how can I filter assets based on a field that exists in the referenced table 'Product Model' ?

Thank you !

[brian_quinn · Accepted solution]

Adil,

I'm sorry I missed that you were trying to use interactive filters.   In your case you may have to build a custom interactive filter.

Custom interactive filter example

Here is a simple example (modified from the example linked about) to toggle all assets and just in production assets:

<?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");
</script>
Example of a filter for alm_asset.model.status = In Production
<input id="allAssets" type="button" value="All Assets" onclick="my_dashboardMessageHandler.removeFilter();" />
<input id="prodAssets" type="button" value="Only In Production Assets" onclick="my_dashboardMessageHandler.publishFilter('alm_asset','model.status=In Production');" />
</j:jelly>

Thanks

Brian