Advertisement
Guest User

Untitled

a guest
Jul 6th, 2018
198
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. #много параметров из разных таблиц - смотрим со стороны объектов, грид SQL
  2. CREATE TEMP TABLE mobsted_temp_table_1 AS
  3. SELECT DISTINCT "backend_ObjectId"
  4. FROM
  5.   (SELECT backend.id AS "backend_id",
  6.           backend.id AS "backend_abc", ......, .... ,....,
  7.      (SELECT MAX(CASE
  8.                      WHEN "ColumnName" = 'new_colw' THEN "ColumnValue"
  9.                      ELSE NULL
  10.                  END)
  11.       FROM backendext
  12.       WHERE "BackendId" = backend.id
  13.       GROUP BY "BackendId") AS "backend_new_colw"
  14.    FROM backend
  15.    LEFT JOIN objects ON objects.id = backend."ObjectId"
  16.    LEFT JOIN statuses ON statuses.id = backend."StatusId"
  17.    LEFT JOIN users ON users.id = backend."Responsibleid"
  18.    LEFT JOIN screens ON screens.id = backend."ScreenId"
  19.    WHERE backend."ApplicationId" = 672) t
  20. WHERE ("backend_НоваяКолонка1_ad0dff7879"='123'
  21.        AND "screens_Name"='Home'
  22.        AND "backend_UpdateDate"='24.05.2018 18:17:58'
  23.        AND "objects_Email"='nzulfigarov@gmail.com');
  24.  
  25.  
  26. SELECT objects."id" AS "objects_id",
  27.        objects.id AS "abc", ....., objects."Testval" AS "objects_Testval"
  28. FROM objects
  29. WHERE objects.id IN
  30.     (SELECT "backend_ObjectId"::BIGINT
  31.      FROM "mobsted_temp_table_1")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement