Skip to content
TheChatArchiveThe Chat Archive
gpt-3.5-turbo-0301· OpenAIAi2 WildChat-4.8M (AI2)

проверь запрос на ошибки (этот запрос собирает view) SELECT e."PersonnelNumber" AS…

  1. User

    проверь запрос на ошибки (этот запрос собирает view) SELECT e."PersonnelNumber" AS "UserPersNumber", e."Title" AS "UserTitle", e."IsActive" AS "UserIsActive", p."Title" AS "UserPosition", e."WorkStartDate" AS "UserWorkStartDate", f."Title" AS "UserMainDepartment", ed."Title" AS "UserDepartment", r."PersonnelNumber" AS "ResponsiblePersNumber", r."Title" AS "ResponsibleTitle", r."IsActive" AS "ResponsibleIsActive", gs."Title" AS "GoalSeason", g."Id" AS "GoalFormId", g."IsDeleted" AS "GoalFormIsDeleted", g."Modified" AS "GoalFormModificationDate", um."Title" AS "GoalFormModificationBy", g."StartDate" AS "GoalFormStartDate", g."Created" AS "GoalFormCreatDate", ws."Title" AS "GoalFormStage", CASE g."IsCurrent" WHEN true THEN 'Текущая'::text ELSE 'Предыдущая'::text END AS "GoalFormType", g."TotalUserResult", g."TotalResponsibleResult", gr."Title" AS "GoalFormRating", COALESCE(wsipr."Title", 'Не заполнено'::citext) AS "IPRStage", gg."Id" AS "GoalId", CASE gg."GoalTypeId" WHEN 1 THEN '0'::text ELSE '1'::text END AS "GoalToLower", gg."Title" AS "GoalTitle", gg."Description" AS "GoalDescription", gg."Weight" AS "GoalWeight", gg."TargetValue" AS "GoalTargetValue", gg."UserFactValue" AS "GoalUserFactValue", gg."ResponsibleFactValue" AS "GoalResponsibleFactValue", uu."Title" AS "GoalUnitTitle", gg."UserResult", -- MFNEON-267 p1 gg."ResponsibleResult", -- MFNEON-267 p1 gg."CreatedById" AS "CreatedPersNumber" -- MFNEON-267 p2 FROM "Users" e JOIN "GMGoalForms" g ON g."UserId" = e."Id" LEFT JOIN "Positions" p ON p."Id" = g."UserPositionId" LEFT JOIN "Users" r ON r."Id" = g."ResponsibleId" JOIN "Users" um ON um."Id" = g."ModifiedById" JOIN "Departments" ed ON ed."Id" = g."UserDepartmentId" JOIN "Departments" f ON f."Id" = g."MainDepartmentId" JOIN "States" ws ON ws."Id" = g."StateId" JOIN "GMSeasons" gs ON gs."Id" = g."SeasonId" LEFT JOIN "GMRatings" gr ON gr."Id" = g."RatingId" LEFT JOIN "States" wsipr ON wsipr."Id" = g."IdpStatusId" LEFT JOIN "GMGoals" gg ON gg."GoalFormId" = g."Id" LEFT JOIN "Units" uu ON uu."Id" = gg."UnitId" WHERE gg."IsDeleted" IS NULL OR gg."IsDeleted" = false;

  2. Assistant

    Запрос не содержит синтаксических ошибок.

  3. User

    а как вывести Users.PersonnelNumber по полю GMGoals.CreatedByid

  4. Assistant

    Чтобы вывести PersonnelNumber пользователя из таблицы Users по полю CreatedByid таблицы GMGoals, можно добавить соответствующее соединение с таблицей Users и выбрать требуемое поле, например, так:

    SELECT u."PersonnelNumber", gg."CreatedById"
    FROM "GMGoals" gg
    JOIN "Users" u ON u."Id" = gg."CreatedById";
    

    В этом запросе мы выбираем поля PersonnelNumber из таблицы Users и CreatedById из таблицы GMGoals, а затем соединяем таблицы по полю Id из таблицы Users и полю CreatedByid из таблицы GMGoals.

Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.