Untitled

mail@pastecode.io avatar
unknown
plain_text
16 days ago
7.7 kB
4
Indexable
Never
SELECT "e"."id" AS "e_id", "e"."enabled" AS "e_enabled", "e"."createdBy" AS "e_createdBy", "e"."updatedBy" AS "e_updatedBy", "e"."createdAt" AS "e_createdAt", "e"."updatedAt" AS "e_updatedAt", "e"."version" AS "e_version", "e"."name" AS "e_name", "e"."category" AS "e_category", "e"."worklistVersion" AS "e_worklistVersion", "e"."description" AS "e_description", "e"."model" AS "e_model", "e"."application" AS "e_application", "e"."activated" AS "e_activated", "e"."step" AS "e_step", "e"."isValid" AS "e_isValid", "e"."modules" AS "e_modules", "e"."compositionId" AS "e_compositionId", "e"."themeId" AS "e_themeId", "e"."iconId" AS "e_iconId", "context"."id" AS "context_id", "context"."enabled" AS "context_enabled", "context"."createdBy" AS "context_createdBy", "context"."updatedBy" AS "context_updatedBy", "context"."createdAt" AS "context_createdAt", "context"."updatedAt" AS "context_updatedAt", "context"."version" AS "context_version", "context"."name" AS "context_name", "icon"."id" AS "icon_id", "icon"."enabled" AS "icon_enabled", "icon"."createdBy" AS "icon_createdBy", "icon"."updatedBy" AS "icon_updatedBy", "icon"."createdAt" AS "icon_createdAt", "icon"."updatedAt" AS "icon_updatedAt", "icon"."version" AS "icon_version", "icon"."url" AS "icon_url", "icon"."storageType" AS "icon_storageType", "icon"."key" AS "icon_key", "theme"."id" AS "theme_id", "theme"."enabled" AS "theme_enabled", "theme"."createdBy" AS "theme_createdBy", "theme"."updatedBy" AS "theme_updatedBy", "theme"."createdAt" AS "theme_createdAt", "theme"."updatedAt" AS "theme_updatedAt", "theme"."version" AS "theme_version", "theme"."name" AS "theme_name", "profiles"."id" AS "profiles_id", "profiles"."enabled" AS "profiles_enabled", "profiles"."createdBy" AS "profiles_createdBy", "profiles"."updatedBy" AS "profiles_updatedBy", "profiles"."createdAt" AS "profiles_createdAt", "profiles"."updatedAt" AS "profiles_updatedAt", "profiles"."version" AS "profiles_version", "profiles"."name" AS "profiles_name", "profiles"."description" AS "profiles_description", "profiles"."default" AS "profiles_default", "profiles"."type" AS "profiles_type", "profiles"."status" AS "profiles_status", "profiles"."realm" AS "profiles_realm", "profiles"."startDate" AS "profiles_startDate", "profiles"."endDate" AS "profiles_endDate", "profiles"."applications" AS "profiles_applications", "profiles"."users" AS "profiles_users", "profiles"."groups" AS "profiles_groups", "composition"."id" AS "composition_id", "composition"."enabled" AS "composition_enabled", "composition"."createdBy" AS "composition_createdBy", "composition"."updatedBy" AS "composition_updatedBy", "composition"."createdAt" AS "composition_createdAt", "composition"."updatedAt" AS "composition_updatedAt", "composition"."version" AS "composition_version", "composition"."layout" AS "composition_layout", "composition"."nbrElements" AS "composition_nbrElements", "composition"."refresh" AS "composition_refresh", "composition"."frequency" AS "composition_frequency", "composition"."rowSelection" AS "composition_rowSelection", "composition"."rowSelectionType" AS "composition_rowSelectionType", "composition"."regroupement" AS "composition_regroupement", "composition"."groups" AS "composition_groups", "composition"."characteristics" AS "composition_characteristics", "composition"."columnActions" AS "composition_columnActions", "preferences"."id" AS "preferences_id", "preferences"."userId" AS "preferences_userId", "preferences"."name" AS "preferences_name", "preferences"."worklistId" AS "preferences_worklistId", "preferenceColumns"."id" AS "preferenceColumns_id", "preferenceColumns"."enabled" AS "preferenceColumns_enabled", "preferenceColumns"."createdBy" AS "preferenceColumns_createdBy", "preferenceColumns"."updatedBy" AS "preferenceColumns_updatedBy", "preferenceColumns"."createdAt" AS "preferenceColumns_createdAt", "preferenceColumns"."updatedAt" AS "preferenceColumns_updatedAt", "preferenceColumns"."version" AS "preferenceColumns_version", "preferenceColumns"."colId" AS "preferenceColumns_colId", "preferenceColumns"."hide" AS "preferenceColumns_hide", "preferenceColumns"."pinned" AS "preferenceColumns_pinned", "preferenceColumns"."rowGroup" AS "preferenceColumns_rowGroup", "preferenceColumns"."filter" AS "preferenceColumns_filter", "preferenceColumns"."displayOrder" AS "preferenceColumns_displayOrder", "preferenceColumns"."worklistPreferenceId" AS "preferenceColumns_worklistPreferenceId", "massActions"."id" AS "massActions_id", "massActions"."enabled" AS "massActions_enabled", "massActions"."createdBy" AS "massActions_createdBy", "massActions"."updatedBy" AS "massActions_updatedBy", "massActions"."createdAt" AS "massActions_createdAt", "massActions"."updatedAt" AS "massActions_updatedAt", "massActions"."version" AS "massActions_version", "massActions"."icon" AS "massActions_icon", "massActions"."name" AS "massActions_name", "massActions"."type" AS "massActions_type", "data"."id" AS "data_id", "data"."enabled" AS "data_enabled", "data"."createdBy" AS "data_createdBy", "data"."updatedBy" AS "data_updatedBy", "data"."createdAt" AS "data_createdAt", "data"."updatedAt" AS "data_updatedAt", "data"."version" AS "data_version", "data"."group" AS "data_group", "data"."name" AS "data_name", "data"."wording_fr" AS "data_wording_fr", "data"."wording_en" AS "data_wording_en", "data"."type" AS "data_type", "data"."compositionId" AS "data_compositionId", "actions"."id" AS "actions_id", "actions"."enabled" AS "actions_enabled", "actions"."createdBy" AS "actions_createdBy", "actions"."updatedBy" AS "actions_updatedBy", "actions"."createdAt" AS "actions_createdAt", "actions"."updatedAt" AS "actions_updatedAt", "actions"."version" AS "actions_version", "actions"."status" AS "actions_status", "actions"."dataColumnId" AS "actions_dataColumnId", "actions"."actionId" AS "actions_actionId", "action"."id" AS "action_id", "action"."enabled" AS "action_enabled", "action"."createdBy" AS "action_createdBy", "action"."updatedBy" AS "action_updatedBy", "action"."createdAt" AS "action_createdAt", "action"."updatedAt" AS "action_updatedAt", "action"."version" AS "action_version", "action"."name" AS "action_name" FROM "work_list_entity" "e" LEFT JOIN "work_list_entity_context_work_list_context_entity" "e_context" ON "e_context"."workListEntityId"="e"."id" LEFT JOIN "work_list_context_entity" "context" ON "context"."id"="e_context"."workListContextEntityId"  LEFT JOIN "file_entity" "icon" ON "icon"."id"="e"."iconId"  LEFT JOIN "work_list_theme_entity" "theme" ON "theme"."id"="e"."themeId"  LEFT JOIN "work_list_entity_profiles_profile_entity" "e_profiles" ON "e_profiles"."workListEntityId"="e"."id" LEFT JOIN "profile_entity" "profiles" ON "profiles"."id"="e_profiles"."profileEntityId"  LEFT JOIN "work_list_composition_entity" "composition" ON "composition"."id"="e"."compositionId"  LEFT JOIN "work_list_preference_entity" "preferences" ON "preferences"."worklistId"="e"."id"  LEFT JOIN "work_list_column_preference_entity" "preferenceColumns" ON "preferenceColumns"."worklistPreferenceId"="preferences"."id"  LEFT JOIN "worklistcomposition_massactions" "composition_massActions" ON "composition_massActions"."workListCompositionEntityId"="composition"."id" LEFT JOIN "work_list_mass_action_entity" "massActions" ON "massActions"."id"="composition_massActions"."workListMassActionEntityId"  LEFT JOIN "work_list_data_column_entity" "data" ON "data"."compositionId"="composition"."id"  LEFT JOIN "work_list_column_action_entity" "actions" ON "actions"."dataColumnId"="data"."id"  LEFT JOIN "work_list_data_action_entity" "action" ON "action"."id"="actions"."actionId" WHERE "e"."id" = $1 -- PARAMETERS: ["4d1700c3-792d-4f57-9041-a97041e8616c"]
Leave a Comment