Filter by time measure doesn't work

[Anger79]

Problem

I don't understand how to apply filter by time measure (timestampMin or timestampMax) in a cubejs playground and whether it's possible or not. I'm getting "TypeError: Cannot read properties of null (reading 'split')" when I'm trying to add a filter like timestampMin in date range/not in date range/before date/after date. No sql generated, "Run Query" button is inactive.

I do able to filter by requests measure.

Cube.js schema

cube(`Cube`, {
  ...
    measures: {
        requests: {
            sql: `count`,
            type: `sum`
        },
        timestampMin: {
            sql: `min(timestamp)`,
            type: `time`
        },
        timestampMax: {
            sql: `max(timestamp)`,
            type: `time`
        },
    },
    dimensions: {
        ....
        timestamp: {
            sql: `timestamp`,
            type: `time`
        },
        .....
})

Cubejs version: v1.2.30

Data source: Clickhouse

[igorlukanin]

Hi @Anger79 👋

You can add a filter by time dimension in the following way. Please check screenshots:

That one will translate to the dateRange parameter in the timeDimension part of the query.

inDateRange, notInDateRange, beforeDate, afterDate filter types are currently not supported in Playground. Anyway, you'd probably be better using the dateRange parameter in timeDimension.

[Anger79]

Hi @igorlukanin, Thanks for a quick reply!

But I'm interested in filtering exactly by the time measure, not a time dimension.
There is a difference between fitlering by dimension and by measure, right? Because filter by measure gets converted to the HAVING clause and applied after aggregation in sql query, while fitlering by dimension gets converted to a regular WHERE clause.

So I'm trying to understand if there is a way to apply filter by time measure in a cubejs query, and what is the proper way of doing that if that is supported.

Would be great if you provide query example.
Thanks!

[igorlukanin]

But I'm interested in filtering exactly by the time measure, not a time dimension.

Oh, sorry, I misread it. Now I see that using these filters lead to an error: TypeError: Cannot read properties of null (reading 'split').

This is not actually specific for Playground, happens in the REST API as well.

[Anger79]

@igorlukanin Right, I wasn't able to make it work through the REST API, I thought that I'm doing something wrong, and tried the same in the Playground, but it didn't work as well.

[willianba]

+1
i've been having this same issue since last week too 😔

[willianba]

@KSDaemon @igorlukanin i was waiting for a release to test this one. it works fine when i don't have other filters in the same query.

e.g.:

as you can see, if i add another filter by dimension (in my case, workspaceId) it fails.

can you confirm if i'm doing something wrong or if this is a bug? thanks!

[KSDaemon]

@willianba Can you show the queries you're issuing? Would be helpful to see: REST API request and/or SQL API Request.