Columns filters are not working for decimal data values in Grid chart


If a Grid widget that uses JDBC connector displays fractional data, then you cannot filter such data by using Equals filter condition in the Grid column filters.

Resolving the problem

To work around this issue, you must apply CAST function to the column that contains decimal data in the JDBC query.
JDBC query format example:
SELECT <column1>, CAST(<column2> AS DOUBLE) as <column2> from <table_name>
JDBC query example:
SELECT "System_Name", CAST("Size_GB_Decimal" AS DOUBLE) as Size_GB_Decimal from "ABCUSER"