проверь запрос на ошибки (этот запрос собирает view) SELECT e."PersonnelNumber" AS…
- 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;
- Assistant
Запрос не содержит синтаксических ошибок.
- User
а как вывести Users.PersonnelNumber по полю GMGoals.CreatedByid
- 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.
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.