Live Queries

SELECT t.id, t.title, t.scheduled_at, t.done_at, t.priority, t.owned_by_user_id,
            u.display_name as owned_by_user_display_name,
            COALESCE(
              (SELECT json_agg(json_build_object('id', m.id, 'targetId', m.target_id, 'targetType', m.target_type))
               FROM mentions m WHERE m.source_id = t.id AND m.source_type = 'todos' AND m.deleted_at IS NULL),
              '[]'::json
            ) as mentions
     FROM todos t
     LEFT JOIN auth.users u ON u.id = t.owned_by_user_id
     WHERE t.title ILIKE $1 AND t.deleted_at IS NULL AND t.group_id = $2::uuid
       AND NOT EXISTS (
         SELECT 1 FROM mentions m
         JOIN profiles p ON p.id = m.target_id
         WHERE m.source_id = t.id AND m.source_type = 'todos' AND m.target_type = 'profiles'
           AND m.deleted_at IS NULL AND p.deleted_at IS NOT NULL
       )
     ORDER BY t.scheduled_at DESC NULLS LAST
     LIMIT $3

begin 

SELECT  coalesce(json_agg("root" ), '[]' ) AS "root" FROM  (SELECT  row_to_json((SELECT  "_e"  FROM  (SELECT  "_root.base"."id" AS "id", "_root.base"."trigger_short_id" AS "shortId", "_root.base"."added_at" AS "addedAt", "_root.base"."birthday" AS "birthday", "_root.base"."can_send_inmail" AS "canSendInMail", "_root.base"."trigger_count_connexions_with_this_profile" AS "countConnexionsWithThisProfile", "_root.base"."trigger_count_invitations_scheduled_to_this_profile" AS "countInvitationsScheduledToThisProfile", "_root.base"."trigger_count_invitations_sent_to_this_profile" AS "countInvitationsSentToThisProfile", "_root.base"."trigger_count_applications_from_this_profile" AS "countApplicationsFromThisProfile", "_root.base"."trigger_count_messages_received_from_this_profile" AS "countMessagesReceivedFromThisProfile", "_root.base"."trigger_count_messages_scheduled_to_this_profile" AS "countMessagesScheduledToThisProfile", "_root.base"."trigger_count_messages_sent_to_this_profile" AS "countMessagesSentToThisProf

SELECT  coalesce(json_agg("root" ), '[]' ) AS "root" FROM  (SELECT  row_to_json((SELECT  "_e"  FROM  (SELECT  "_root.base"."id" AS "id", "_root.base"."trigger_short_id" AS "shortId", "_root.base"."added_at" AS "addedAt", "_root.base"."birthday" AS "birthday", "_root.base"."can_send_inmail" AS "canSendInMail", "_root.base"."created_at" AS "createdAt", "_root.base"."created_by_userid" AS "createdByUserId", "_root.base"."deleted_at" AS "deletedAt", "_root.base"."network_distance_level" AS "distance", "_root.base"."external_id" AS "externalId", "_root.base"."trigger_first_name" AS "firstName", "_root.base"."first_name_parsed" AS "firstNameParsed", "_root.base"."first_name_manual" AS "firstNameManual", "_root.base"."group_id" AS "groupId", "_root.base"."headline" AS "headline", "_root.base"."image_id" AS "imageId", "_root.base"."is_talent" AS "isTalent", "_root.base"."is_contact" AS "isContact", "_root.base"."is_hiring" AS "isHiring", "_root.base"."is_open_to_new_opportunities" AS "isOpenToNewOpportunities", "_ro

SELECT  coalesce(json_agg("root" ORDER BY "root.pg.id" DESC NULLS LAST), '[]' ) AS "root" FROM  (SELECT  row_to_json((SELECT  "_e"  FROM  (SELECT  "_root.base"."SEND_EMAIL" AS "SEND_EMAIL", "_root.base"."SEND_LINKEDIN_INMAIL" AS "SEND_LINKEDIN_INMAIL", "_root.base"."SEND_LINKEDIN_INVITATION" AS "SEND_LINKEDIN_INVITATION", "_root.base"."SEND_LINKEDIN_MESSAGE" AS "SEND_LINKEDIN_MESSAGE", "_root.base"."SEND_SMS" AS "SEND_SMS", "_root.base"."SEND_TELEGRAM_MESSAGE" AS "SEND_TELEGRAM_MESSAGE", "_root.base"."SEND_WHATSAPP_MESSAGE" AS "SEND_WHATSAPP_MESSAGE", "_root.base"."id" AS "id", "_root.base"."preferred_message_type" AS "preferedMessageType", "_root.base"."profile_id" AS "profileId", "_root.base"."sender_id" AS "senderId", 'profiles_available_messages_types_view' AS "__typename"       ) AS "_e"      ) ) AS "root", "_root.base"."id" AS "root.pg.id" FROM  (SELECT  *  FROM "public"."profiles_available_messages_types_view"  WHERE (((EXISTS  (SELECT  1  FROM "public"."profiles" AS "__be_0_profiles" WHERE (((("__be_

SELECT  coalesce(json_agg("root" ORDER BY "root.pg.scheduled_at" ASC NULLS LAST, "root.pg.id" ASC NULLS LAST), '[]' ) AS "root" FROM  (SELECT  row_to_json((SELECT  "_e"  FROM  (SELECT  "_root.base"."id" AS "id", "_root.base"."created_at" AS "createdAt", "_root.base"."updated_at" AS "updatedAt", "_root.base"."deleted_at" AS "deletedAt", "_root.base"."profile_id" AS "profileId", "_root.base"."user_id" AS "userId", "_root.base"."sender_id" AS "senderId", "_root.base"."sender_oauth_id" AS "senderOauthId", "_root.base"."type" AS "type", "_root.base"."subject" AS "subject", "_root.base"."text_message" AS "textMessage", "_root.base"."html_message" AS "htmlMessage", "_root.base"."template_message" AS "templateMessage", "_root.base"."template_subject" AS "templateSubject", "_root.base"."reply_to_historyentry_id" AS "replyToHistoryEntryId", "_root.base"."scheduled_at" AS "scheduledAt", "_root.base"."email_address" AS "emailAddress", "_root.base"."linkedin_seat_id" AS "linkedinSeatId", "_root.base"."is_draft" AS "isDra

SELECT  coalesce(json_agg("root" ORDER BY "root.pg.done_at" DESC NULLS FIRST, "root.pg.scheduled_at" ASC NULLS FIRST, "root.pg.priority" ASC NULLS LAST, "root.pg.created_at" ASC NULLS LAST, "root.pg.id" ASC NULLS LAST), '[]' ) AS "root" FROM  (SELECT  row_to_json((SELECT  "_e"  FROM  (SELECT  "_root.base"."id" AS "id", "_root.base"."created_at" AS "createdAt", "_root.base"."updated_at" AS "updatedAt", "_root.base"."deleted_at" AS "deletedAt", "_root.base"."created_by_user_id" AS "createdByUserId", "_root.or.createdByUser"."createdByUser" AS "createdByUser", "_root.base"."done_at" AS "doneAt", "_root.base"."done_by_user_id" AS "doneByUserId", "_root.or.doneByUser"."doneByUser" AS "doneByUser", "_root.base"."title" AS "title", "_root.base"."scheduled_at" AS "scheduledAt", "_root.base"."priority" AS "priority", "_root.base"."ai_run_id" AS "aiRunId", "_root.base"."owned_by_user_id" AS "ownedByUserId", "_root.or.ownedByUser"."ownedByUser" AS "ownedByUser", "_root.ar.root.mentions"."mentions" AS "mentions", 'todos

SELECT  coalesce(json_agg("root" ORDER BY "root.pg.id" DESC NULLS LAST), '[]' ) AS "root" FROM  (SELECT  row_to_json((SELECT  "_e"  FROM  (SELECT  "_root.base"."id" AS "id", "_root.base"."priority" AS "priority", "_root.base"."created_at" AS "createdAt", "_root.base"."updated_at" AS "updatedAt", "_root.base"."deleted_at" AS "deletedAt", "_root.base"."done_at" AS "doneAt", "_root.base"."cancel_at" AS "cancelAt", "_root.base"."user_id" AS "userId", "_root.base"."group_id" AS "groupId", "_root.base"."linkedin_seat_id" AS "linkedinSeatId", "_root.base"."type" AS "type", "_root.base"."status" AS "status", "_root.base"."since" AS "since", "_root.base"."retries" AS "retries", "_root.base"."parameters" AS "parameters", "_root.base"."profile_id" AS "profileId", "_root.base"."version" AS "version", "_root.base"."duration" AS "duration", "_root.or.profile"."profile" AS "profile", "_root.base"."trigger_id" AS "triggerId", "_root.or.trigger"."trigger" AS "trigger", "_root.base"."dashboard_id" AS "dashboardId", "_root.bas

SELECT  coalesce(json_agg("root" ORDER BY "root.pg.last_created_at" DESC NULLS LAST, "root.pg.historyentry_id" ASC NULLS LAST), '[]' ) AS "root" FROM  (SELECT  row_to_json((SELECT  "_e"  FROM  (SELECT  "_root.base"."email_address" AS "emailAddress", "_root.base"."external_thread_id" AS "externalThreadId", "_root.base"."group_id" AS "groupId", "_root.base"."historyentry_id" AS "id", "_root.base"."last_created_at" AS "lastCreatedAt", "_root.base"."oauth_account_id" AS "oauthAccountId", "_root.base"."profile_id" AS "profileId", "_root.base"."sender_user_id" AS "senderUserId", "_root.base"."subject" AS "subject", "_root.base"."type" AS "type", 'historyentries_to_reply_to_view' AS "__typename"       ) AS "_e"      ) ) AS "root", "_root.base"."last_created_at" AS "root.pg.last_created_at", "_root.base"."historyentry_id" AS "root.pg.historyentry_id" FROM  (SELECT  *  FROM "public"."historyentries_to_reply_to_view"  WHERE (((("public"."historyentries_to_reply_to_view"."group_id") = ((($1->>'x-hasura-group-id'))::uui

SET LOCAL "hasura.user" = '{"x-hasura-client-type":"server","x-hasura-group-id":"2489c1d3-dd91-4ac2-8e80-353d99baaae2","x-hasura-role":"user","x-hasura-user-id":"6dfee6dc-e29c-430c-a4e5-6fb482b6f887"}'