Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #много параметров из разных таблиц - смотрим со стороны объектов, грид SQL
- CREATE TEMP TABLE mobsted_temp_table_1 AS
- SELECT DISTINCT "backend_ObjectId"
- FROM
- (SELECT backend.id AS "backend_id",
- backend.id AS "backend_abc", ......, .... ,....,
- (SELECT MAX(CASE
- WHEN "ColumnName" = 'new_colw' THEN "ColumnValue"
- ELSE NULL
- END)
- FROM backendext
- WHERE "BackendId" = backend.id
- GROUP BY "BackendId") AS "backend_new_colw"
- FROM backend
- LEFT JOIN objects ON objects.id = backend."ObjectId"
- LEFT JOIN statuses ON statuses.id = backend."StatusId"
- LEFT JOIN users ON users.id = backend."Responsibleid"
- LEFT JOIN screens ON screens.id = backend."ScreenId"
- WHERE backend."ApplicationId" = 672) t
- WHERE ("backend_НоваяКолонка1_ad0dff7879"='123'
- AND "screens_Name"='Home'
- AND "backend_UpdateDate"='24.05.2018 18:17:58'
- AND "objects_Email"='nzulfigarov@gmail.com');
- SELECT objects."id" AS "objects_id",
- objects.id AS "abc", ....., objects."Testval" AS "objects_Testval"
- FROM objects
- WHERE objects.id IN
- (SELECT "backend_ObjectId"::BIGINT
- FROM "mobsted_temp_table_1")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement