tiflux01.sql

select count(*) as "__lucid_aggregate" from (select "service_desk_tickets"."ticket_number", "service_desk_tickets"."title", (service_desk_tickets.attend_expiration at time zone 'UTC') AT TIME ZONE 'America/Sao_Paulo' AS attend_expiration, "service_desk_tickets"."is_revised", "service_desk_tickets"."requestor_email" as "requestor_email", "service_desk_tickets"."followers", (service_desk_tickets.solve_expiration at time zone 'UTC') AT TIME ZONE 'America/Sao_Paulo' AS solve_expiration, (service_desk_tickets.solved_in_time at time zone 'UTC') AT TIME ZONE 'America/Sao_Paulo' AS solved_in_time, "service_desk_tickets"."created_by_way_of", (service_desk_tickets.created_at at time zone 'UTC') AT TIME ZONE 'America/Sao_Paulo' AS created_at, (GREATEST(entity_field_values.updated_at,service_desk_tickets.updated_at) AT TIME ZONE 'UTC') AT TIME ZONE 'America/Sao_Paulo' AS updated_at, json_build_object('stopped', service_desk_tickets.stopped, 'reason', CASE WHEN service_desk_tickets.stopped IS TRUE THEN (SELECT name FROM service_desk_ticket_answers WHERE ticket_id = service_desk_tickets.id AND (name LIKE 'SLA paused. Reason:%' OR name LIKE 'O Sla foi pausado. Motivo:%') ORDER BY created_at DESC LIMIT 1) ELSE NULL END)::jsonb pause_sla_status, (service_desk_tickets.first_appointment_datetime<service_desk_tickets.attend_expiration) as attend_sla, json_build_object('id', clients.id, 'name', clients.name)::jsonb client, json_build_object('id', service_desk_desks.id, 'name', service_desk_desks.name, 'display_name', service_desk_desks.display_name, 'active', service_desk_desks.active, 'icon', service_desk_desks.icon, 'desk_with_sla', service_desk_desks.desk_with_sla)::jsonb desk, json_build_object('id', users.id, 'name', users.name, 'email', users.email)::jsonb responsible, CASE WHEN service_desk_priorities.id IS NOT NULL THEN json_build_object('id', service_desk_priorities.id, 'name', service_desk_priorities.name) ELSE NULL END AS priority, json_build_object('id', service_desk_services_catalogs_items.id, 'item_name', service_desk_services_catalogs_items.name, 'area_name', service_desk_services_catalogs_areas.name, 'catalog_name', service_desk_services_catalogs.name)::jsonb services_catalog, json_build_object('id', service_desk_stages.id, 'name', service_desk_stages.name, 'expiration', (service_desk_tickets.stage_expiration at time zone 'UTC') AT TIME ZONE 'America/Sao_Paulo')::jsonb stage, json_build_object('id', service_desk_statuses.id, 'name', service_desk_statuses.name)::jsonb status, "service_desk_ticket_feedbacks"."rating" as "rating" from "service_desk_tickets" left join "clients" on "clients"."id" = "service_desk_tickets"."client_id" left join "service_desk_desks" on "service_desk_desks"."id" = "service_desk_tickets"."desk_id" left join "service_desk_priorities" on "service_desk_priorities"."id" = "service_desk_tickets"."priority_id" left join "service_desk_stages" on "service_desk_stages"."id" = "service_desk_tickets"."stage_id" left join "service_desk_statuses" on "service_desk_statuses"."id" = "service_desk_tickets"."status_id" left join "service_desk_services_catalogs_items" on "service_desk_services_catalogs_items"."id" = "service_desk_tickets"."services_catalogs_item_id" left join "service_desk_services_catalogs_areas" on "service_desk_services_catalogs_areas"."id" = "service_desk_services_catalogs_items"."services_catalogs_area_id" left join "service_desk_services_catalogs" on "service_desk_services_catalogs"."id" = "service_desk_services_catalogs_areas"."services_catalog_id" left join "users" on "service_desk_tickets"."responsible_id" = "users"."id" left join "service_desk_ticket_feedbacks" on "service_desk_ticket_feedbacks"."ticket_id" = "service_desk_tickets"."id" left join lateral (SELECT * FROM entity_field_values where entity_field_values.owner_id = service_desk_tickets.id AND entity_field_values.owner_type = 'ServiceDesk::Ticket' order by entity_field_values.updated_at desc limit 1 ) AS entity_field_values ON 1=1 left join           (select service_desk_tickets.*             from service_desk_tickets             LEFT JOIN  service_desk_tickets ticket_references_service_desk_tickets ON ticket_references_service_desk_tickets.id  = service_desk_tickets.ticket_reference_id  AND ticket_references_service_desk_tickets.organization_id = 7606          ) AS ticket_references_service_desk_tickets ON ticket_references_service_desk_tickets.id = service_desk_tickets.ticket_reference_id            left join           (select service_desk_tickets.*             from service_desk_tickets             LEFT JOIN  service_desk_tickets ticket_reference_childrens_service_desk_tickets ON ticket_reference_childrens_service_desk_tickets.ticket_reference_id  = service_desk_tickets.id  AND ticket_reference_childrens_service_desk_tickets.organization_id = 7606          ) AS ticket_reference_childrens_service_desk_tickets ON ticket_reference_childrens_service_desk_tickets.ticket_reference_id = service_desk_tickets.id            where "service_desk_tickets"."organization_id" = $1 and "service_desk_tickets"."is_closed" = $2 and "service_desk_tickets"."created_at" between $3 and $4 group by service_desk_tickets.id, service_desk_tickets.ticket_number, service_desk_tickets.title, service_desk_tickets.attend_expiration, service_desk_tickets.is_revised, service_desk_tickets.requestor_email, service_desk_tickets.followers, service_desk_tickets.solve_expiration,service_desk_tickets.solved_in_time, service_desk_tickets.created_by_way_of, service_desk_tickets.created_at, service_desk_tickets.updated_at, entity_field_values.updated_at, service_desk_tickets.stopped, clients.id, service_desk_desks.id, users.id, service_desk_priorities.id, service_desk_services_catalogs_items.id, service_desk_services_catalogs_areas.name, service_desk_services_catalogs.name,service_desk_stages.id, service_desk_statuses.id, service_desk_ticket_feedbacks.rating, ticket_references_service_desk_tickets.ticket_number, ticket_references_service_desk_tickets.title) as "__lucid" - canceling statement due to conflict with recovery