Interactive Filter On Asset table

[Nikitha A1]

Hi,

I want to create interactive filter to search asset tag and report should get updated simultaneously.

but there was an error while creating interactive filter on reference table alm_asset

error: Reference field is not type of "alm_asset"

can someone please suggest how to achieve this.

Thanks,

Nikitha

[Mohith Devatte]

hello @Nikitha A ,

on which table you configured your interactive filter ?

also can you please send a screenshot of the interactive filter 

[Nikitha A1]

alm_asset table.

please find the attached screen shot of error.

[Mohith Devatte]

You have to do it other way around @Nikitha A ,

Configure the  interactive filter on user table which is sys_user and then in the interactive filter reference let it be alm_Asset and assigned to field 

Reason being that assigned to is referring to user table so your interactive filter must be on user table and the interactive filter reference record must be on alm_asset table with field as assigned to 

Hope this helps 

please mark my answer correct if this helps you

[Nikitha A1]

Hi Mohith,

I have created cascade filter, on alm_asset table based on the interactive filter the report data is not filtering. However its refreshing.