How to use FILTER PARAMS getting Maximum call stack size exceeded

[rvenkatasubbaaravind]

Problem
I am getting maximum call stack exceeded issue with using FILTER PARAMS , use case is get the sum of values from table2 based on the timestamp passed with the cube

Table2 -> count,timestamp

Related Cube.js schema

cube(`cube`, {
  sql: `select * from table1`,
 dimesions: {
timestamp: {
            sql: `timestamp_day`,
            type: `time`
        },
},
measures:{
  total:'select sum(count) from table2 where  ${FILTER_PARAMS.cube.timestamp.filter('timestamp')}
},
})

I am always including time dimensions on my query

"timeDimensions": [
        {
            "dimension": "cube.timestamp",
            "dateRange": [
                "2025-04-04T12:24:08.890",
                "2025-04-11T12:24:08.890"
            ]
        }
    ]

while using total measure getting the stack overflow error like this #8707

For testing i have tried to hardcode with 1 year data it is working without any error but getting issue with Filter Params

Cubejs version: v0.35.80
Data source: Clickhouse

[igorlukanin]

Hi @rvenkatasubbaaravind 👋

I think your data model is not defined correctly.

First, FILTER_PARAMS are supposed to be used in sql of the Cube, not individual measures.

Second, measures' sql should contain aggregation functions (e.g., SUM(count)) rather then statements like SELECT * FROM ....

I hope it helps.

[rvenkatasubbaaravind]

@igorlukanin sorry for the wrong version
the cube version is v0.35.80 and has this issue #8707
Fix is available from v1.1.5

It's a long way to upgrade to v1.15

Any other way to pass the cube filters to the sql code to query another table ? (updated the description)

[rvenkatasubbaaravind]

Another thing to add we can't perfom the join the , data of these two tables are different

[igorlukanin]

I can't think of any other workaround. Please consider upgrading to the latest version. BTW, v1.13.0 has just been released a few days ago: https://cube.dev/blog/cube-core-v1-3-performance-improvements-and-upgrades