Live queries are not working on segment

[aparakian]

I’m trying to use the live query for segments but no results are being returned whatever the query I use even the simplest like SELECT id FROM table;

Feature(s) impacted

live query in segments

Observed behavior

No results returned when using live queries while live queries work work charts for instance

Expected behavior

it should allow me to make more complex filters.

Context

• Project name: forest_backend
• Team name: All teams like Sales IPERIA
• Environment name: all environments like Production
• Database type: Supabase
• Recent changes made on your end if any: None

And, if you are self-hosting your agent:

• Agent technology: nodejs
• Agent (forest package) name & version (from your .lock file): agent 1.60.0

[dogan.ay]

Hello @aparakian and welcome to the community!

Thank you for opening a new thread.

Do you have any logs in your agent as you are accessing your segment ?
The lack of result may come from the returned fields of your SQL query, as defined in the documentation the returned column name must match the primaryKey of your model.

From what I can see on my side, it should work with

SELECT catalogue_item_id AS "catalogueEntityId" FROM catalogue_item;

Best regards,

[aparakian]

Ah perfect, I didn’t know I had to camelCase it for it to work.
Thanks a lot

[dogan.ay]

Great to hear that it is working !

I’ll mark this as solved.

Have a nice day