mirror of
https://github.com/paralus/paralus.git
synced 2026-02-14 17:49:51 +00:00
c66bdc25cd
* restructure rcloud-base as a single base controller * updated master.rest * moved sentry from internal to pkg as it is used by relay * removing unused rpc and it's dependencies * Fix usermgmt tests * Don't redefine variables in rest file Co-authored-by: Abin Simon <abin.simon@rafay.co>
20 lines
423 B
SQL
20 lines
423 B
SQL
CREATE OR REPLACE VIEW sentry_bootstrap_template_host AS
|
|
SELECT
|
|
a.name,
|
|
(h::jsonb) -> 'host' AS host
|
|
FROM (
|
|
SELECT
|
|
name,
|
|
jsonb_array_elements(
|
|
CASE jsonb_typeof(hosts)
|
|
WHEN 'array' THEN
|
|
hosts
|
|
ELSE
|
|
'[]'
|
|
END) AS h
|
|
FROM
|
|
sentry_bootstrap_agent_template) AS a
|
|
WHERE
|
|
a.h ->> 'type' = 'HostTypeExternal';
|
|
|