mirror of
https://github.com/hanzoai/team.git
synced 2026-09-30 01:57:35 +00:00
b8e853d51f
* [MM-61756] Attribute Based Access Control - Phase 1 (#30785)
Attribute Based Access Control - Base
* MM-63662
* MM-63919
* MM-63954
* MM-63955
* MM-63425
* MM-63426
* MM-63458
* MM-63459
* MM-63603
* MM-63845
* MM-64146
* MM-64199
* MM-64201
* MM-64233
* MM-64247
* MM-64268
---------
Co-authored-by: Harshil Sharma <[email protected]>
Co-authored-by: Pablo Andrés Vélez Vidal <[email protected]>
Co-authored-by: abhijit-singh <[email protected]>
Co-authored-by: Harrison Healey <[email protected]>
(cherry picked from commit 4a5e5b4d87)
* trigger CI
---------
Co-authored-by: Ibrahim Serdar Acikgoz <[email protected]>
Co-authored-by: Harshil Sharma <[email protected]>
Co-authored-by: Pablo Andrés Vélez Vidal <[email protected]>
Co-authored-by: abhijit-singh <[email protected]>
Co-authored-by: Harrison Healey <[email protected]>
11 lines
288 B
SQL
11 lines
288 B
SQL
CREATE OR REPLACE VIEW AttributeView AS
|
|
SELECT
|
|
pv.GroupID,
|
|
pv.TargetID,
|
|
pv.TargetType,
|
|
JSON_OBJECTAGG(pf.Name, pv.Value)
|
|
AS Attributes
|
|
FROM PropertyValues pv
|
|
LEFT JOIN PropertyFields pf ON pf.ID = pv.FieldID
|
|
GROUP BY GroupID, TargetID, TargetType;
|
|
|