Knowledge Drop

Why does System Activity give the error data exception: invalid character value for cast`?

Userlevel 3

Last tested: Nov 16, 2017


The history explore in System Activity includes both User-Defined and LookML dashboards. Because of this, when filtering on a dashboard id, the generated SQL will convert the ID to a VARCHAR.

If you try to filter on a dashboard id within a custom filter, you might get the error message data exception: invalid character value for cast (if they are on a HyperSQL back-end). To get around this, change your custom filter to be:

concat(${history.dashboard_id},"") = "58"

This will cast the dashboard ID to a VARCHAR in the generated SQL and filter correctly.



This content is subject to limited support.                



0 replies

Be the first to reply!