How can I do it ? ( with ORM )

[dangerdodis]

Hey there,
I have not searched and found the forum. I want to write the following code as ORM but I can not find it. I've studied the documentation, but there's nothing like it.
Please help me.

"SELECT
        COUNT( assigned_status ) AS Count,
        SUM( CASE WHEN m.assigned_status = 'Demo1' THEN 1 ELSE 0 END ) AS Demo1,
        SUM( CASE WHEN m.assigned_status = 'Demo2' THEN 1 ELSE 0 END ) AS Demo2,
        SUM( CASE WHEN m.assigned_status = 'Demo3' THEN 1 ELSE 0 END ) AS Demo3,
        SUM( CASE WHEN m.assigned_status = 'Demo4' THEN 1 ELSE 0 END ) AS Demo4
    FROM
        meeting m
    WHERE
        assigned_user_id = '".$user['id']."'";

[tanya]

Hi,
it's not possible with ORM, but you can run your query

https://forum.espocrm.com/forum/developer-help/37890-just-get-where