Filter not working

Hello Helical Insight,
We are using Helical Insight Enterprise Edition 4.0 GA. We created a report using MongoDB. Join is specified at the metadata level but the filters are not populating. Please help

Thank You,
Sesa.

Hello Sesa,

As we saw in the troubleshooting the filter data type should be int whereas it is present as a text. There is a type mismatch which is happening. That’s why it is not working.

There are 2 methods through which you can make it work

a. Using the DBfunction we have casted that specific column as an int and then used that as a filter. Thus the datatype is consistent with the DB and filtering works fine. Refer to below images to understand the sequence of the steps

image

image

b. The second option is since you have created all of these reports using view. Since you have created the view then there itself you can handle the casting.

Thank You,
Helical Insight.