mirror of
https://github.com/hanzoai/team.git
synced 2026-09-30 01:57:35 +00:00
4a5e5b4d87
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]>
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;
|
|
|