org_admin_proposed.sql

SELECT "main_unifiedjob"."id",
       "main_unifiedjob"."polymorphic_ctype_id",
       "main_unifiedjob"."modified",
       "main_unifiedjob"."description",
       "main_unifiedjob"."created_by_id",
       "main_unifiedjob"."modified_by_id",
       "main_unifiedjob"."name",
       "main_unifiedjob"."execution_environment_id",
       "main_unifiedjob"."old_pk",
       "main_unifiedjob"."emitted_events",
       "main_unifiedjob"."unified_job_template_id",
       "main_unifiedjob"."created",
       "main_unifiedjob"."launch_type",
       "main_unifiedjob"."schedule_id",
       "main_unifiedjob"."execution_node",
       "main_unifiedjob"."controller_node",
       "main_unifiedjob"."cancel_flag",
       "main_unifiedjob"."status",
       "main_unifiedjob"."failed",
       "main_unifiedjob"."started",
       "main_unifiedjob"."dependencies_processed",
       "main_unifiedjob"."finished",
       "main_unifiedjob"."canceled_on",
       "main_unifiedjob"."elapsed",
       "main_unifiedjob"."job_args",
       "main_unifiedjob"."job_cwd",
       "main_unifiedjob"."job_env",
       "main_unifiedjob"."job_explanation",
       "main_unifiedjob"."start_args",
       "main_unifiedjob"."result_traceback",
       "main_unifiedjob"."celery_task_id",
       "main_unifiedjob"."instance_group_id",
       "main_unifiedjob"."preferred_instance_groups_cache",
       "main_unifiedjob"."task_impact",
       "main_unifiedjob"."organization_id",
       "main_unifiedjob"."installed_collections",
       "main_unifiedjob"."ansible_version",
       "main_unifiedjob"."host_status_counts",
       "main_unifiedjob"."work_unit_id"
FROM "main_unifiedjob"
LEFT OUTER JOIN "main_inventoryupdate" ON ("main_unifiedjob"."id" = "main_inventoryupdate"."unifiedjob_ptr_id")
LEFT OUTER JOIN "main_inventorysource" ON ("main_inventoryupdate"."inventory_source_id" = "main_inventorysource"."unifiedjobtemplate_ptr_id")
LEFT OUTER JOIN "main_adhoccommand" ON ("main_unifiedjob"."id" = "main_adhoccommand"."unifiedjob_ptr_id")
LEFT OUTER JOIN "main_workflowapproval" ON ("main_unifiedjob"."id" = "main_workflowapproval"."unifiedjob_ptr_id")
WHERE (("main_unifiedjob"."unified_job_template_id" IN
          (SELECT DISTINCT V0."object_id"
           FROM "main_rbac_role_ancestors" V0
           WHERE (V0."ancestor_id" IN
                    (SELECT U0."id"
                     FROM "main_rbac_roles" U0
                     INNER JOIN "main_rbac_roles_members" U1 ON (U0."id" = U1."role_id")
                     WHERE U1."user_id" = 1097)
                  AND V0."content_type_id" IN (4,
                                               5,
                                               6,
                                               67)
                  AND V0."role_field" = 'read_role'))
        OR "main_inventorysource"."inventory_id" IN
          (SELECT DISTINCT V0."object_id"
           FROM "main_rbac_role_ancestors" V0
           WHERE (V0."ancestor_id" IN
                    (SELECT U0."id"
                     FROM "main_rbac_roles" U0
                     INNER JOIN "main_rbac_roles_members" U1 ON (U0."id" = U1."role_id")
                     WHERE U1."user_id" = 1097)
                  AND V0."content_type_id" = 34
                  AND V0."role_field" = 'read_role'))
        OR "main_adhoccommand"."inventory_id" IN
          (SELECT DISTINCT V0."object_id"
           FROM "main_rbac_role_ancestors" V0
           WHERE (V0."ancestor_id" IN
                    (SELECT U0."id"
                     FROM "main_rbac_roles" U0
                     INNER JOIN "main_rbac_roles_members" U1 ON (U0."id" = U1."role_id")
                     WHERE U1."user_id" = 1097)
                  AND V0."content_type_id" = 34
                  AND V0."role_field" = 'read_role'))
        OR "main_unifiedjob"."organization_id" IN
          (SELECT U0."id"
           FROM "main_organization" U0
           LEFT OUTER JOIN "main_rbac_roles" U1 ON (U0."admin_role_id" = U1."id")
           LEFT OUTER JOIN "main_rbac_roles_members" U2 ON (U1."id" = U2."role_id")
           LEFT OUTER JOIN "main_rbac_roles" U4 ON (U0."auditor_role_id" = U4."id")
           LEFT OUTER JOIN "main_rbac_roles_members" U5 ON (U4."id" = U5."role_id")
           WHERE (U2."user_id" = 1097
                  OR U5."user_id" = 1097))
        OR "main_unifiedjob"."id" IN
          (SELECT U0."unifiedjob_ptr_id"
           FROM "main_workflowjob" U0
           INNER JOIN "main_unifiedjob" U1 ON (U0."unifiedjob_ptr_id" = U1."id")
           WHERE (U1."created_by_id" = 1097
                  AND U0."is_bulk_job")))
       AND "main_workflowapproval"."unifiedjob_ptr_id" IS NULL
       AND NOT ("main_unifiedjob"."launch_type" = 'sync'))
ORDER BY "main_unifiedjob"."finished" DESC
LIMIT 20