Mustafa Sencer ÖzcanandWill Assis
98e37f2ca9
* implement special dashboard fallback logic when dashboard data has invalid json behind feature flag --------- Co-authored-by: Will Assis <william@williamassis.com>
31 lines
1.0 KiB
SQL
Executable File
31 lines
1.0 KiB
SQL
Executable File
SELECT
|
|
dashboard.org_id,
|
|
dashboard.id,
|
|
dashboard.uid,
|
|
dashboard.title,
|
|
dashboard.folder_uid,
|
|
dashboard.deleted,
|
|
plugin_id,
|
|
provisioning.name as repo_name,
|
|
provisioning.external_id as repo_path,
|
|
provisioning.check_sum as repo_hash,
|
|
provisioning.updated as repo_ts,
|
|
dashboard.created,
|
|
created_user.uid as created_by,
|
|
dashboard.created_by as created_by_id,
|
|
dashboard.updated,
|
|
updated_user.uid as updated_by,
|
|
dashboard.updated_by as updated_by_id,
|
|
dashboard.version,
|
|
'' as message,
|
|
dashboard.data,
|
|
dashboard.api_version
|
|
FROM "grafana"."dashboard" as dashboard
|
|
LEFT OUTER JOIN "grafana"."dashboard_provisioning" as provisioning ON dashboard.id = provisioning.dashboard_id
|
|
LEFT OUTER JOIN "grafana"."user" as created_user ON dashboard.created_by = created_user.id
|
|
LEFT OUTER JOIN "grafana"."user" as updated_user ON dashboard.updated_by = updated_user.id
|
|
WHERE dashboard.is_folder = TRUE
|
|
AND dashboard.org_id = 2
|
|
AND dashboard.deleted IS NULL
|
|
ORDER BY dashboard.id DESC
|