Last active
September 28, 2017 16:12
Star
You must be signed in to star a gist
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
; | |
WITH cte | |
AS ( | |
SELECT referenced_variable_name | |
FROM CATALOG.object_parameters p | |
WHERE project_id = ( | |
SELECT project_id | |
FROM CATALOG.projects proj | |
WHERE proj.NAME = @1 | |
AND proj.folder_id = ( | |
SELECT folder.folder_id | |
FROM CATALOG.folders folder | |
WHERE folder.NAME = @2 | |
AND folder.folder_id = ( | |
SELECT environment.folder_id | |
FROM CATALOG.environments environment | |
WHERE environment.NAME = @0 | |
) | |
) | |
) | |
) | |
SELECT referenced_variable_name, CASE eevee.sensitive WHEN 0 THEN 'False' ELSE 'True' END as sensitive, eevee.description, eevee.type as data_type, eevee.value | |
FROM cte | |
INNER JOIN CATALOG.environment_variables eevee on eevee.NAME = cte.referenced_variable_name | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment