Error while generating report when applied filter with like condition for Mongo Db

Adhoc
#1

I have created one report in Helical Insight with Mongo DB as datasource, while applying the filter with like condition i am getting error.

Error: AssertionError: cannot translate LIKE(CAST(ITEM($0, ‘_id’)):VARCHAR(20) CHARACTER SET “ISO-8859-1” COLLATE “ISO-8859-1$en_US$primary”, ‘bxp%’)

Here i have added one filter on one column and i want to filter data to get result data starting with “bxp”.

#2

Hi Shailaja,

Note: This solution is applicable for Helical Insight V1.0.0

In Helical Insight we are using apache calcite adapter with mongo db for generating the queries, and calcite doesn’t provide “like” operator to generate queries.

To solve your problem , you can use operators like < , >, <=, >= with which you can filter your data.

In this case you have to apply two filters on same column.

  1. one with one with custom condition as >= and Value as bxp

Please refer image below:

2.Second with custom condition as <= and Value as bxp

Please refer the image below:

Now click on the generate button to generate report.

This will solve your problem.

Regards,
Helical Insight Team