Query Segment WITH clause support

Avishai_Lippner · March 27, 2023, 8:24pm

Feature(s) impacted

Hey,
I’m trying to create a segment using a query with “with” clause to simplify my query,
and it breaks for me every time I try to use the “with” clause inside my query.

I attached a simple query with “with” clause that doesn’t work for me.

Do you support this type of sql syntax?
see attached photo for example

I’m currently working with postgresql witch supports this syntax .

Observed behavior

Forest admin view fails when choosing this segment with status 422 in the logs.

Expected behavior

I expect query section to support “with” clause in the query.

Failure Logs

Context

Project name: Empathy
Team name: All team( for example: Care Ops)
Environment name: dev
Agent (forest package) name & version: forest-express-sequelize: 8.4.8
Database type: postgresql
Recent changes made on your end if any: …

Florian_Gonzales · March 28, 2023, 7:53am

Hello @Avishai_Lippner ,

Do you have more details about the error in your server logs and in your browser console ?

Kind regards,

Florian

Avishai_Lippner · March 28, 2023, 9:39am

Sure things,

Here are the browser logs:

Logs from console:

Hope it helps with the investigation

Florian_Gonzales · March 28, 2023, 1:50pm

Thank you it will help, I’m going to test it on my side

Florian_Gonzales · March 29, 2023, 1:47pm

After investigation we do not support WITH Clause in this segment . I will add the feature request to our productboard . However, you can usually try to make this query using a smart segment: Smart Segments - Developer guide. I tested it on my side and it’s work with your sql code in example.