106 lines
263 KiB
PL/PgSQL
106 lines
263 KiB
PL/PgSQL
BEGIN;
|
||
|
||
INSERT INTO public.collections (collection_id, title, description, parent_id, tenant_id, created_by, created_at, updated_by, updated_at, deleted_by, deleted_at, meta, title_lower, sort_title) VALUES (1827727570586567681, 'E2E Collection', 'A collection for running E2E tests', NULL, 'common', 'systemId', '2024-11-26 15:48:25.152559+00', 'systemId', '2024-11-26 15:48:25.152559+00', NULL, NULL, '{}', 'e2e collection', '\x4500313132004520436f6c6c656374696f6e');
|
||
|
||
INSERT INTO public.workbooks (workbook_id, title, description, tenant_id, meta, created_by, created_at, deleted_at, is_template, collection_id, deleted_by, updated_by, updated_at, title_lower, sort_title, status) VALUES (1540491943966934028, 'E2E Workbook', 'A workbook for running E2E tests', 'common', '{}', 'systemId', '2023-10-27 08:22:30.193066+00', NULL, false, NULL, NULL, 'systemId', '2023-10-27 08:22:30.193066+00', 'e2e workbook', '\x4500313132004520576f726b626f6f6b', 'active');
|
||
|
||
INSERT INTO public.entries (scope, type, key, inner_meta, created_by, created_at, updated_by, updated_at, is_deleted, deleted_at, hidden, display_key, entry_id, saved_id, published_id, tenant_id, name, sort_name, public, unversioned_data, workbook_id, mirrored, collection_id) VALUES ('connection', 'postgres', '1542786167294919702/connection', NULL, 'uid:systemId', '2023-10-30 12:20:42.924999+00', 'uid:systemId', '2023-10-30 12:20:42.924999+00', false, NULL, false, '1542786167294919702/Connection', 1542786167294919702, 1542786167294919703, NULL, 'common', 'connection', '\x636f6e6e656374696f6e', false, '{"password": {"key_id": "KEY", "key_kind": "local_fernet", "cypher_text": "{{POSTGRES_PASSWORD}}"}}', 1540491943966934028, false, NULL);
|
||
INSERT INTO public.entries (scope, type, key, inner_meta, created_by, created_at, updated_by, updated_at, is_deleted, deleted_at, hidden, display_key, entry_id, saved_id, published_id, tenant_id, name, sort_name, public, unversioned_data, workbook_id, mirrored, collection_id) VALUES ('widget', 'd3_wizard_node', '1559635282104419351/city-sales — pie chart', NULL, 'uid:systemId', '2023-11-22 18:16:53.935973+00', 'uid:systemId', '2023-11-22 18:16:54.002979+00', false, NULL, false, '1559635282104419351/city-sales — Pie chart', 1559635282104419351, 1559635282112807960, 1559635282112807960, 'common', 'city-sales — pie chart', '\x636974792d73616c657320e2809420706965206368617274', false, '{}', 1540491943966934028, false, NULL);
|
||
INSERT INTO public.entries (scope, type, key, inner_meta, created_by, created_at, updated_by, updated_at, is_deleted, deleted_at, hidden, display_key, entry_id, saved_id, published_id, tenant_id, name, sort_name, public, unversioned_data, workbook_id, mirrored, collection_id) VALUES ('widget', 'd3_wizard_node', '1563138177579877396/city-sales - column chart', NULL, 'uid:systemId', '2023-11-27 14:16:31.6126+00', 'uid:systemId', '2023-11-27 14:16:31.67329+00', false, NULL, false, '1563138177579877396/city-sales - Column chart', 1563138177579877396, 1563138177588266005, 1563138177588266005, 'common', 'city-sales - column chart', '\x636974792d73616c6573202d20636f6c756d6e206368617274', false, '{}', 1540491943966934028, false, NULL);
|
||
INSERT INTO public.entries (scope, type, key, inner_meta, created_by, created_at, updated_by, updated_at, is_deleted, deleted_at, hidden, display_key, entry_id, saved_id, published_id, tenant_id, name, sort_name, public, unversioned_data, workbook_id, mirrored, collection_id) VALUES ('dash', '', '1563091972355261452/load priority test :: selectors in priority', NULL, 'uid:systemId', '2023-11-27 12:44:43.515806+00', 'uid:systemId', '2023-12-12 12:49:20.39737+00', false, NULL, false, '1563091972355261452/Load priority test :: selectors in priority', 1563091972355261452, 1563851941518246954, 1563851941518246954, 'common', 'load priority test :: selectors in priority', '\x6c6f6164207072696f726974792074657374203a3a2073656c6563746f727320696e207072696f72697479', false, '{}', 1540491943966934028, false, NULL);
|
||
INSERT INTO public.entries (scope, type, key, inner_meta, created_by, created_at, updated_by, updated_at, is_deleted, deleted_at, hidden, display_key, entry_id, saved_id, published_id, tenant_id, name, sort_name, public, unversioned_data, workbook_id, mirrored, collection_id) VALUES ('dash', '', '1563181671883211803/loading test :: actual state for tab', NULL, 'uid:systemId', '2023-11-27 15:42:56.534545+00', 'uid:systemId', '2023-12-12 13:02:28.975169+00', false, NULL, false, '1563181671883211803/Loading test :: actual state for tab', 1563181671883211803, 1563183580903900195, 1563183580903900195, 'common', 'loading test :: actual state for tab', '\x6c6f6164696e672074657374203a3a2061637475616c20737461746520666f7220746162', false, '{}', 1540491943966934028, false, NULL);
|
||
INSERT INTO public.entries (scope, type, key, inner_meta, created_by, created_at, updated_by, updated_at, is_deleted, deleted_at, hidden, display_key, entry_id, saved_id, published_id, tenant_id, name, sort_name, public, unversioned_data, workbook_id, mirrored, collection_id) VALUES ('dataset', '', '1569499252818707457/orders', NULL, 'uid:systemId', '2023-12-06 08:54:50.856997+00', 'uid:systemId', '2023-12-06 08:54:50.856997+00', false, NULL, false, '1569499252818707457/Orders', 1569499252818707457, 1569499252843873282, NULL, 'common', 'orders', '\x6f7264657273', false, '{}', 1540491943966934028, false, NULL);
|
||
INSERT INTO public.entries (scope, type, key, inner_meta, created_by, created_at, updated_by, updated_at, is_deleted, deleted_at, hidden, display_key, entry_id, saved_id, published_id, tenant_id, name, sort_name, public, unversioned_data, workbook_id, mirrored, collection_id) VALUES ('dash', '', '1563082183126549507/load priority test :: charts in priority', NULL, 'uid:systemId', '2023-11-27 12:25:16.529997+00', 'uid:systemId', '2023-12-12 12:49:07.018571+00', false, NULL, false, '1563082183126549507/Load priority test :: charts in priority', 1563082183126549507, 1563851856021554216, 1563851856021554216, 'common', 'load priority test :: charts in priority', '\x6c6f6164207072696f726974792074657374203a3a2063686172747320696e207072696f72697479', false, '{}', 1540491943966934028, false, NULL);
|
||
INSERT INTO public.entries (scope, type, key, inner_meta, created_by, created_at, updated_by, updated_at, is_deleted, deleted_at, hidden, display_key, entry_id, saved_id, published_id, tenant_id, name, sort_name, public, unversioned_data, workbook_id, mirrored, collection_id) VALUES ('dash', '', '1566099212507022855/revisions test :: more than 100 revisions for loading test', NULL, 'uid:systemId', '2023-12-01 16:19:34.485133+00', 'uid:systemId', '2023-12-12 13:03:31.897028+00', false, NULL, false, '1566099212507022855/Revisions test :: more than 100 revisions for loading test', 1566099212507022855, 1566108597295777669, 1566108597295777669, 'common', 'revisions test :: more than 100 revisions for loading test', '\x7265766973696f6e732074657374203a3a206d6f7265207468616e2000313331303000207265766973696f6e7320666f72206c6f6164696e672074657374', false, '{}', 1540491943966934028, false, NULL);
|
||
INSERT INTO public.entries (scope, type, key, inner_meta, created_by, created_at, updated_by, updated_at, is_deleted, deleted_at, hidden, display_key, entry_id, saved_id, published_id, tenant_id, name, sort_name, public, unversioned_data, workbook_id, mirrored, collection_id) VALUES ('dash', '', '1563131447844275218/loading test :: chart loading out of viewport', NULL, 'uid:systemId', '2023-11-27 14:03:09.366697+00', 'uid:systemId', '2023-12-12 12:53:06.428389+00', false, NULL, false, '1563131447844275218/Loading test :: chart loading out of viewport', 1563131447844275218, 1576165491062342658, 1576165491062342658, 'common', 'loading test :: chart loading out of viewport', '\x6c6f6164696e672074657374203a3a206368617274206c6f6164696e67206f7574206f662076696577706f7274', false, '{}', 1540491943966934028, false, NULL);
|
||
INSERT INTO public.entries (scope, type, key, inner_meta, created_by, created_at, updated_by, updated_at, is_deleted, deleted_at, hidden, display_key, entry_id, saved_id, published_id, tenant_id, name, sort_name, public, unversioned_data, workbook_id, mirrored, collection_id) VALUES ('dash', '', '1584100587778081798/relations test :: chart with error', NULL, 'uid:systemId', '2023-12-26 12:25:05.63495+00', 'uid:systemId', '2023-12-26 12:26:10.931504+00', false, NULL, false, '1584100587778081798/Relations test :: chart with error', 1584100587778081798, 1584101401095570444, 1584101401095570444, 'common', 'relations test :: chart with error', '\x72656c6174696f6e732074657374203a3a2063686172742077697468206572726f72', false, '{}', 1540491943966934028, false, NULL);
|
||
INSERT INTO public.entries (scope, type, key, inner_meta, created_by, created_at, updated_by, updated_at, is_deleted, deleted_at, hidden, display_key, entry_id, saved_id, published_id, tenant_id, name, sort_name, public, unversioned_data, workbook_id, mirrored, collection_id) VALUES ('widget', 'd3_wizard_node', '1584099997438182404/chart with removed dataset — column chart', NULL, 'uid:systemId', '2023-12-26 12:23:55.260076+00', 'uid:systemId', '2023-12-26 13:16:02.048724+00', false, NULL, false, '1584099997438182404/Chart with removed dataset — Column chart', 1584099997438182404, 1584099997413016579, 1584099997413016579, 'common', 'chart with removed dataset — column chart', '\x636861727420776974682072656d6f766564206461746173657420e2809420636f6c756d6e206368617274', false, '{}', 1540491943966934028, false, NULL);
|
||
INSERT INTO public.entries (scope, type, key, inner_meta, created_by, created_at, updated_by, updated_at, is_deleted, deleted_at, hidden, display_key, entry_id, saved_id, published_id, tenant_id, name, sort_name, public, unversioned_data, workbook_id, mirrored, collection_id) VALUES ('widget', 'd3_wizard_node', '1584126375416038401/chart with removed and replaced dataset but old fields — column chart', NULL, 'uid:systemId', '2023-12-26 13:16:19.717526+00', 'uid:systemId', '2023-12-26 13:16:19.717526+00', false, NULL, false, '1584126375416038401/Chart with removed and replaced dataset but old fields — Column chart', 1584126375416038401, 1584127207750501379, 1584127207750501379, 'common', 'chart with removed and replaced dataset but old fields — column chart', '\x636861727420776974682072656d6f76656420616e64207265706c61636564206461746173657420627574206f6c64206669656c647320e2809420636f6c756d6e206368617274', false, '{}', 1540491943966934028, false, NULL);
|
||
INSERT INTO public.entries (scope, type, key, inner_meta, created_by, created_at, updated_by, updated_at, is_deleted, deleted_at, hidden, display_key, entry_id, saved_id, published_id, tenant_id, name, sort_name, public, unversioned_data, workbook_id, mirrored, collection_id) VALUES ('dash', '', '1584936080057041922/relations test :: chart with api error', NULL, 'uid:systemId', '2023-12-27 16:05:04.040693+00', 'uid:systemId', '2023-12-27 16:05:04.040693+00', false, NULL, false, '1584936080057041922/Relations test :: chart with api error', 1584936080057041922, 1584936338510054405, 1584936338510054405, 'common', 'relations test :: chart with api error', '\x72656c6174696f6e732074657374203a3a206368617274207769746820617069206572726f72', false, '{}', 1540491943966934028, false, NULL);
|
||
INSERT INTO public.entries (scope, type, key, inner_meta, created_by, created_at, updated_by, updated_at, is_deleted, deleted_at, hidden, display_key, entry_id, saved_id, published_id, tenant_id, name, sort_name, public, unversioned_data, workbook_id, mirrored, collection_id) VALUES ('widget', 'table_wizard_node', '1594995275397596161/city-sales - table chart', NULL, 'uid:systemId', '2024-01-10 13:10:53.601432+00', 'uid:systemId', '2024-01-10 13:10:53.880836+00', false, NULL, false, '1594995275397596161/city-sales - Table chart', 1594995275397596161, 1595047610186466305, 1595047610186466305, 'common', 'city-sales - table chart', '\x636974792d73616c6573202d207461626c65206368617274', false, '{}', 1540491943966934028, false, NULL);
|
||
INSERT INTO public.entries (scope, type, key, inner_meta, created_by, created_at, updated_by, updated_at, is_deleted, deleted_at, hidden, display_key, entry_id, saved_id, published_id, tenant_id, name, sort_name, public, unversioned_data, workbook_id, mirrored, collection_id) VALUES ('widget', 'table_wizard_node', '1746335664053421057/table with one column', NULL, 'uid:systemId', '2024-08-06 08:37:13.819311+00', 'uid:systemId', '2024-08-06 08:37:13.898753+00', false, NULL, false, '1746335664053421057/Table with one column', 1746335664053421057, 1746335664061809666, 1746335664061809666, 'common', 'table with one column', '\x7461626c652077697468206f6e6520636f6c756d6e', false, '{}', 1540491943966934028, false, NULL);
|
||
INSERT INTO public.entries (scope, type, key, inner_meta, created_by, created_at, updated_by, updated_at, is_deleted, deleted_at, hidden, display_key, entry_id, saved_id, published_id, tenant_id, name, sort_name, public, unversioned_data, workbook_id, mirrored, collection_id) VALUES ('dash', '', '1913957332736279553/fixed header tests', NULL, 'uid:systemId', '2025-03-25 15:11:33.853479+00', 'uid:systemId', '2025-03-25 15:11:33.853479+00', false, NULL, false, '1913957332736279553/Fixed header tests', 1913957332736279553, 1914509811190334466, 1914509811190334466, 'common', 'fixed header tests', '\x666978656420686561646572207465737473', false, '{}', 1540491943966934028, false, NULL);
|
||
INSERT INTO public.entries (scope, type, key, inner_meta, created_by, created_at, updated_by, updated_at, is_deleted, deleted_at, hidden, display_key, entry_id, saved_id, published_id, tenant_id, name, sort_name, public, unversioned_data, workbook_id, mirrored, collection_id) VALUES ('dataset', '', '1542786306705196056/dataset', NULL, 'uid:systemId', '2023-10-30 12:20:59.55005+00', 'uid:ggd9ibtalgfq1', '2023-10-30 12:20:59.55005+00', false, NULL, false, '1542786306705196056/Dataset', 1542786306705196056, 2030461343559058688, 2030461343559058688, 'common', 'dataset', '\x64617461736574', false, '{}', 1540491943966934028, false, NULL);
|
||
INSERT INTO public.entries (scope, type, key, inner_meta, created_by, created_at, updated_by, updated_at, is_deleted, deleted_at, hidden, display_key, entry_id, saved_id, published_id, tenant_id, name, sort_name, public, unversioned_data, workbook_id, mirrored, collection_id) VALUES ('dash', '', '2030460986330187005/selector test :: invalid field type', NULL, 'uid:ggd9ibtalgfq1', '2025-09-02 09:03:31.630248+00', 'uid:ggd9ibtalgfq1', '2025-09-02 09:20:31.078346+00', false, NULL, false, '2030460986330187005/Selector test :: invalid field type', 2030460986330187005, 2030460986330187006, 2030460986330187006, 'common', 'selector test :: invalid field type', '\x73656c6563746f722074657374203a3a20696e76616c6964206669656c642074797065', false, '{}', 1540491943966934028, false, NULL);
|
||
INSERT INTO public.entries (scope, type, key, inner_meta, created_by, created_at, updated_by, updated_at, is_deleted, deleted_at, hidden, display_key, entry_id, saved_id, published_id, tenant_id, name, sort_name, public, unversioned_data, workbook_id, mirrored, collection_id) VALUES ('dash', '', '1788542674546983937/screenshot tests :: dash and widgets', NULL, 'uid:systemId', '2024-10-03 14:15:01.553506+00', 'uid:044d9nm31cuyl', '2024-10-03 14:15:30.639492+00', false, NULL, false, '1788542674546983937/Screenshot tests :: dash and widgets', 1788542674546983937, 2045808258962162690, 2045808258962162690, 'common', 'screenshot tests :: dash and widgets', '\x73637265656e73686f74207465737473203a3a206461736820616e642077696467657473', false, '{}', 1540491943966934028, false, NULL);
|
||
INSERT INTO public.entries (scope, type, key, inner_meta, created_by, created_at, updated_by, updated_at, is_deleted, deleted_at, hidden, display_key, entry_id, saved_id, published_id, tenant_id, name, sort_name, public, unversioned_data, workbook_id, mirrored, collection_id) VALUES ('widget', 'metric_wizard_node', '2101667423580062721/orders count — indicator', NULL, 'uid:8rmnmzedo7hut', '2025-12-09 14:58:00.43496+00', 'uid:8rmnmzedo7hut', '2025-12-09 14:58:00.43496+00', false, NULL, false, '2101667423580062721/Orders count — Indicator', 2101667423580062721, 2101667423580062722, 2101667423580062722, 'common', 'orders count — indicator', '\x6f726465727320636f756e7420e2809420696e64696361746f72', false, '{}', 1540491943966934028, false, NULL);
|
||
INSERT INTO public.entries (scope, type, key, inner_meta, created_by, created_at, updated_by, updated_at, is_deleted, deleted_at, hidden, display_key, entry_id, saved_id, published_id, tenant_id, name, sort_name, public, unversioned_data, workbook_id, mirrored, collection_id) VALUES ('dash', '', '2101671399587316740/new dashboard', NULL, 'uid:8rmnmzedo7hut', '2025-12-09 15:05:54.410381+00', 'uid:8rmnmzedo7hut', '2025-12-09 15:05:54.410381+00', false, NULL, false, '2101671399587316740/New dashboard', 2101671399587316740, 2101671399562150915, 2101671399562150915, 'common', 'new dashboard', '\x6e65772064617368626f617264', false, '{}', 1540491943966934028, false, NULL);
|
||
INSERT INTO public.entries (scope, type, key, inner_meta, created_by, created_at, updated_by, updated_at, is_deleted, deleted_at, hidden, display_key, entry_id, saved_id, published_id, tenant_id, name, sort_name, public, unversioned_data, workbook_id, mirrored, collection_id) VALUES ('dash', '', '2101673877674394633/backgrounds variations', NULL, 'uid:8rmnmzedo7hut', '2025-12-09 15:10:49.811731+00', 'uid:8rmnmzedo7hut', '2025-12-09 15:10:49.811731+00', false, NULL, false, '2101673877674394633/Backgrounds variations', 2101673877674394633, 2101673877674394634, 2101673877674394634, 'common', 'backgrounds variations', '\x6261636b67726f756e647320766172696174696f6e73', false, '{}', 1540491943966934028, false, NULL);
|
||
INSERT INTO public.entries (scope, type, key, inner_meta, created_by, created_at, updated_by, updated_at, is_deleted, deleted_at, hidden, display_key, entry_id, saved_id, published_id, tenant_id, name, sort_name, public, unversioned_data, workbook_id, mirrored, collection_id) VALUES ('connection', 'postgres', '2152941957729485825/basic connection', NULL, 'uid:hdvqvrbwxbhy1', '2026-02-18 08:51:21.218707+00', 'uid:hdvqvrbwxbhy1', '2026-02-18 08:51:21.218707+00', false, NULL, false, '2152941957729485825/Basic connection', 2152941957729485825, 2152941957729485826, 2152941957729485826, 'common', 'basic connection', '\x626173696320636f6e6e656374696f6e', false, '{"password": {"key_id": "KEY", "key_kind": "local_fernet", "cypher_text": "{{POSTGRES_PASSWORD}}"}}', 1540491943966934028, false, NULL);
|
||
INSERT INTO public.entries (scope, type, key, inner_meta, created_by, created_at, updated_by, updated_at, is_deleted, deleted_at, hidden, display_key, entry_id, saved_id, published_id, tenant_id, name, sort_name, public, unversioned_data, workbook_id, mirrored, collection_id) VALUES ('dataset', '', '2152942322155783172/basic dataset', NULL, 'uid:hdvqvrbwxbhy1', '2026-02-18 08:52:04.667466+00', 'uid:hdvqvrbwxbhy1', '2026-02-18 08:52:04.667466+00', false, NULL, false, '2152942322155783172/Basic dataset', 2152942322155783172, 2152942322155783171, 2152942322155783171, 'common', 'basic dataset', '\x62617369632064617461736574', false, '{}', 1540491943966934028, false, NULL);
|
||
INSERT INTO public.entries (scope, type, key, inner_meta, created_by, created_at, updated_by, updated_at, is_deleted, deleted_at, hidden, display_key, entry_id, saved_id, published_id, tenant_id, name, sort_name, public, unversioned_data, workbook_id, mirrored, collection_id) VALUES ('connection', 'postgres', '2173154851817522178/connection with forbidden export', NULL, 'uid:57yarqirg9pqp', '2026-03-18 06:10:45.957852+00', 'uid:hjf50gop5x0m1', '2026-03-18 10:06:58.557484+00', false, NULL, false, '2173154851817522178/Connection with forbidden export', 2173154851817522178, 2173154971145470980, 2173154971145470980, 'common', 'connection with forbidden export', '\x636f6e6e656374696f6e207769746820666f7262696464656e206578706f7274', false, '{"password": {"key_id": "KEY", "key_kind": "local_fernet", "cypher_text": "{{POSTGRES_PASSWORD}}"}}', 1540491943966934028, false, NULL);
|
||
INSERT INTO public.entries (scope, type, key, inner_meta, created_by, created_at, updated_by, updated_at, is_deleted, deleted_at, hidden, display_key, entry_id, saved_id, published_id, tenant_id, name, sort_name, public, unversioned_data, workbook_id, mirrored, collection_id) VALUES ('dataset', '', '2173157119904187397/dataset with forbidden export on connection', NULL, 'uid:57yarqirg9pqp', '2026-03-18 06:15:16.337113+00', 'uid:hjf50gop5x0m1', '2026-03-18 10:07:34.878288+00', false, NULL, false, '2173157119904187397/Dataset with forbidden export on connection', 2173157119904187397, 2173157119904187398, 2173157119904187398, 'common', 'dataset with forbidden export on connection', '\x64617461736574207769746820666f7262696464656e206578706f7274206f6e20636f6e6e656374696f6e', false, '{}', 1540491943966934028, false, NULL);
|
||
INSERT INTO public.entries (scope, type, key, inner_meta, created_by, created_at, updated_by, updated_at, is_deleted, deleted_at, hidden, display_key, entry_id, saved_id, published_id, tenant_id, name, sort_name, public, unversioned_data, workbook_id, mirrored, collection_id) VALUES ('widget', 'd3_wizard_node', '2173157466043319303/chart with forbidden export on connection', NULL, 'uid:57yarqirg9pqp', '2026-03-18 06:15:57.608547+00', 'uid:hjf50gop5x0m1', '2026-03-18 10:09:32.75136+00', false, NULL, false, '2173157466043319303/Chart with forbidden export on connection', 2173157466043319303, 2173157466043319304, 2173157466043319304, 'common', 'chart with forbidden export on connection', '\x6368617274207769746820666f7262696464656e206578706f7274206f6e20636f6e6e656374696f6e', false, '{}', 1540491943966934028, false, NULL);
|
||
INSERT INTO public.entries (scope, type, key, inner_meta, created_by, created_at, updated_by, updated_at, is_deleted, deleted_at, hidden, display_key, entry_id, saved_id, published_id, tenant_id, name, sort_name, public, unversioned_data, workbook_id, mirrored, collection_id) VALUES ('widget', 'd3_wizard_node', '2173176602437878787/chart with forbidden export on dataset', NULL, 'uid:572moc17cb96p', '2026-03-18 06:53:58.834854+00', 'uid:hjf50gop5x0m1', '2026-03-18 10:09:44.258492+00', false, NULL, false, '2173176602437878787/Chart with forbidden export on dataset', 2173176602437878787, 2173176602454656004, 2173176602454656004, 'common', 'chart with forbidden export on dataset', '\x6368617274207769746820666f7262696464656e206578706f7274206f6e2064617461736574', false, '{}', 1540491943966934028, false, NULL);
|
||
INSERT INTO public.entries (scope, type, key, inner_meta, created_by, created_at, updated_by, updated_at, is_deleted, deleted_at, hidden, display_key, entry_id, saved_id, published_id, tenant_id, name, sort_name, public, unversioned_data, workbook_id, mirrored, collection_id) VALUES ('widget', 'd3_ql_node', '2173184500530414599/ql column chart', NULL, 'uid:572moc17cb96p', '2026-03-18 07:09:40.361535+00', 'uid:hjf50gop5x0m1', '2026-03-18 10:10:50.984066+00', false, NULL, false, '2173184500530414599/QL column chart', 2173184500530414599, 2173184500530414600, 2173184500530414600, 'common', 'ql column chart', '\x716c20636f6c756d6e206368617274', false, '{}', 1540491943966934028, false, NULL);
|
||
INSERT INTO public.entries (scope, type, key, inner_meta, created_by, created_at, updated_by, updated_at, is_deleted, deleted_at, hidden, display_key, entry_id, saved_id, published_id, tenant_id, name, sort_name, public, unversioned_data, workbook_id, mirrored, collection_id) VALUES ('widget', 'table_ql_node', '2173183463950124037/ql chart with forbidden export on connection', NULL, 'uid:572moc17cb96p', '2026-03-18 07:07:36.791779+00', 'uid:hjf50gop5x0m1', '2026-03-18 10:11:18.807879+00', false, NULL, false, '2173183463950124037/QL chart with forbidden export on connection', 2173183463950124037, 2173183463958512646, 2173183463958512646, 'common', 'ql chart with forbidden export on connection', '\x716c206368617274207769746820666f7262696464656e206578706f7274206f6e20636f6e6e656374696f6e', false, '{}', 1540491943966934028, false, NULL);
|
||
INSERT INTO public.entries (scope, type, key, inner_meta, created_by, created_at, updated_by, updated_at, is_deleted, deleted_at, hidden, display_key, entry_id, saved_id, published_id, tenant_id, name, sort_name, public, unversioned_data, workbook_id, mirrored, collection_id) VALUES ('dataset', '', '2173176182344778754/dataset with forbidden export', NULL, 'uid:572moc17cb96p', '2026-03-18 06:53:08.763308+00', 'uid:573n34fbufbyp', '2026-03-18 10:07:58.915598+00', false, NULL, false, '2173176182344778754/Dataset with forbidden export', 2173176182344778754, 2173279837236495362, 2173279837236495362, 'common', 'dataset with forbidden export', '\x64617461736574207769746820666f7262696464656e206578706f7274', false, '{}', 1540491943966934028, false, NULL);
|
||
|
||
INSERT INTO public.links (from_id, to_id, name) VALUES (1559635282104419351, 1542786306705196056, 'dataset');
|
||
INSERT INTO public.links (from_id, to_id, name) VALUES (1563138177579877396, 1542786306705196056, 'dataset');
|
||
INSERT INTO public.links (from_id, to_id, name) VALUES (1563181671883211803, 1542786306705196056, 'v9ign8imt0qkk');
|
||
INSERT INTO public.links (from_id, to_id, name) VALUES (1563181671883211803, 1563138177579877396, 'zj7yw90fzy0so');
|
||
INSERT INTO public.links (from_id, to_id, name) VALUES (1563181671883211803, 1559635282104419351, 'q9z7zsseqg2qf');
|
||
INSERT INTO public.links (from_id, to_id, name) VALUES (1563082183126549507, 1559635282104419351, 'q9z7zsseqg2qf');
|
||
INSERT INTO public.links (from_id, to_id, name) VALUES (1563082183126549507, 1542786306705196056, 'v9ign8imt0qkk');
|
||
INSERT INTO public.links (from_id, to_id, name) VALUES (1563091972355261452, 1559635282104419351, 'q9z7zsseqg2qf');
|
||
INSERT INTO public.links (from_id, to_id, name) VALUES (1563091972355261452, 1542786306705196056, 'v9ign8imt0qkk');
|
||
INSERT INTO public.links (from_id, to_id, name) VALUES (1569499252818707457, 1542786167294919702, '14544d71-9414-11ee-aad3-bff95aad7d68');
|
||
INSERT INTO public.links (from_id, to_id, name) VALUES (1563131447844275218, 1563138177579877396, 'zj7yw90fzy0so');
|
||
INSERT INTO public.links (from_id, to_id, name) VALUES (1584100587778081798, 1584099997438182404, 'g5dsp4kkwud04');
|
||
INSERT INTO public.links (from_id, to_id, name) VALUES (1584126375416038401, 1542786306705196056, 'dataset');
|
||
INSERT INTO public.links (from_id, to_id, name) VALUES (1584936080057041922, 1584126375416038401, 'd2ayync0s6ly1');
|
||
INSERT INTO public.links (from_id, to_id, name) VALUES (1594995275397596161, 1542786306705196056, 'dataset');
|
||
INSERT INTO public.links (from_id, to_id, name) VALUES (1746335664053421057, 1542786306705196056, 'dataset');
|
||
INSERT INTO public.links (from_id, to_id, name) VALUES (1913957332736279553, 1563138177579877396, 'zj7yw90fzy0so');
|
||
INSERT INTO public.links (from_id, to_id, name) VALUES (1913957332736279553, 1746335664053421057, 'yu8pwddfbvrul');
|
||
INSERT INTO public.links (from_id, to_id, name) VALUES (1913957332736279553, 1559635282104419351, 'q9z7zsseqg2qf');
|
||
INSERT INTO public.links (from_id, to_id, name) VALUES (1913957332736279553, 1594995275397596161, '1txnbnqns0e2p');
|
||
INSERT INTO public.links (from_id, to_id, name) VALUES (2030460986330187005, 1542786306705196056, 'v9ign8imt0qkk');
|
||
INSERT INTO public.links (from_id, to_id, name) VALUES (1542786306705196056, 1542786167294919702, 'c5722361-771e-11ee-8e59-ebba6a1f8b16');
|
||
INSERT INTO public.links (from_id, to_id, name) VALUES (1788542674546983937, 1594995275397596161, '1txnbnqns0e2p');
|
||
INSERT INTO public.links (from_id, to_id, name) VALUES (1788542674546983937, 1559635282104419351, 'q9z7zsseqg2qf');
|
||
INSERT INTO public.links (from_id, to_id, name) VALUES (2101667423580062721, 1569499252818707457, 'dataset');
|
||
INSERT INTO public.links (from_id, to_id, name) VALUES (2101673877674394633, 2101667423580062721, '0jefiu7nb2vul');
|
||
INSERT INTO public.links (from_id, to_id, name) VALUES (2152942322155783172, 2152941957729485825, '12f40611-0ca7-11f1-9773-955ef721cef5');
|
||
INSERT INTO public.links (from_id, to_id, name) VALUES (2173157119904187397, 2173154851817522178, '43ac3e81-2291-11f1-a77c-c386756d0c0c');
|
||
INSERT INTO public.links (from_id, to_id, name) VALUES (2173157466043319303, 2173157119904187397, 'dataset');
|
||
INSERT INTO public.links (from_id, to_id, name) VALUES (2173176602437878787, 2173176182344778754, 'dataset');
|
||
INSERT INTO public.links (from_id, to_id, name) VALUES (2173183463950124037, 2173154851817522178, 'connection');
|
||
INSERT INTO public.links (from_id, to_id, name) VALUES (2173184500530414599, 1542786167294919702, 'connection');
|
||
INSERT INTO public.links (from_id, to_id, name) VALUES (2173176182344778754, 1542786167294919702, '12ae3991-2297-11f1-9fb3-dbe839a0643c');
|
||
|
||
INSERT INTO public.revisions (data, meta, created_by, created_at, updated_by, updated_at, rev_id, entry_id, links, annotation, version, source_version) VALUES ('{"host": "{{POSTGRES_HOST}}", "name": null, "port": {{POSTGRES_PORT}}, "ssl_ca": null, "db_name": "{{POSTGRES_DB}}", "username": "{{POSTGRES_USER}}", "ssl_enable": false, "table_name": null, "cache_ttl_sec": null, "raw_sql_level": "dashsql", "enforce_collate": "auto", "sample_table_name": null, "data_export_forbidden": false}', '{"state": "saved"}', 'uid:systemId', '2023-10-30 12:20:42.924999+00', 'uid:systemId', '2023-10-30 12:20:42.924999+00', 1542786167294919703, 1542786167294919702, '{}', NULL, NULL, NULL);
|
||
INSERT INTO public.revisions (data, meta, created_by, created_at, updated_by, updated_at, rev_id, entry_id, links, annotation, version, source_version) VALUES ('{"js": "\nconst {buildGraph} = require(''libs/datalens/v3'');\n\nconst result = buildGraph({\n apiVersion: ''2'',\n data: ChartEditor.getLoadedData(),\n shared: ChartEditor.getSharedData(),\n params: ChartEditor.getParams(),\n actionParams: ChartEditor.getActionParams(),\n widgetConfig: ChartEditor.getWidgetConfig(),\n ChartEditor,\n});\n\n// your code here\n\nmodule.exports = result;\n", "ui": "\nconst {buildUI} = require(''libs/datalens/v3'');\n\nif (buildUI) {\n const result = buildUI({\n shared: ChartEditor.getSharedData(),\n params: ChartEditor.getParams(),\n actionParams: ChartEditor.getActionParams(),\n widgetConfig: ChartEditor.getWidgetConfig(),\n ChartEditor\n });\n\n // your code here\n\n module.exports = result;\n}\n", "url": "\nconst {buildSources} = require(''libs/datalens/v3'');\n\nconst result = buildSources({\n apiVersion: ''2'',\n shared: ChartEditor.getSharedData(),\n params: ChartEditor.getParams(),\n ChartEditor\n});\n\n// your code here\n\nmodule.exports = result;\n", "graph": "\nconst {buildD3Config} = require(''libs/datalens/v3'');\n\nconst result = buildD3Config({\n shared: ChartEditor.getSharedData(),\n params: ChartEditor.getParams(),\n actionParams: ChartEditor.getActionParams(),\n widgetConfig: ChartEditor.getWidgetConfig(),\n ChartEditor\n});\n\n// your code here\n\nmodule.exports = result;\n", "params": "\nconst {buildParams} = require(''libs/datalens/v3'');\n\nif (buildParams) {\n const result = buildParams({\n shared: ChartEditor.getSharedData(),\n ChartEditor\n });\n\n // your code here\n\n module.exports = result;\n} else {\n // your code here\n\n module.exports = {};\n}\n", "shared": "{\n \"colors\": [],\n \"colorsConfig\": {},\n \"datasetsIds\": [\n \"v9ign8imt0qkk\"\n ],\n \"datasetsPartialFields\": [\n [\n {\n \"guid\": \"398b4460-8963-11ee-a0d7-1707990185d3\",\n \"title\": \"title-398b4460-8963-11ee-a0d7-1707990185d3\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"id\",\n \"title\": \"id\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"order_id\",\n \"title\": \"order_id\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"order_date\",\n \"title\": \"order_date\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"ship_date\",\n \"title\": \"ship_date\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"ship_mode\",\n \"title\": \"ship_mode\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"customer_id\",\n \"title\": \"customer_id\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"customer_name\",\n \"title\": \"customer_name\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"segment\",\n \"title\": \"segment\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"country\",\n \"title\": \"country\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"city\",\n \"title\": \"city\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"state\",\n \"title\": \"state\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"postal_code\",\n \"title\": \"postal_code\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"region\",\n \"title\": \"region\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"product_id\",\n \"title\": \"product_id\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"category\",\n \"title\": \"category\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"sub_category\",\n \"title\": \"sub_category\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"product_name\",\n \"title\": \"product_name\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"sales\",\n \"title\": \"sales\",\n \"calc_mode\": \"direct\"\n }\n ]\n ],\n \"extraSettings\": {},\n \"filters\": [],\n \"geopointsConfig\": {},\n \"hierarchies\": [],\n \"labels\": [],\n \"links\": [],\n \"segments\": [],\n \"shapes\": [],\n \"shapesConfig\": {},\n \"sort\": [],\n \"tooltips\": [],\n \"type\": \"datalens\",\n \"updates\": [\n {\n \"action\": \"add_field\",\n \"field\": {\n \"lock_aggregation\": false,\n \"initial_data_type\": \"string\",\n \"type\": \"MEASURE\",\n \"valid\": true,\n \"managed_by\": \"user\",\n \"aggregation_locked\": false,\n \"virtual\": false,\n \"aggregation\": \"countunique\",\n \"data_type\": \"integer\",\n \"autoaggregated\": false,\n \"has_auto_aggregation\": false,\n \"guid\": \"398b4460-8963-11ee-a0d7-1707990185d3\",\n \"title\": \"title-398b4460-8963-11ee-a0d7-1707990185d3\",\n \"description\": \"\",\n \"cast\": \"string\",\n \"hidden\": false,\n \"source\": \"sales\",\n \"avatar_id\": \"c5722360-771e-11ee-8e59-ebba6a1f8b16\",\n \"calc_mode\": \"direct\",\n \"formula\": \"\",\n \"guid_formula\": \"\",\n \"local\": true,\n \"quickFormula\": true,\n \"originalTitle\": \"sales\",\n \"fakeTitle\": \"sales\",\n \"datasetId\": \"v9ign8imt0qkk\",\n \"id\": \"inserted-1700676975953\"\n }\n }\n ],\n \"version\": \"9\",\n \"visualization\": {\n \"id\": \"pie-d3\",\n \"type\": \"pie\",\n \"name\": \"label_visualization-pie\",\n \"iconProps\": {\n \"id\": \"visPie\",\n \"width\": \"24\"\n },\n \"allowFilters\": true,\n \"allowLabels\": true,\n \"allowSort\": true,\n \"availableLabelModes\": [\n \"absolute\",\n \"percent\"\n ],\n \"placeholders\": [\n {\n \"allowedTypes\": {},\n \"allowedDataTypes\": {},\n \"id\": \"dimensions\",\n \"type\": \"dimensions\",\n \"title\": \"section_color\",\n \"iconProps\": {},\n \"items\": [\n {\n \"lock_aggregation\": false,\n \"initial_data_type\": \"string\",\n \"type\": \"DIMENSION\",\n \"valid\": true,\n \"managed_by\": \"user\",\n \"aggregation_locked\": false,\n \"virtual\": false,\n \"aggregation\": \"none\",\n \"data_type\": \"string\",\n \"autoaggregated\": false,\n \"has_auto_aggregation\": false,\n \"guid\": \"city\",\n \"title\": \"city\",\n \"description\": \"\",\n \"cast\": \"string\",\n \"hidden\": false,\n \"source\": \"city\",\n \"avatar_id\": \"c5722360-771e-11ee-8e59-ebba6a1f8b16\",\n \"calc_mode\": \"direct\",\n \"formula\": \"\",\n \"guid_formula\": \"\",\n \"default_value\": null,\n \"value_constraint\": null,\n \"datasetId\": \"v9ign8imt0qkk\",\n \"id\": \"dimension-10\",\n \"datasetName\": \"Dataset\"\n }\n ],\n \"required\": true,\n \"capacity\": 1,\n \"settings\": {\n \"axisModeMap\": {\n \"city\": \"discrete\"\n }\n }\n },\n {\n \"allowedTypes\": {},\n \"allowedFinalTypes\": {},\n \"allowedDataTypes\": {},\n \"id\": \"measures\",\n \"type\": \"measures\",\n \"title\": \"section_measures\",\n \"iconProps\": {},\n \"items\": [\n {\n \"lock_aggregation\": false,\n \"initial_data_type\": \"string\",\n \"type\": \"MEASURE\",\n \"valid\": true,\n \"managed_by\": \"user\",\n \"aggregation_locked\": false,\n \"virtual\": false,\n \"aggregation\": \"countunique\",\n \"data_type\": \"integer\",\n \"autoaggregated\": false,\n \"has_auto_aggregation\": false,\n \"guid\": \"398b4460-8963-11ee-a0d7-1707990185d3\",\n \"title\": \"title-398b4460-8963-11ee-a0d7-1707990185d3\",\n \"description\": \"\",\n \"cast\": \"string\",\n \"hidden\": false,\n \"source\": \"sales\",\n \"avatar_id\": \"c5722360-771e-11ee-8e59-ebba6a1f8b16\",\n \"calc_mode\": \"direct\",\n \"formula\": \"\",\n \"guid_formula\": \"\",\n \"local\": true,\n \"quickFormula\": true,\n \"originalTitle\": \"sales\",\n \"fakeTitle\": \"sales\",\n \"datasetId\": \"v9ign8imt0qkk\",\n \"id\": \"inserted-1700676975953\"\n }\n ],\n \"required\": true,\n \"capacity\": 1,\n \"settings\": {\n \"axisModeMap\": {\n \"398b4460-8963-11ee-a0d7-1707990185d3\": \"continuous\"\n }\n }\n }\n ],\n \"hidden\": false,\n \"allowLayerFilters\": false\n },\n \"convert\": false\n}"}', '{}', 'uid:systemId', '2023-11-22 18:16:53.935973+00', 'uid:systemId', '2023-11-22 18:16:53.935973+00', 1559635282112807960, 1559635282104419351, '{"dataset": "v9ign8imt0qkk"}', NULL, NULL, NULL);
|
||
INSERT INTO public.revisions (data, meta, created_by, created_at, updated_by, updated_at, rev_id, entry_id, links, annotation, version, source_version) VALUES ('{"js": "\nconst {buildGraph} = require(''libs/datalens/v3'');\n\nconst result = buildGraph({\n apiVersion: ''2'',\n data: ChartEditor.getLoadedData(),\n shared: ChartEditor.getSharedData(),\n params: ChartEditor.getParams(),\n actionParams: ChartEditor.getActionParams(),\n widgetConfig: ChartEditor.getWidgetConfig(),\n ChartEditor,\n});\n\n// your code here\n\nmodule.exports = result;\n", "ui": "\nconst {buildUI} = require(''libs/datalens/v3'');\n\nif (buildUI) {\n const result = buildUI({\n shared: ChartEditor.getSharedData(),\n params: ChartEditor.getParams(),\n actionParams: ChartEditor.getActionParams(),\n widgetConfig: ChartEditor.getWidgetConfig(),\n ChartEditor\n });\n\n // your code here\n\n module.exports = result;\n}\n", "url": "\nconst {buildSources} = require(''libs/datalens/v3'');\n\nconst result = buildSources({\n apiVersion: ''2'',\n shared: ChartEditor.getSharedData(),\n params: ChartEditor.getParams(),\n ChartEditor\n});\n\n// your code here\n\nmodule.exports = result;\n", "graph": "\nconst {buildD3Config} = require(''libs/datalens/v3'');\n\nconst result = buildD3Config({\n shared: ChartEditor.getSharedData(),\n params: ChartEditor.getParams(),\n actionParams: ChartEditor.getActionParams(),\n widgetConfig: ChartEditor.getWidgetConfig(),\n ChartEditor\n});\n\n// your code here\n\nmodule.exports = result;\n", "params": "\nconst {buildParams} = require(''libs/datalens/v3'');\n\nif (buildParams) {\n const result = buildParams({\n shared: ChartEditor.getSharedData(),\n ChartEditor\n });\n\n // your code here\n\n module.exports = result;\n} else {\n // your code here\n\n module.exports = {};\n}\n", "shared": "{\n \"colors\": [],\n \"colorsConfig\": {},\n \"datasetsIds\": [\n \"v9ign8imt0qkk\"\n ],\n \"datasetsPartialFields\": [\n [\n {\n \"guid\": \"7ee6fa70-8d2f-11ee-bf49-a515b84310ed\",\n \"title\": \"title-7ee6fa70-8d2f-11ee-bf49-a515b84310ed\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"id\",\n \"title\": \"id\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"order_id\",\n \"title\": \"order_id\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"order_date\",\n \"title\": \"order_date\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"ship_date\",\n \"title\": \"ship_date\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"ship_mode\",\n \"title\": \"ship_mode\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"customer_id\",\n \"title\": \"customer_id\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"customer_name\",\n \"title\": \"customer_name\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"segment\",\n \"title\": \"segment\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"country\",\n \"title\": \"country\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"city\",\n \"title\": \"city\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"state\",\n \"title\": \"state\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"postal_code\",\n \"title\": \"postal_code\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"region\",\n \"title\": \"region\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"product_id\",\n \"title\": \"product_id\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"category\",\n \"title\": \"category\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"sub_category\",\n \"title\": \"sub_category\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"product_name\",\n \"title\": \"product_name\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"sales\",\n \"title\": \"sales\",\n \"calc_mode\": \"direct\"\n }\n ]\n ],\n \"extraSettings\": {\n \"title\": \"\",\n \"titleMode\": \"show\",\n \"labelsPosition\": \"outside\"\n },\n \"filters\": [],\n \"geopointsConfig\": {},\n \"hierarchies\": [],\n \"labels\": [],\n \"links\": [],\n \"segments\": [],\n \"shapes\": [],\n \"shapesConfig\": {},\n \"sort\": [],\n \"tooltips\": [],\n \"type\": \"datalens\",\n \"updates\": [\n {\n \"action\": \"add_field\",\n \"field\": {\n \"hidden\": false,\n \"title\": \"title-7ee6fa70-8d2f-11ee-bf49-a515b84310ed\",\n \"aggregation_locked\": false,\n \"lock_aggregation\": false,\n \"data_type\": \"integer\",\n \"aggregation\": \"countunique\",\n \"managed_by\": \"user\",\n \"initial_data_type\": \"string\",\n \"type\": \"MEASURE\",\n \"description\": \"\",\n \"cast\": \"string\",\n \"has_auto_aggregation\": false,\n \"guid\": \"7ee6fa70-8d2f-11ee-bf49-a515b84310ed\",\n \"valid\": true,\n \"autoaggregated\": false,\n \"virtual\": false,\n \"avatar_id\": \"c5722360-771e-11ee-8e59-ebba6a1f8b16\",\n \"source\": \"sales\",\n \"calc_mode\": \"direct\",\n \"formula\": \"\",\n \"guid_formula\": \"\",\n \"local\": true,\n \"quickFormula\": true,\n \"originalTitle\": \"sales\",\n \"fakeTitle\": \"sales\",\n \"datasetId\": \"v9ign8imt0qkk\",\n \"id\": \"inserted-1701094563147\"\n }\n }\n ],\n \"version\": \"9\",\n \"visualization\": {\n \"id\": \"bar-x-d3\",\n \"type\": \"column\",\n \"name\": \"label_visualization-column\",\n \"iconProps\": {\n \"id\": \"visColumn\",\n \"width\": \"24\"\n },\n \"allowFilters\": true,\n \"allowColors\": true,\n \"allowSort\": true,\n \"allowSegments\": false,\n \"allowLabels\": true,\n \"availableLabelModes\": [\n \"absolute\"\n ],\n \"placeholders\": [\n {\n \"allowedTypes\": {},\n \"allowedDataTypes\": {},\n \"id\": \"x\",\n \"type\": \"x\",\n \"title\": \"section_x\",\n \"iconProps\": {},\n \"items\": [\n {\n \"hidden\": false,\n \"title\": \"city\",\n \"aggregation_locked\": false,\n \"lock_aggregation\": false,\n \"data_type\": \"string\",\n \"aggregation\": \"none\",\n \"managed_by\": \"user\",\n \"initial_data_type\": \"string\",\n \"type\": \"DIMENSION\",\n \"description\": \"\",\n \"cast\": \"string\",\n \"has_auto_aggregation\": false,\n \"guid\": \"city\",\n \"valid\": true,\n \"autoaggregated\": false,\n \"virtual\": false,\n \"avatar_id\": \"c5722360-771e-11ee-8e59-ebba6a1f8b16\",\n \"source\": \"city\",\n \"calc_mode\": \"direct\",\n \"formula\": \"\",\n \"guid_formula\": \"\",\n \"default_value\": null,\n \"value_constraint\": null,\n \"datasetId\": \"v9ign8imt0qkk\",\n \"id\": \"dimension-10\",\n \"datasetName\": \"Dataset\"\n }\n ],\n \"required\": false,\n \"capacity\": 2,\n \"settings\": {\n \"title\": \"off\",\n \"titleValue\": \"\",\n \"type\": \"linear\",\n \"grid\": \"on\",\n \"gridStep\": \"auto\",\n \"gridStepValue\": 50,\n \"hideLabels\": \"no\",\n \"labelsView\": \"auto\",\n \"holidays\": \"off\",\n \"axisFormatMode\": \"auto\",\n \"axisModeMap\": {\n \"city\": \"discrete\"\n }\n }\n },\n {\n \"allowedTypes\": {},\n \"allowedFinalTypes\": {},\n \"allowedDataTypes\": {},\n \"id\": \"y\",\n \"type\": \"y\",\n \"title\": \"section_y\",\n \"iconProps\": {},\n \"items\": [\n {\n \"hidden\": false,\n \"title\": \"title-7ee6fa70-8d2f-11ee-bf49-a515b84310ed\",\n \"aggregation_locked\": false,\n \"lock_aggregation\": false,\n \"data_type\": \"integer\",\n \"aggregation\": \"countunique\",\n \"managed_by\": \"user\",\n \"initial_data_type\": \"string\",\n \"type\": \"MEASURE\",\n \"description\": \"\",\n \"cast\": \"string\",\n \"has_auto_aggregation\": false,\n \"guid\": \"7ee6fa70-8d2f-11ee-bf49-a515b84310ed\",\n \"valid\": true,\n \"autoaggregated\": false,\n \"virtual\": false,\n \"avatar_id\": \"c5722360-771e-11ee-8e59-ebba6a1f8b16\",\n \"source\": \"sales\",\n \"calc_mode\": \"direct\",\n \"formula\": \"\",\n \"guid_formula\": \"\",\n \"local\": true,\n \"quickFormula\": true,\n \"originalTitle\": \"sales\",\n \"fakeTitle\": \"sales\",\n \"datasetId\": \"v9ign8imt0qkk\",\n \"id\": \"inserted-1701094563147\"\n }\n ],\n \"settings\": {\n \"scale\": \"auto\",\n \"scaleValue\": \"min-max\",\n \"title\": \"off\",\n \"titleValue\": \"\",\n \"type\": \"linear\",\n \"grid\": \"on\",\n \"gridStep\": \"auto\",\n \"gridStepValue\": 50,\n \"hideLabels\": \"no\",\n \"labelsView\": \"auto\",\n \"nulls\": \"ignore\",\n \"axisFormatMode\": \"auto\",\n \"axisModeMap\": {\n \"7ee6fa70-8d2f-11ee-bf49-a515b84310ed\": \"continuous\"\n }\n }\n }\n ],\n \"hidden\": false\n },\n \"convert\": false\n}"}', '{}', 'uid:systemId', '2023-11-27 14:16:31.6126+00', 'uid:systemId', '2023-11-27 14:16:31.6126+00', 1563138177588266005, 1563138177579877396, '{"dataset": "v9ign8imt0qkk"}', NULL, NULL, NULL);
|
||
INSERT INTO public.revisions (data, meta, created_by, created_at, updated_by, updated_at, rev_id, entry_id, links, annotation, version, source_version) VALUES ('{"salt": "0.6469006121875034", "tabs": [{"id": "WJ", "items": [{"id": "8X", "data": {"title": "city", "source": {"datasetId": "v9ign8imt0qkk", "fieldType": "string", "showTitle": true, "elementType": "select", "datasetFieldId": "city", "datasetFieldType": "DIMENSION"}, "sourceType": "dataset"}, "type": "control", "defaults": {"city": ""}, "namespace": "default"}, {"id": "lV", "data": {"tabs": [{"id": "rX", "title": "city-sales - Column chart", "params": {}, "chartId": "zj7yw90fzy0so", "isDefault": true, "autoHeight": false, "description": ""}], "hideTitle": false}, "type": "widget", "namespace": "default"}], "title": "Tab 1", "layout": [{"h": 2, "i": "8X", "w": 8, "x": 0, "y": 0}, {"h": 12, "i": "lV", "w": 12, "x": 0, "y": 2}], "aliases": {}, "connections": []}, {"id": "2W", "items": [{"id": "RN", "data": {"title": "city", "source": {"datasetId": "v9ign8imt0qkk", "fieldType": "string", "showTitle": true, "elementType": "select", "datasetFieldId": "city", "datasetFieldType": "DIMENSION"}, "sourceType": "dataset"}, "type": "control", "defaults": {"city": ""}, "namespace": "default"}], "title": "Tab 2", "layout": [{"h": 2, "i": "RN", "w": 8, "x": 0, "y": 0}], "aliases": {}, "connections": []}, {"id": "z8", "items": [], "title": "Tab 3", "layout": [], "aliases": {}, "connections": []}, {"id": "yw", "items": [{"id": "gp", "data": {"tabs": [{"id": "71", "title": "city-sales — Pie chart", "params": {}, "chartId": "q9z7zsseqg2qf", "isDefault": true, "autoHeight": false, "description": ""}], "hideTitle": false}, "type": "widget", "namespace": "default"}, {"id": "0W", "data": {"title": "city", "source": {"datasetId": "v9ign8imt0qkk", "fieldType": "string", "showTitle": true, "elementType": "select", "datasetFieldId": "city", "datasetFieldType": "DIMENSION"}, "sourceType": "dataset"}, "type": "control", "defaults": {"city": ""}, "namespace": "default"}], "title": "Tab 4", "layout": [{"h": 12, "i": "gp", "w": 12, "x": 0, "y": 2}, {"h": 2, "i": "0W", "w": 8, "x": 0, "y": 0}], "aliases": {}, "connections": []}], "counter": 11, "settings": {"hideTabs": false, "expandTOC": false, "hideDashTitle": false, "silentLoading": false, "autoupdateInterval": null, "dependentSelectors": true, "maxConcurrentRequests": null}, "schemeVersion": 7}', '{"is_release": true}', 'uid:systemId', '2023-11-27 15:46:44.105431+00', 'uid:systemId', '2023-11-27 15:46:44.105431+00', 1563183580903900195, 1563181671883211803, '{"q9z7zsseqg2qf": "q9z7zsseqg2qf", "v9ign8imt0qkk": "v9ign8imt0qkk", "zj7yw90fzy0so": "zj7yw90fzy0so"}', NULL, NULL, NULL);
|
||
INSERT INTO public.revisions (data, meta, created_by, created_at, updated_by, updated_at, rev_id, entry_id, links, annotation, version, source_version) VALUES ('{"salt": "0.36915620496112234", "tabs": [{"id": "OZ", "items": [{"id": "1Y", "data": {"tabs": [{"id": "87", "title": "city-sales — Pie chart", "params": {}, "chartId": "q9z7zsseqg2qf", "isDefault": true, "autoHeight": false, "description": ""}], "hideTitle": false}, "type": "widget", "namespace": "default"}, {"id": "3j", "data": {"title": "city", "source": {"datasetId": "v9ign8imt0qkk", "fieldType": "string", "showTitle": true, "elementType": "select", "datasetFieldId": "city", "datasetFieldType": "DIMENSION"}, "sourceType": "dataset"}, "type": "control", "defaults": {"city": ""}, "namespace": "default"}], "title": "Tab 1", "layout": [{"h": 12, "i": "1Y", "w": 12, "x": 0, "y": 0}, {"h": 2, "i": "3j", "w": 8, "x": 0, "y": 12}], "aliases": {}, "connections": []}], "counter": 4, "settings": {"hideTabs": false, "expandTOC": false, "globalParams": {}, "loadPriority": "charts", "hideDashTitle": false, "silentLoading": false, "autoupdateInterval": null, "dependentSelectors": true, "maxConcurrentRequests": 1}, "schemeVersion": 7, "accessDescription": "", "supportDescription": ""}', '{"is_release": true}', 'uid:systemId', '2023-11-28 13:54:28.711633+00', 'uid:systemId', '2023-11-28 13:54:28.711633+00', 1563851856021554216, 1563082183126549507, '{"q9z7zsseqg2qf": "q9z7zsseqg2qf", "v9ign8imt0qkk": "v9ign8imt0qkk"}', NULL, NULL, NULL);
|
||
INSERT INTO public.revisions (data, meta, created_by, created_at, updated_by, updated_at, rev_id, entry_id, links, annotation, version, source_version) VALUES ('{"salt": "0.36915620496112234", "tabs": [{"id": "OZ", "items": [{"id": "1Y", "data": {"tabs": [{"id": "87", "title": "city-sales — Pie chart", "params": {}, "chartId": "q9z7zsseqg2qf", "isDefault": true, "autoHeight": false, "description": ""}], "hideTitle": false}, "type": "widget", "namespace": "default"}, {"id": "3j", "data": {"title": "city", "source": {"datasetId": "v9ign8imt0qkk", "fieldType": "string", "showTitle": true, "elementType": "select", "datasetFieldId": "city", "datasetFieldType": "DIMENSION"}, "sourceType": "dataset"}, "type": "control", "defaults": {"city": ""}, "namespace": "default"}], "title": "Tab 1", "layout": [{"h": 12, "i": "1Y", "w": 12, "x": 0, "y": 0}, {"h": 2, "i": "3j", "w": 8, "x": 0, "y": 12}], "aliases": {}, "connections": []}], "counter": 4, "settings": {"hideTabs": false, "expandTOC": false, "globalParams": {}, "loadPriority": "selectors", "hideDashTitle": false, "silentLoading": false, "autoupdateInterval": null, "dependentSelectors": true, "maxConcurrentRequests": 1}, "schemeVersion": 7, "accessDescription": "", "supportDescription": ""}', '{"is_release": true}', 'uid:systemId', '2023-11-28 13:54:38.902282+00', 'uid:systemId', '2023-11-28 13:54:38.902282+00', 1563851941518246954, 1563091972355261452, '{"q9z7zsseqg2qf": "q9z7zsseqg2qf", "v9ign8imt0qkk": "v9ign8imt0qkk"}', NULL, NULL, NULL);
|
||
INSERT INTO public.revisions (data, meta, created_by, created_at, updated_by, updated_at, rev_id, entry_id, links, annotation, version, source_version) VALUES ('{"salt": "0.4339758237715572", "tabs": [{"id": "vq", "items": [{"id": "dVR", "data": {"text": "More than 100 revisions"}, "type": "text", "namespace": "default"}], "title": "Tab 1", "layout": [{"h": 6, "i": "dVR", "w": 12, "x": 0, "y": 0}], "aliases": {}, "connections": []}], "counter": 187, "settings": {"hideTabs": false, "expandTOC": false, "hideDashTitle": false, "silentLoading": false, "autoupdateInterval": null, "dependentSelectors": true, "maxConcurrentRequests": null}, "schemeVersion": 7}', '{"is_release": true}', 'uid:systemId', '2023-12-01 16:38:13.241769+00', 'uid:systemId', '2023-12-01 16:38:13.241769+00', 1566108597295777669, 1566099212507022855, '{}', NULL, NULL, NULL);
|
||
INSERT INTO public.revisions (data, meta, created_by, created_at, updated_by, updated_at, rev_id, entry_id, links, annotation, version, source_version) VALUES ('{"rls": [], "name": "", "revision_id": null, "result_schema": [{"cast": "string", "guid": "ce812150-9414-11ee-aad3-bff95aad7d68", "type": "MEASURE", "title": "order_count", "valid": true, "hidden": false, "source": "order_id", "formula": "", "avatar_id": "14544d70-9414-11ee-aad3-bff95aad7d68", "calc_mode": "direct", "data_type": "integer", "managed_by": "user", "aggregation": "countunique", "description": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "integer", "guid": "9a7dda60-9414-11ee-aad3-bff95aad7d68", "type": "DIMENSION", "title": "order_year", "valid": true, "hidden": false, "source": "", "formula": "YEAR([order_date])", "avatar_id": null, "calc_mode": "formula", "data_type": "integer", "managed_by": "user", "aggregation": "none", "description": "", "guid_formula": "YEAR([order_date])", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "integer", "has_auto_aggregation": false}, {"cast": "integer", "guid": "id", "type": "DIMENSION", "title": "id", "valid": true, "hidden": false, "source": "id", "formula": "", "avatar_id": "14544d70-9414-11ee-aad3-bff95aad7d68", "calc_mode": "direct", "data_type": "integer", "managed_by": "user", "aggregation": "none", "description": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "integer", "has_auto_aggregation": false}, {"cast": "string", "guid": "order_id", "type": "DIMENSION", "title": "order_id", "valid": true, "hidden": false, "source": "order_id", "formula": "", "avatar_id": "14544d70-9414-11ee-aad3-bff95aad7d68", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "date", "guid": "order_date", "type": "DIMENSION", "title": "order_date", "valid": true, "hidden": false, "source": "order_date", "formula": "", "avatar_id": "14544d70-9414-11ee-aad3-bff95aad7d68", "calc_mode": "direct", "data_type": "date", "managed_by": "user", "aggregation": "none", "description": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "date", "has_auto_aggregation": false}, {"cast": "date", "guid": "ship_date", "type": "DIMENSION", "title": "ship_date", "valid": true, "hidden": false, "source": "ship_date", "formula": "", "avatar_id": "14544d70-9414-11ee-aad3-bff95aad7d68", "calc_mode": "direct", "data_type": "date", "managed_by": "user", "aggregation": "none", "description": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "date", "has_auto_aggregation": false}, {"cast": "string", "guid": "ship_mode", "type": "DIMENSION", "title": "ship_mode", "valid": true, "hidden": false, "source": "ship_mode", "formula": "", "avatar_id": "14544d70-9414-11ee-aad3-bff95aad7d68", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "customer_id", "type": "DIMENSION", "title": "customer_id", "valid": true, "hidden": false, "source": "customer_id", "formula": "", "avatar_id": "14544d70-9414-11ee-aad3-bff95aad7d68", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "customer_name", "type": "DIMENSION", "title": "customer_name", "valid": true, "hidden": false, "source": "customer_name", "formula": "", "avatar_id": "14544d70-9414-11ee-aad3-bff95aad7d68", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "segment", "type": "DIMENSION", "title": "segment", "valid": true, "hidden": false, "source": "segment", "formula": "", "avatar_id": "14544d70-9414-11ee-aad3-bff95aad7d68", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "country", "type": "DIMENSION", "title": "country", "valid": true, "hidden": false, "source": "country", "formula": "", "avatar_id": "14544d70-9414-11ee-aad3-bff95aad7d68", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "city", "type": "DIMENSION", "title": "city", "valid": true, "hidden": false, "source": "city", "formula": "", "avatar_id": "14544d70-9414-11ee-aad3-bff95aad7d68", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "state", "type": "DIMENSION", "title": "state", "valid": true, "hidden": false, "source": "state", "formula": "", "avatar_id": "14544d70-9414-11ee-aad3-bff95aad7d68", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "postal_code", "type": "DIMENSION", "title": "postal_code", "valid": true, "hidden": false, "source": "postal_code", "formula": "", "avatar_id": "14544d70-9414-11ee-aad3-bff95aad7d68", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "region", "type": "DIMENSION", "title": "region", "valid": true, "hidden": false, "source": "region", "formula": "", "avatar_id": "14544d70-9414-11ee-aad3-bff95aad7d68", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "product_id", "type": "DIMENSION", "title": "product_id", "valid": true, "hidden": false, "source": "product_id", "formula": "", "avatar_id": "14544d70-9414-11ee-aad3-bff95aad7d68", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "category", "type": "DIMENSION", "title": "category", "valid": true, "hidden": false, "source": "category", "formula": "", "avatar_id": "14544d70-9414-11ee-aad3-bff95aad7d68", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "sub_category", "type": "DIMENSION", "title": "sub_category", "valid": true, "hidden": false, "source": "sub_category", "formula": "", "avatar_id": "14544d70-9414-11ee-aad3-bff95aad7d68", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "product_name", "type": "DIMENSION", "title": "product_name", "valid": true, "hidden": false, "source": "product_name", "formula": "", "avatar_id": "14544d70-9414-11ee-aad3-bff95aad7d68", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "float", "guid": "sales", "type": "MEASURE", "title": "sales", "valid": true, "hidden": false, "source": "sales", "formula": "", "avatar_id": "14544d70-9414-11ee-aad3-bff95aad7d68", "calc_mode": "direct", "data_type": "float", "managed_by": "user", "aggregation": "sum", "description": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}], "source_avatars": [{"id": "14544d70-9414-11ee-aad3-bff95aad7d68", "title": "public.sales", "valid": true, "is_root": true, "source_id": "14544d71-9414-11ee-aad3-bff95aad7d68", "managed_by": "user"}], "avatar_relations": [], "component_errors": {"items": []}, "result_schema_aux": {"inter_dependencies": {"deps": [{"dep_field_id": "9a7dda60-9414-11ee-aad3-bff95aad7d68", "ref_field_ids": ["order_date"]}]}}, "obligatory_filters": [], "source_collections": [{"id": "14544d71-9414-11ee-aad3-bff95aad7d68", "type": "collection", "title": "sales", "valid": true, "origin": {"parameters": {"db_version": "PostgreSQL 13.12 on aarch64-unknown-linux-musl, compiled by gcc (Alpine 12.2.1_git20220924-r10) 12.2.1 20220924, 64-bit", "table_name": "sales", "schema_name": "public"}, "raw_schema": [{"name": "id", "type": "integer", "title": "id", "nullable": false, "description": "", "native_type": {"name": "integer", "nullable": false, "conn_type": "postgres", "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "order_id", "type": "string", "title": "order_id", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "conn_type": "postgres", "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "order_date", "type": "date", "title": "order_date", "nullable": false, "description": "", "native_type": {"name": "date", "nullable": false, "conn_type": "postgres", "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "ship_date", "type": "date", "title": "ship_date", "nullable": false, "description": "", "native_type": {"name": "date", "nullable": false, "conn_type": "postgres", "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "ship_mode", "type": "string", "title": "ship_mode", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "conn_type": "postgres", "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "customer_id", "type": "string", "title": "customer_id", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "conn_type": "postgres", "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "customer_name", "type": "string", "title": "customer_name", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "conn_type": "postgres", "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "segment", "type": "string", "title": "segment", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "conn_type": "postgres", "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "country", "type": "string", "title": "country", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "conn_type": "postgres", "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "city", "type": "string", "title": "city", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "conn_type": "postgres", "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "state", "type": "string", "title": "state", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "conn_type": "postgres", "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "postal_code", "type": "string", "title": "postal_code", "nullable": true, "description": "", "native_type": {"name": "text", "nullable": true, "conn_type": "postgres", "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "region", "type": "string", "title": "region", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "conn_type": "postgres", "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "product_id", "type": "string", "title": "product_id", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "conn_type": "postgres", "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "category", "type": "string", "title": "category", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "conn_type": "postgres", "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "sub_category", "type": "string", "title": "sub_category", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "conn_type": "postgres", "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "product_name", "type": "string", "title": "product_name", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "conn_type": "postgres", "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "sales", "type": "string", "title": "sales", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "conn_type": "postgres", "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}], "created_from": "PG_TABLE", "connection_id": "dr0y3yyi1gjk2"}, "sample": null, "managed_by": "user", "materialization": null}]}', '{"created_via": "user"}', 'uid:systemId', '2023-12-06 08:54:50.856997+00', 'uid:systemId', '2023-12-06 08:54:50.856997+00', 1569499252843873282, 1569499252818707457, '{"14544d71-9414-11ee-aad3-bff95aad7d68": "dr0y3yyi1gjk2"}', NULL, NULL, NULL);
|
||
INSERT INTO public.revisions (data, meta, created_by, created_at, updated_by, updated_at, rev_id, entry_id, links, annotation, version, source_version) VALUES ('{"salt": "0.5106241977949861", "tabs": [{"id": "kV", "items": [{"id": "4a", "data": {"text": "Delayed chart loading when it gets into viewport.\n\nIMPORTANT!\n\nWe change height of viewport in test for convenient check."}, "type": "text", "namespace": "default"}, {"id": "xJ", "data": {"tabs": [{"id": "BA", "title": "city-sales - Column chart", "params": {}, "chartId": "zj7yw90fzy0so", "isDefault": true, "autoHeight": false, "description": ""}], "hideTitle": false}, "type": "widget", "namespace": "default"}, {"id": "wy", "data": {"title": "test_control", "source": {"fieldName": "test_control", "showTitle": true, "elementType": "select", "acceptableValues": [{"title": "2", "value": "2"}, {"title": "1", "value": "1"}]}, "sourceType": "manual"}, "type": "control", "defaults": {"test_control": ""}, "namespace": "default"}], "title": "Tab 1", "layout": [{"h": 44, "i": "4a", "w": 12, "x": 0, "y": 0}, {"h": 12, "i": "xJ", "w": 12, "x": 0, "y": 44}, {"h": 2, "i": "wy", "w": 5, "x": 12, "y": 0}], "aliases": {}, "connections": []}], "counter": 7, "settings": {"hideTabs": false, "expandTOC": false, "hideDashTitle": false, "silentLoading": false, "autoupdateInterval": null, "dependentSelectors": true, "maxConcurrentRequests": null}, "schemeVersion": 7}', '{"is_release": true}', 'uid:systemId', '2023-12-15 13:39:28.360654+00', 'uid:systemId', '2023-12-15 13:39:28.360654+00', 1576165491062342658, 1563131447844275218, '{"zj7yw90fzy0so": "zj7yw90fzy0so"}', NULL, NULL, NULL);
|
||
INSERT INTO public.revisions (data, meta, created_by, created_at, updated_by, updated_at, rev_id, entry_id, links, annotation, version, source_version) VALUES ('{"js": "\nconst {buildGraph} = require(''libs/datalens/v3'');\n\nconst result = buildGraph({\n apiVersion: ''2'',\n data: ChartEditor.getLoadedData(),\n shared: ChartEditor.getSharedData(),\n params: ChartEditor.getParams(),\n actionParams: ChartEditor.getActionParams(),\n widgetConfig: ChartEditor.getWidgetConfig(),\n ChartEditor,\n});\n\n// your code here\n\nmodule.exports = result;\n", "ui": "\nconst {buildUI} = require(''libs/datalens/v3'');\n\nif (buildUI) {\n const result = buildUI({\n shared: ChartEditor.getSharedData(),\n params: ChartEditor.getParams(),\n actionParams: ChartEditor.getActionParams(),\n widgetConfig: ChartEditor.getWidgetConfig(),\n ChartEditor\n });\n\n // your code here\n\n module.exports = result;\n}\n", "url": "\nconst {buildSources} = require(''libs/datalens/v3'');\n\nconst result = buildSources({\n apiVersion: ''2'',\n shared: ChartEditor.getSharedData(),\n params: ChartEditor.getParams(),\n ChartEditor\n});\n\n// your code here\n\nmodule.exports = result;\n", "graph": "\nconst {buildD3Config} = require(''libs/datalens/v3'');\n\nconst result = buildD3Config({\n shared: ChartEditor.getSharedData(),\n params: ChartEditor.getParams(),\n actionParams: ChartEditor.getActionParams(),\n widgetConfig: ChartEditor.getWidgetConfig(),\n ChartEditor\n});\n\n// your code here\n\nmodule.exports = result;\n", "params": "\nconst {buildParams} = require(''libs/datalens/v3'');\n\nif (buildParams) {\n const result = buildParams({\n shared: ChartEditor.getSharedData(),\n ChartEditor\n });\n\n // your code here\n\n module.exports = result;\n} else {\n // your code here\n\n module.exports = {};\n}\n", "shared": "{\n \"colors\": [\n {\n \"title\": \"category\",\n \"cast\": \"string\",\n \"virtual\": false,\n \"aggregation_locked\": false,\n \"autoaggregated\": false,\n \"aggregation\": \"none\",\n \"valid\": true,\n \"guid\": \"category\",\n \"lock_aggregation\": false,\n \"hidden\": false,\n \"initial_data_type\": \"string\",\n \"managed_by\": \"user\",\n \"has_auto_aggregation\": false,\n \"type\": \"DIMENSION\",\n \"data_type\": \"string\",\n \"description\": \"\",\n \"avatar_id\": \"5d2c0ee0-a3e9-11ee-b6c8-21f01d10c1bc\",\n \"source\": \"category\",\n \"calc_mode\": \"direct\",\n \"formula\": \"\",\n \"guid_formula\": \"\",\n \"datasetId\": \"d2apal9v1rhy1\",\n \"id\": \"inserted-1703593420973\",\n \"datasetName\": \"Copy test\"\n }\n ],\n \"colorsConfig\": {},\n \"datasetsIds\": [\n \"d2apal9v1rhy1\"\n ],\n \"datasetsPartialFields\": [\n [\n {\n \"guid\": \"92767bd0-a3e9-11ee-a854-33ef997c5983\",\n \"title\": \"title-92767bd0-a3e9-11ee-a854-33ef997c5983\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"73918c50-a3e9-11ee-a854-33ef997c5983\",\n \"title\": \"title-73918c50-a3e9-11ee-a854-33ef997c5983\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"id\",\n \"title\": \"id\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"order_id\",\n \"title\": \"order_id\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"order_date\",\n \"title\": \"order_date\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"ship_date\",\n \"title\": \"ship_date\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"ship_mode\",\n \"title\": \"ship_mode\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"customer_id\",\n \"title\": \"customer_id\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"customer_name\",\n \"title\": \"customer_name\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"segment\",\n \"title\": \"segment\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"country\",\n \"title\": \"country\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"city\",\n \"title\": \"city\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"state\",\n \"title\": \"state\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"postal_code\",\n \"title\": \"postal_code\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"region\",\n \"title\": \"region\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"product_id\",\n \"title\": \"product_id\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"category\",\n \"title\": \"category\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"sub_category\",\n \"title\": \"sub_category\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"product_name\",\n \"title\": \"product_name\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"sales\",\n \"title\": \"sales\",\n \"calc_mode\": \"direct\"\n }\n ]\n ],\n \"extraSettings\": {\n \"title\": \"\",\n \"titleMode\": \"show\",\n \"labelsPosition\": \"outside\"\n },\n \"filters\": [],\n \"geopointsConfig\": {},\n \"hierarchies\": [],\n \"labels\": [],\n \"links\": [],\n \"segments\": [],\n \"shapes\": [],\n \"shapesConfig\": {},\n \"sort\": [],\n \"tooltips\": [],\n \"type\": \"datalens\",\n \"updates\": [\n {\n \"action\": \"add_field\",\n \"field\": {\n \"title\": \"title-73918c50-a3e9-11ee-a854-33ef997c5983\",\n \"cast\": \"string\",\n \"virtual\": false,\n \"aggregation_locked\": false,\n \"autoaggregated\": false,\n \"aggregation\": \"none\",\n \"valid\": true,\n \"guid\": \"73918c50-a3e9-11ee-a854-33ef997c5983\",\n \"lock_aggregation\": false,\n \"hidden\": false,\n \"initial_data_type\": \"string\",\n \"managed_by\": \"user\",\n \"has_auto_aggregation\": false,\n \"type\": \"DIMENSION\",\n \"data_type\": \"string\",\n \"description\": \"\",\n \"avatar_id\": \"5d2c0ee0-a3e9-11ee-b6c8-21f01d10c1bc\",\n \"source\": \"country\",\n \"calc_mode\": \"direct\",\n \"formula\": \"\",\n \"guid_formula\": \"\",\n \"local\": true,\n \"quickFormula\": true,\n \"datasetId\": \"d2apal9v1rhy1\"\n },\n \"debug_info\": \"merged-update\"\n },\n {\n \"action\": \"add_field\",\n \"field\": {\n \"title\": \"title-92767bd0-a3e9-11ee-a854-33ef997c5983\",\n \"cast\": \"string\",\n \"virtual\": false,\n \"aggregation_locked\": false,\n \"autoaggregated\": false,\n \"aggregation\": \"countunique\",\n \"valid\": true,\n \"guid\": \"92767bd0-a3e9-11ee-a854-33ef997c5983\",\n \"lock_aggregation\": false,\n \"hidden\": false,\n \"initial_data_type\": \"string\",\n \"managed_by\": \"user\",\n \"has_auto_aggregation\": false,\n \"type\": \"MEASURE\",\n \"data_type\": \"integer\",\n \"description\": \"\",\n \"avatar_id\": \"5d2c0ee0-a3e9-11ee-b6c8-21f01d10c1bc\",\n \"source\": \"category\",\n \"calc_mode\": \"direct\",\n \"formula\": \"\",\n \"guid_formula\": \"\",\n \"local\": true,\n \"quickFormula\": true,\n \"originalTitle\": \"category\",\n \"fakeTitle\": \"category\",\n \"datasetId\": \"d2apal9v1rhy1\",\n \"id\": \"inserted-1703593408016\"\n }\n }\n ],\n \"version\": \"9\",\n \"visualization\": {\n \"id\": \"bar-x-d3\",\n \"type\": \"column\",\n \"name\": \"label_visualization-column\",\n \"iconProps\": {\n \"id\": \"visColumn\",\n \"width\": \"24\"\n },\n \"allowFilters\": true,\n \"allowColors\": true,\n \"allowSort\": true,\n \"allowSegments\": false,\n \"allowLabels\": true,\n \"availableLabelModes\": [\n \"absolute\"\n ],\n \"placeholders\": [\n {\n \"allowedTypes\": {},\n \"allowedDataTypes\": {},\n \"id\": \"x\",\n \"type\": \"x\",\n \"title\": \"section_x\",\n \"iconProps\": {},\n \"items\": [\n {\n \"title\": \"title-73918c50-a3e9-11ee-a854-33ef997c5983\",\n \"cast\": \"string\",\n \"virtual\": false,\n \"aggregation_locked\": false,\n \"autoaggregated\": false,\n \"aggregation\": \"none\",\n \"valid\": true,\n \"guid\": \"73918c50-a3e9-11ee-a854-33ef997c5983\",\n \"lock_aggregation\": false,\n \"hidden\": false,\n \"initial_data_type\": \"string\",\n \"managed_by\": \"user\",\n \"has_auto_aggregation\": false,\n \"type\": \"DIMENSION\",\n \"data_type\": \"string\",\n \"description\": \"\",\n \"avatar_id\": \"5d2c0ee0-a3e9-11ee-b6c8-21f01d10c1bc\",\n \"source\": \"country\",\n \"calc_mode\": \"direct\",\n \"formula\": \"\",\n \"guid_formula\": \"\",\n \"local\": true,\n \"quickFormula\": true,\n \"originalTitle\": \"country\",\n \"fakeTitle\": \"country\",\n \"datasetId\": \"d2apal9v1rhy1\",\n \"id\": \"dimension-1\",\n \"transformed\": true,\n \"datasetName\": \"Copy test\"\n }\n ],\n \"required\": false,\n \"capacity\": 2,\n \"settings\": {\n \"title\": \"off\",\n \"titleValue\": \"\",\n \"type\": \"linear\",\n \"grid\": \"on\",\n \"gridStep\": \"auto\",\n \"gridStepValue\": 50,\n \"hideLabels\": \"no\",\n \"labelsView\": \"auto\",\n \"holidays\": \"off\",\n \"axisFormatMode\": \"auto\",\n \"axisModeMap\": {\n \"category\": \"discrete\"\n }\n }\n },\n {\n \"allowedTypes\": {},\n \"allowedFinalTypes\": {},\n \"allowedDataTypes\": {},\n \"id\": \"y\",\n \"type\": \"y\",\n \"title\": \"section_y\",\n \"iconProps\": {},\n \"items\": [\n {\n \"title\": \"title-92767bd0-a3e9-11ee-a854-33ef997c5983\",\n \"cast\": \"string\",\n \"virtual\": false,\n \"aggregation_locked\": false,\n \"autoaggregated\": false,\n \"aggregation\": \"countunique\",\n \"valid\": true,\n \"guid\": \"92767bd0-a3e9-11ee-a854-33ef997c5983\",\n \"lock_aggregation\": false,\n \"hidden\": false,\n \"initial_data_type\": \"string\",\n \"managed_by\": \"user\",\n \"has_auto_aggregation\": false,\n \"type\": \"MEASURE\",\n \"data_type\": \"integer\",\n \"description\": \"\",\n \"avatar_id\": \"5d2c0ee0-a3e9-11ee-b6c8-21f01d10c1bc\",\n \"source\": \"category\",\n \"calc_mode\": \"direct\",\n \"formula\": \"\",\n \"guid_formula\": \"\",\n \"local\": true,\n \"quickFormula\": true,\n \"originalTitle\": \"category\",\n \"fakeTitle\": \"category\",\n \"datasetId\": \"d2apal9v1rhy1\",\n \"id\": \"inserted-1703593408016\"\n }\n ],\n \"settings\": {\n \"scale\": \"auto\",\n \"scaleValue\": \"min-max\",\n \"title\": \"off\",\n \"titleValue\": \"\",\n \"type\": \"linear\",\n \"grid\": \"on\",\n \"gridStep\": \"auto\",\n \"gridStepValue\": 50,\n \"hideLabels\": \"no\",\n \"labelsView\": \"auto\",\n \"nulls\": \"ignore\",\n \"axisFormatMode\": \"auto\",\n \"axisModeMap\": {\n \"92767bd0-a3e9-11ee-a854-33ef997c5983\": \"continuous\"\n }\n }\n }\n ],\n \"hidden\": false\n },\n \"convert\": false\n}"}', '{}', 'uid:systemId', '2023-12-26 12:23:55.260076+00', 'uid:systemId', '2023-12-26 12:23:55.260076+00', 1584099997413016579, 1584099997438182404, '{"dataset": "d2apal9v1rhy1"}', NULL, NULL, NULL);
|
||
INSERT INTO public.revisions (data, meta, created_by, created_at, updated_by, updated_at, rev_id, entry_id, links, annotation, version, source_version) VALUES ('{"rls": [], "name": "", "revision_id": "bT6hWe8mBEVDNNp7Huv4hN", "result_schema": [{"cast": "markup", "guid": "76d42e90-87db-11f0-88c1-4d9804635dcc", "type": "DIMENSION", "title": "invalid_field", "valid": true, "hidden": false, "source": "", "formula": "BOLD(''TEXT'')", "avatar_id": null, "calc_mode": "formula", "data_type": "markup", "managed_by": "user", "aggregation": "none", "description": "", "guid_formula": "BOLD(''TEXT'')", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "markup", "has_auto_aggregation": false}, {"cast": "integer", "guid": "id", "type": "DIMENSION", "title": "id", "valid": true, "hidden": false, "source": "id", "formula": "", "avatar_id": "c5722360-771e-11ee-8e59-ebba6a1f8b16", "calc_mode": "direct", "data_type": "integer", "managed_by": "user", "aggregation": "none", "description": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "integer", "has_auto_aggregation": false}, {"cast": "string", "guid": "order_id", "type": "DIMENSION", "title": "order_id", "valid": true, "hidden": false, "source": "order_id", "formula": "", "avatar_id": "c5722360-771e-11ee-8e59-ebba6a1f8b16", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "date", "guid": "order_date", "type": "DIMENSION", "title": "Order_date", "valid": true, "hidden": false, "source": "order_date", "formula": "", "avatar_id": "c5722360-771e-11ee-8e59-ebba6a1f8b16", "calc_mode": "direct", "data_type": "date", "managed_by": "user", "aggregation": "none", "description": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "date", "has_auto_aggregation": false}, {"cast": "date", "guid": "ship_date", "type": "DIMENSION", "title": "ship_date", "valid": true, "hidden": false, "source": "ship_date", "formula": "", "avatar_id": "c5722360-771e-11ee-8e59-ebba6a1f8b16", "calc_mode": "direct", "data_type": "date", "managed_by": "user", "aggregation": "none", "description": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "date", "has_auto_aggregation": false}, {"cast": "string", "guid": "ship_mode", "type": "DIMENSION", "title": "ship_mode", "valid": true, "hidden": false, "source": "ship_mode", "formula": "", "avatar_id": "c5722360-771e-11ee-8e59-ebba6a1f8b16", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "customer_id", "type": "DIMENSION", "title": "customer_id", "valid": true, "hidden": false, "source": "customer_id", "formula": "", "avatar_id": "c5722360-771e-11ee-8e59-ebba6a1f8b16", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "customer_name", "type": "DIMENSION", "title": "customer_name", "valid": true, "hidden": false, "source": "customer_name", "formula": "", "avatar_id": "c5722360-771e-11ee-8e59-ebba6a1f8b16", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "segment", "type": "DIMENSION", "title": "segment", "valid": true, "hidden": false, "source": "segment", "formula": "", "avatar_id": "c5722360-771e-11ee-8e59-ebba6a1f8b16", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "country", "type": "DIMENSION", "title": "country", "valid": true, "hidden": false, "source": "country", "formula": "", "avatar_id": "c5722360-771e-11ee-8e59-ebba6a1f8b16", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "city", "type": "DIMENSION", "title": "City", "valid": true, "hidden": false, "source": "city", "formula": "", "avatar_id": "c5722360-771e-11ee-8e59-ebba6a1f8b16", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "state", "type": "DIMENSION", "title": "state", "valid": true, "hidden": false, "source": "state", "formula": "", "avatar_id": "c5722360-771e-11ee-8e59-ebba6a1f8b16", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "postal_code", "type": "DIMENSION", "title": "postal_code", "valid": true, "hidden": false, "source": "postal_code", "formula": "", "avatar_id": "c5722360-771e-11ee-8e59-ebba6a1f8b16", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "region", "type": "DIMENSION", "title": "region", "valid": true, "hidden": false, "source": "region", "formula": "", "avatar_id": "c5722360-771e-11ee-8e59-ebba6a1f8b16", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "product_id", "type": "DIMENSION", "title": "product_id", "valid": true, "hidden": false, "source": "product_id", "formula": "", "avatar_id": "c5722360-771e-11ee-8e59-ebba6a1f8b16", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "category", "type": "DIMENSION", "title": "Category", "valid": true, "hidden": false, "source": "category", "formula": "", "avatar_id": "c5722360-771e-11ee-8e59-ebba6a1f8b16", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "sub_category", "type": "DIMENSION", "title": "sub_category", "valid": true, "hidden": false, "source": "sub_category", "formula": "", "avatar_id": "c5722360-771e-11ee-8e59-ebba6a1f8b16", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "product_name", "type": "DIMENSION", "title": "product_name", "valid": true, "hidden": false, "source": "product_name", "formula": "", "avatar_id": "c5722360-771e-11ee-8e59-ebba6a1f8b16", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "float", "guid": "sales", "type": "DIMENSION", "title": "Sales", "valid": true, "hidden": false, "source": "sales", "formula": "", "avatar_id": "c5722360-771e-11ee-8e59-ebba6a1f8b16", "calc_mode": "direct", "data_type": "float", "managed_by": "user", "aggregation": "none", "description": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}], "schema_version": "1", "source_avatars": [{"id": "c5722360-771e-11ee-8e59-ebba6a1f8b16", "title": "public.sales", "valid": true, "is_root": true, "source_id": "c5722361-771e-11ee-8e59-ebba6a1f8b16", "managed_by": "user"}], "avatar_relations": [], "component_errors": {"items": []}, "template_enabled": false, "result_schema_aux": {"inter_dependencies": {"deps": []}}, "obligatory_filters": [], "source_collections": [{"id": "c5722361-771e-11ee-8e59-ebba6a1f8b16", "title": "sales", "valid": true, "origin": {"parameters": {"db_version": "PostgreSQL 13.12 on aarch64-unknown-linux-musl, compiled by gcc (Alpine 12.2.1_git20220924-r10) 12.2.1 20220924, 64-bit", "table_name": "sales", "schema_name": "public"}, "raw_schema": [{"name": "id", "type": "integer", "title": "id", "nullable": false, "description": "", "native_type": {"name": "integer", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "order_id", "type": "string", "title": "order_id", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "order_date", "type": "date", "title": "order_date", "nullable": false, "description": "", "native_type": {"name": "date", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "ship_date", "type": "date", "title": "ship_date", "nullable": false, "description": "", "native_type": {"name": "date", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "ship_mode", "type": "string", "title": "ship_mode", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "customer_id", "type": "string", "title": "customer_id", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "customer_name", "type": "string", "title": "customer_name", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "segment", "type": "string", "title": "segment", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "country", "type": "string", "title": "country", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "city", "type": "string", "title": "city", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "state", "type": "string", "title": "state", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "postal_code", "type": "string", "title": "postal_code", "nullable": true, "description": "", "native_type": {"name": "text", "nullable": true, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "region", "type": "string", "title": "region", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "product_id", "type": "string", "title": "product_id", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "category", "type": "string", "title": "category", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "sub_category", "type": "string", "title": "sub_category", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "product_name", "type": "string", "title": "product_name", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "sales", "type": "string", "title": "sales", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}], "created_from": "PG_TABLE", "connection_id": "dr0y3yyi1gjk2"}, "sample": null, "managed_by": "user", "materialization": null}], "data_export_forbidden": false, "load_preview_by_default": true}', '{"created_via": "user"}', 'uid:ggd9ibtalgfq1', '2025-09-02 09:04:14.224204+00', 'uid:ggd9ibtalgfq1', '2025-09-02 09:04:14.224204+00', 2030461343559058688, 1542786306705196056, '{"c5722361-771e-11ee-8e59-ebba6a1f8b16": "dr0y3yyi1gjk2"}', NULL, NULL, NULL);
|
||
INSERT INTO public.revisions (data, meta, created_by, created_at, updated_by, updated_at, rev_id, entry_id, links, annotation, version, source_version) VALUES ('{"salt": "0.23673628089321608", "tabs": [{"id": "aL", "items": [{"id": "50", "data": {"tabs": [{"id": "W9", "title": "Copy test — Column chart", "params": {}, "chartId": "g5dsp4kkwud04", "isDefault": true, "autoHeight": false, "description": ""}], "hideTitle": true}, "type": "widget", "namespace": "default"}, {"id": "Ma", "data": {"title": "test", "source": {"fieldName": "test", "showTitle": true, "elementType": "select", "acceptableValues": [{"title": "2", "value": "2"}, {"title": "1", "value": "1"}]}, "sourceType": "manual"}, "type": "control", "defaults": {"test": ""}, "namespace": "default"}], "title": "Tab 1", "layout": [{"h": 12, "i": "50", "w": 12, "x": 0, "y": 2}, {"h": 2, "i": "Ma", "w": 8, "x": 0, "y": 0}], "aliases": {}, "connections": []}], "counter": 5, "settings": {"hideTabs": false, "expandTOC": false, "hideDashTitle": false, "silentLoading": false, "autoupdateInterval": null, "dependentSelectors": true, "maxConcurrentRequests": null}, "schemeVersion": 7}', '{"is_release": true}', 'uid:systemId', '2023-12-26 12:26:42.568072+00', 'uid:systemId', '2023-12-26 12:26:42.568072+00', 1584101401095570444, 1584100587778081798, '{"g5dsp4kkwud04": "g5dsp4kkwud04"}', NULL, NULL, NULL);
|
||
INSERT INTO public.revisions (data, meta, created_by, created_at, updated_by, updated_at, rev_id, entry_id, links, annotation, version, source_version) VALUES ('{"js": "\nconst {buildGraph} = require(''libs/datalens/v3'');\n\nconst result = buildGraph({\n apiVersion: ''2'',\n data: ChartEditor.getLoadedData(),\n shared: ChartEditor.getSharedData(),\n params: ChartEditor.getParams(),\n actionParams: ChartEditor.getActionParams(),\n widgetConfig: ChartEditor.getWidgetConfig(),\n ChartEditor,\n});\n\n// your code here\n\nmodule.exports = result;\n", "ui": "\nconst {buildUI} = require(''libs/datalens/v3'');\n\nif (buildUI) {\n const result = buildUI({\n shared: ChartEditor.getSharedData(),\n params: ChartEditor.getParams(),\n actionParams: ChartEditor.getActionParams(),\n widgetConfig: ChartEditor.getWidgetConfig(),\n ChartEditor\n });\n\n // your code here\n\n module.exports = result;\n}\n", "url": "\nconst {buildSources} = require(''libs/datalens/v3'');\n\nconst result = buildSources({\n apiVersion: ''2'',\n shared: ChartEditor.getSharedData(),\n params: ChartEditor.getParams(),\n ChartEditor\n});\n\n// your code here\n\nmodule.exports = result;\n", "graph": "\nconst {buildD3Config} = require(''libs/datalens/v3'');\n\nconst result = buildD3Config({\n shared: ChartEditor.getSharedData(),\n params: ChartEditor.getParams(),\n actionParams: ChartEditor.getActionParams(),\n widgetConfig: ChartEditor.getWidgetConfig(),\n ChartEditor\n});\n\n// your code here\n\nmodule.exports = result;\n", "params": "\nconst {buildParams} = require(''libs/datalens/v3'');\n\nif (buildParams) {\n const result = buildParams({\n shared: ChartEditor.getSharedData(),\n ChartEditor\n });\n\n // your code here\n\n module.exports = result;\n} else {\n // your code here\n\n module.exports = {};\n}\n", "shared": "{\n \"colors\": [\n {\n \"title\": \"category\",\n \"cast\": \"string\",\n \"virtual\": false,\n \"aggregation_locked\": false,\n \"autoaggregated\": false,\n \"aggregation\": \"none\",\n \"valid\": false,\n \"guid\": \"category\",\n \"lock_aggregation\": false,\n \"hidden\": false,\n \"initial_data_type\": \"string\",\n \"managed_by\": \"user\",\n \"has_auto_aggregation\": false,\n \"type\": \"DIMENSION\",\n \"data_type\": \"string\",\n \"description\": \"\",\n \"avatar_id\": \"5d2c0ee0-a3e9-11ee-b6c8-21f01d10c1bc\",\n \"source\": \"category\",\n \"calc_mode\": \"direct\",\n \"formula\": \"\",\n \"guid_formula\": \"\",\n \"datasetId\": \"d2apal9v1rhy1\",\n \"id\": \"inserted-1703593420973\",\n \"datasetName\": \"Copy test\"\n }\n ],\n \"colorsConfig\": {},\n \"datasetsIds\": [\n \"v9ign8imt0qkk\"\n ],\n \"datasetsPartialFields\": [\n [\n {\n \"guid\": \"id\",\n \"title\": \"id\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"order_id\",\n \"title\": \"order_id\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"order_date\",\n \"title\": \"order_date\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"ship_date\",\n \"title\": \"ship_date\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"ship_mode\",\n \"title\": \"ship_mode\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"customer_id\",\n \"title\": \"customer_id\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"customer_name\",\n \"title\": \"customer_name\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"segment\",\n \"title\": \"segment\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"country\",\n \"title\": \"country\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"city\",\n \"title\": \"city\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"state\",\n \"title\": \"state\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"postal_code\",\n \"title\": \"postal_code\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"region\",\n \"title\": \"region\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"product_id\",\n \"title\": \"product_id\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"category\",\n \"title\": \"category\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"sub_category\",\n \"title\": \"sub_category\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"product_name\",\n \"title\": \"product_name\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"sales\",\n \"title\": \"sales\",\n \"calc_mode\": \"direct\"\n }\n ]\n ],\n \"extraSettings\": {\n \"title\": \"\",\n \"titleMode\": \"show\",\n \"labelsPosition\": \"outside\"\n },\n \"filters\": [],\n \"geopointsConfig\": {},\n \"hierarchies\": [],\n \"labels\": [],\n \"links\": [],\n \"segments\": [],\n \"shapes\": [],\n \"shapesConfig\": {},\n \"sort\": [],\n \"tooltips\": [],\n \"type\": \"datalens\",\n \"updates\": [\n {\n \"action\": \"add_field\",\n \"field\": {\n \"title\": \"title-73918c50-a3e9-11ee-a854-33ef997c5983\",\n \"cast\": \"string\",\n \"virtual\": false,\n \"aggregation_locked\": false,\n \"autoaggregated\": false,\n \"aggregation\": \"none\",\n \"valid\": true,\n \"guid\": \"73918c50-a3e9-11ee-a854-33ef997c5983\",\n \"lock_aggregation\": false,\n \"hidden\": false,\n \"initial_data_type\": \"string\",\n \"managed_by\": \"user\",\n \"has_auto_aggregation\": false,\n \"type\": \"DIMENSION\",\n \"data_type\": \"string\",\n \"description\": \"\",\n \"avatar_id\": \"5d2c0ee0-a3e9-11ee-b6c8-21f01d10c1bc\",\n \"source\": \"country\",\n \"calc_mode\": \"direct\",\n \"formula\": \"\",\n \"guid_formula\": \"\",\n \"local\": true,\n \"quickFormula\": true,\n \"datasetId\": \"d2apal9v1rhy1\"\n },\n \"debug_info\": \"merged-update\"\n },\n {\n \"action\": \"add_field\",\n \"field\": {\n \"title\": \"title-92767bd0-a3e9-11ee-a854-33ef997c5983\",\n \"cast\": \"string\",\n \"virtual\": false,\n \"aggregation_locked\": false,\n \"autoaggregated\": false,\n \"aggregation\": \"countunique\",\n \"valid\": true,\n \"guid\": \"92767bd0-a3e9-11ee-a854-33ef997c5983\",\n \"lock_aggregation\": false,\n \"hidden\": false,\n \"initial_data_type\": \"string\",\n \"managed_by\": \"user\",\n \"has_auto_aggregation\": false,\n \"type\": \"MEASURE\",\n \"data_type\": \"integer\",\n \"description\": \"\",\n \"avatar_id\": \"5d2c0ee0-a3e9-11ee-b6c8-21f01d10c1bc\",\n \"source\": \"category\",\n \"calc_mode\": \"direct\",\n \"formula\": \"\",\n \"guid_formula\": \"\",\n \"local\": true,\n \"quickFormula\": true,\n \"originalTitle\": \"category\",\n \"fakeTitle\": \"category\",\n \"datasetId\": \"d2apal9v1rhy1\",\n \"id\": \"inserted-1703593408016\"\n }\n }\n ],\n \"version\": \"9\",\n \"visualization\": {\n \"id\": \"bar-x-d4\",\n \"type\": \"column\",\n \"name\": \"label_visualization-column\",\n \"iconProps\": {\n \"id\": \"visColumn\",\n \"width\": \"24\"\n },\n \"allowFilters\": true,\n \"allowColors\": true,\n \"allowSort\": true,\n \"allowSegments\": false,\n \"allowLabels\": true,\n \"availableLabelModes\": [\n \"absolute\"\n ],\n \"placeholders\": [\n {\n \"allowedTypes\": {},\n \"allowedDataTypes\": {},\n \"id\": \"x\",\n \"type\": \"x\",\n \"title\": \"section_x\",\n \"iconProps\": {},\n \"items\": [\n {\n \"title\": \"title-73918c50-a3e9-11ee-a854-33ef997c5983\",\n \"cast\": \"string\",\n \"virtual\": false,\n \"aggregation_locked\": false,\n \"autoaggregated\": false,\n \"aggregation\": \"none\",\n \"valid\": false,\n \"guid\": \"73918c50-a3e9-11ee-a854-33ef997c5983\",\n \"lock_aggregation\": false,\n \"hidden\": false,\n \"initial_data_type\": \"string\",\n \"managed_by\": \"user\",\n \"has_auto_aggregation\": false,\n \"type\": \"DIMENSION\",\n \"data_type\": \"string\",\n \"description\": \"\",\n \"avatar_id\": \"5d2c0ee0-a3e9-11ee-b6c8-21f01d10c1bc\",\n \"source\": \"country\",\n \"calc_mode\": \"direct\",\n \"formula\": \"\",\n \"guid_formula\": \"\",\n \"local\": true,\n \"quickFormula\": true,\n \"originalTitle\": \"country\",\n \"fakeTitle\": \"country\",\n \"datasetId\": \"d2apal9v1rhy1\",\n \"id\": \"dimension-1\",\n \"transformed\": true,\n \"datasetName\": \"Copy test\"\n }\n ],\n \"required\": false,\n \"capacity\": 2,\n \"settings\": {\n \"title\": \"off\",\n \"titleValue\": \"\",\n \"type\": \"linear\",\n \"grid\": \"on\",\n \"gridStep\": \"auto\",\n \"gridStepValue\": 50,\n \"hideLabels\": \"no\",\n \"labelsView\": \"auto\",\n \"holidays\": \"off\",\n \"axisFormatMode\": \"auto\",\n \"axisModeMap\": {\n \"category\": \"discrete\"\n }\n }\n },\n {\n \"allowedTypes\": {},\n \"allowedFinalTypes\": {},\n \"allowedDataTypes\": {},\n \"id\": \"y\",\n \"type\": \"y\",\n \"title\": \"section_y\",\n \"iconProps\": {},\n \"items\": [\n {\n \"title\": \"title-92767bd0-a3e9-11ee-a854-33ef997c5983\",\n \"cast\": \"string\",\n \"virtual\": false,\n \"aggregation_locked\": false,\n \"autoaggregated\": false,\n \"aggregation\": \"countunique\",\n \"valid\": false,\n \"guid\": \"92767bd0-a3e9-11ee-a854-33ef997c5983\",\n \"lock_aggregation\": false,\n \"hidden\": false,\n \"initial_data_type\": \"string\",\n \"managed_by\": \"user\",\n \"has_auto_aggregation\": false,\n \"type\": \"MEASURE\",\n \"data_type\": \"integer\",\n \"description\": \"\",\n \"avatar_id\": \"5d2c0ee0-a3e9-11ee-b6c8-21f01d10c1bc\",\n \"source\": \"category\",\n \"calc_mode\": \"direct\",\n \"formula\": \"\",\n \"guid_formula\": \"\",\n \"local\": true,\n \"quickFormula\": true,\n \"originalTitle\": \"category\",\n \"fakeTitle\": \"category\",\n \"datasetId\": \"d2apal9v1rhy1\",\n \"id\": \"inserted-1703593408016\"\n }\n ],\n \"settings\": {\n \"scale\": \"auto\",\n \"scaleValue\": \"min-max\",\n \"title\": \"off\",\n \"titleValue\": \"\",\n \"type\": \"linear\",\n \"grid\": \"on\",\n \"gridStep\": \"auto\",\n \"gridStepValue\": 50,\n \"hideLabels\": \"no\",\n \"labelsView\": \"auto\",\n \"nulls\": \"ignore\",\n \"axisFormatMode\": \"auto\"\n }\n }\n ],\n \"hidden\": false\n }\n}"}', '{}', 'uid:systemId', '2023-12-26 13:17:58.940207+00', 'uid:systemId', '2023-12-26 13:17:58.940207+00', 1584127207750501379, 1584126375416038401, '{"dataset": "v9ign8imt0qkk"}', NULL, NULL, NULL);
|
||
INSERT INTO public.revisions (data, meta, created_by, created_at, updated_by, updated_at, rev_id, entry_id, links, annotation, version, source_version) VALUES ('{"salt": "0.23673628089321608", "tabs": [{"id": "aL", "items": [{"id": "50", "data": {"tabs": [{"id": "W9", "title": "Copy test — Column chart", "params": {}, "chartId": "d2ayync0s6ly1", "isDefault": true, "autoHeight": false, "description": ""}], "hideTitle": true}, "type": "widget", "namespace": "default"}, {"id": "Ma", "data": {"title": "test", "source": {"fieldName": "test", "showTitle": true, "elementType": "select", "acceptableValues": [{"title": "2", "value": "2"}, {"title": "1", "value": "1"}]}, "sourceType": "manual"}, "type": "control", "defaults": {"test": ""}, "namespace": "default"}], "title": "Tab 1", "layout": [{"h": 12, "i": "50", "w": 12, "x": 0, "y": 2}, {"h": 2, "i": "Ma", "w": 8, "x": 0, "y": 0}], "aliases": {}, "connections": []}], "counter": 5, "settings": {"hideTabs": false, "expandTOC": false, "hideDashTitle": false, "silentLoading": false, "autoupdateInterval": null, "dependentSelectors": true, "maxConcurrentRequests": null}, "schemeVersion": 7}', '{"is_release": true}', 'uid:systemId', '2023-12-27 16:05:34.804879+00', 'uid:systemId', '2023-12-27 16:05:34.804879+00', 1584936338510054405, 1584936080057041922, '{"d2ayync0s6ly1": "d2ayync0s6ly1"}', NULL, NULL, NULL);
|
||
INSERT INTO public.revisions (data, meta, created_by, created_at, updated_by, updated_at, rev_id, entry_id, links, annotation, version, source_version) VALUES ('{"js": "\nconst {buildGraph} = require(''libs/datalens/v3'');\n\nconst result = buildGraph({\n apiVersion: ''2'',\n data: ChartEditor.getLoadedData(),\n shared: ChartEditor.getSharedData(),\n params: ChartEditor.getParams(),\n actionParams: ChartEditor.getActionParams(),\n widgetConfig: ChartEditor.getWidgetConfig(),\n ChartEditor,\n});\n\n// your code here\n\nmodule.exports = result;\n", "ui": "\nconst {buildUI} = require(''libs/datalens/v3'');\n\nif (buildUI) {\n const result = buildUI({\n shared: ChartEditor.getSharedData(),\n params: ChartEditor.getParams(),\n actionParams: ChartEditor.getActionParams(),\n widgetConfig: ChartEditor.getWidgetConfig(),\n ChartEditor\n });\n\n // your code here\n\n module.exports = result;\n}\n", "url": "\nconst {buildSources} = require(''libs/datalens/v3'');\n\nconst result = buildSources({\n apiVersion: ''2'',\n shared: ChartEditor.getSharedData(),\n params: ChartEditor.getParams(),\n ChartEditor\n});\n\n// your code here\n\nmodule.exports = result;\n", "table": "\nconst {buildChartsConfig} = require(''libs/datalens/v3'');\n\nconst result = buildChartsConfig({\n shared: ChartEditor.getSharedData(),\n params: ChartEditor.getParams(),\n actionParams: ChartEditor.getActionParams(),\n widgetConfig: ChartEditor.getWidgetConfig(),\n ChartEditor\n});\n\n// your code here\n\nmodule.exports = result;\n", "params": "\nconst {buildParams} = require(''libs/datalens/v3'');\n\nif (buildParams) {\n const result = buildParams({\n shared: ChartEditor.getSharedData(),\n ChartEditor\n });\n\n // your code here\n\n module.exports = result;\n} else {\n // your code here\n\n module.exports = {};\n}\n", "shared": "{\n \"colors\": [],\n \"colorsConfig\": {},\n \"datasetsIds\": [\n \"v9ign8imt0qkk\"\n ],\n \"datasetsPartialFields\": [\n [\n {\n \"guid\": \"id\",\n \"title\": \"id\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"order_id\",\n \"title\": \"order_id\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"order_date\",\n \"title\": \"order_date\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"ship_date\",\n \"title\": \"ship_date\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"ship_mode\",\n \"title\": \"ship_mode\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"customer_id\",\n \"title\": \"customer_id\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"customer_name\",\n \"title\": \"customer_name\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"segment\",\n \"title\": \"segment\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"country\",\n \"title\": \"country\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"city\",\n \"title\": \"city\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"state\",\n \"title\": \"state\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"postal_code\",\n \"title\": \"postal_code\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"region\",\n \"title\": \"region\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"product_id\",\n \"title\": \"product_id\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"category\",\n \"title\": \"category\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"sub_category\",\n \"title\": \"sub_category\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"product_name\",\n \"title\": \"product_name\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"sales\",\n \"title\": \"sales\",\n \"calc_mode\": \"direct\"\n }\n ]\n ],\n \"extraSettings\": {\n \"pagination\": \"on\",\n \"limit\": 10,\n \"titleMode\": \"hide\",\n \"title\": \"New chart\",\n \"legendMode\": \"show\",\n \"tooltipSum\": \"on\",\n \"totals\": \"off\",\n \"feed\": \"\",\n \"pivotFallback\": \"off\",\n \"navigatorSettings\": {\n \"isNavigatorAvailable\": false,\n \"selectedLines\": []\n }\n },\n \"filters\": [],\n \"geopointsConfig\": {},\n \"hierarchies\": [],\n \"labels\": [],\n \"links\": [],\n \"segments\": [],\n \"shapes\": [],\n \"shapesConfig\": {},\n \"sort\": [],\n \"tooltips\": [],\n \"type\": \"datalens\",\n \"updates\": [],\n \"version\": \"9\",\n \"visualization\": {\n \"id\": \"flatTable\",\n \"type\": \"table\",\n \"name\": \"label_visualization-flat-table\",\n \"iconProps\": {\n \"id\": \"visFlatTable\",\n \"width\": \"24\"\n },\n \"allowFilters\": true,\n \"allowColors\": true,\n \"allowSort\": true,\n \"placeholders\": [\n {\n \"allowedTypes\": {},\n \"id\": \"flat-table-columns\",\n \"type\": \"flat-table-columns\",\n \"title\": \"section_columns\",\n \"iconProps\": {},\n \"items\": [\n {\n \"managed_by\": \"user\",\n \"valid\": true,\n \"description\": \"\",\n \"title\": \"category\",\n \"cast\": \"string\",\n \"type\": \"DIMENSION\",\n \"aggregation\": \"none\",\n \"initial_data_type\": \"string\",\n \"has_auto_aggregation\": false,\n \"virtual\": false,\n \"data_type\": \"string\",\n \"aggregation_locked\": false,\n \"hidden\": false,\n \"guid\": \"category\",\n \"autoaggregated\": false,\n \"lock_aggregation\": false,\n \"avatar_id\": \"c5722360-771e-11ee-8e59-ebba6a1f8b16\",\n \"source\": \"category\",\n \"calc_mode\": \"direct\",\n \"formula\": \"\",\n \"guid_formula\": \"\",\n \"default_value\": null,\n \"value_constraint\": null,\n \"datasetId\": \"v9ign8imt0qkk\",\n \"id\": \"dimension-14\",\n \"datasetName\": \"Dataset\",\n \"columnSettings\": {\n \"width\": {\n \"mode\": \"percent\",\n \"value\": \"1\"\n }\n }\n },\n {\n \"managed_by\": \"user\",\n \"valid\": true,\n \"description\": \"\",\n \"title\": \"city\",\n \"cast\": \"string\",\n \"type\": \"DIMENSION\",\n \"aggregation\": \"none\",\n \"initial_data_type\": \"string\",\n \"has_auto_aggregation\": false,\n \"virtual\": false,\n \"data_type\": \"string\",\n \"aggregation_locked\": false,\n \"hidden\": false,\n \"guid\": \"city\",\n \"autoaggregated\": false,\n \"lock_aggregation\": false,\n \"avatar_id\": \"c5722360-771e-11ee-8e59-ebba6a1f8b16\",\n \"source\": \"city\",\n \"calc_mode\": \"direct\",\n \"formula\": \"\",\n \"guid_formula\": \"\",\n \"default_value\": null,\n \"value_constraint\": null,\n \"datasetId\": \"v9ign8imt0qkk\",\n \"id\": \"dimension-9\",\n \"datasetName\": \"Dataset\",\n \"columnSettings\": {}\n }\n ],\n \"required\": true,\n \"settings\": {\n \"groupping\": \"on\"\n }\n }\n ],\n \"allowLayerFilters\": false\n }\n}"}', '{}', 'uid:systemId', '2024-01-10 14:54:52.258283+00', 'uid:systemId', '2024-01-10 14:54:52.258283+00', 1595047610186466305, 1594995275397596161, '{"dataset": "v9ign8imt0qkk"}', NULL, NULL, NULL);
|
||
INSERT INTO public.revisions (data, meta, created_by, created_at, updated_by, updated_at, rev_id, entry_id, links, annotation, version, source_version) VALUES ('{"shared": "{\n \"colors\": [],\n \"colorsConfig\": {},\n \"datasetsIds\": [\n \"v9ign8imt0qkk\"\n ],\n \"datasetsPartialFields\": [\n [\n {\n \"guid\": \"id\",\n \"title\": \"id\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"order_id\",\n \"title\": \"order_id\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"order_date\",\n \"title\": \"Order_date\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"ship_date\",\n \"title\": \"ship_date\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"ship_mode\",\n \"title\": \"ship_mode\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"customer_id\",\n \"title\": \"customer_id\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"customer_name\",\n \"title\": \"customer_name\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"segment\",\n \"title\": \"segment\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"country\",\n \"title\": \"country\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"city\",\n \"title\": \"City\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"state\",\n \"title\": \"state\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"postal_code\",\n \"title\": \"postal_code\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"region\",\n \"title\": \"region\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"product_id\",\n \"title\": \"product_id\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"category\",\n \"title\": \"Category\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"sub_category\",\n \"title\": \"sub_category\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"product_name\",\n \"title\": \"product_name\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"sales\",\n \"title\": \"Sales\",\n \"calc_mode\": \"direct\"\n }\n ]\n ],\n \"extraSettings\": {\n \"pagination\": \"on\",\n \"limit\": 100\n },\n \"filters\": [],\n \"geopointsConfig\": {},\n \"hierarchies\": [],\n \"labels\": [],\n \"links\": [],\n \"segments\": [],\n \"shapes\": [],\n \"shapesConfig\": {},\n \"sort\": [],\n \"tooltips\": [],\n \"type\": \"datalens\",\n \"updates\": [],\n \"version\": \"11\",\n \"visualization\": {\n \"id\": \"flatTable\",\n \"type\": \"table\",\n \"name\": \"label_visualization-flat-table\",\n \"iconProps\": {\n \"id\": \"visFlatTable\",\n \"width\": \"24\"\n },\n \"allowFilters\": true,\n \"allowColors\": true,\n \"allowSort\": true,\n \"placeholders\": [\n {\n \"allowedTypes\": {},\n \"id\": \"flat-table-columns\",\n \"type\": \"flat-table-columns\",\n \"title\": \"section_columns\",\n \"iconProps\": {},\n \"items\": [\n {\n \"has_auto_aggregation\": false,\n \"data_type\": \"string\",\n \"hidden\": false,\n \"aggregation\": \"none\",\n \"autoaggregated\": false,\n \"description\": \"\",\n \"type\": \"DIMENSION\",\n \"title\": \"City\",\n \"guid\": \"city\",\n \"aggregation_locked\": false,\n \"initial_data_type\": \"string\",\n \"lock_aggregation\": false,\n \"valid\": true,\n \"virtual\": false,\n \"cast\": \"string\",\n \"managed_by\": \"user\",\n \"source\": \"city\",\n \"avatar_id\": \"c5722360-771e-11ee-8e59-ebba6a1f8b16\",\n \"calc_mode\": \"direct\",\n \"formula\": \"\",\n \"guid_formula\": \"\",\n \"default_value\": null,\n \"value_constraint\": null,\n \"datasetId\": \"v9ign8imt0qkk\",\n \"id\": \"inserted-1722933424260\",\n \"datasetName\": \"Dataset\"\n }\n ],\n \"required\": true,\n \"settings\": {\n \"groupping\": \"on\",\n \"axisModeMap\": {\n \"city\": \"discrete\"\n }\n }\n }\n ],\n \"allowLayerFilters\": false\n },\n \"convert\": false\n}"}', '{}', 'uid:systemId', '2024-08-06 08:37:13.819311+00', 'uid:systemId', '2024-08-06 08:37:13.819311+00', 1746335664061809666, 1746335664053421057, '{"dataset": "v9ign8imt0qkk"}', NULL, NULL, NULL);
|
||
INSERT INTO public.revisions (data, meta, created_by, created_at, updated_by, updated_at, rev_id, entry_id, links, annotation, version, source_version) VALUES ('{"salt": "0.7658878675955099", "tabs": [{"id": "6M", "items": [{"id": "WR", "data": {"size": "xl", "text": "Fixed Header", "showInTOC": true, "autoHeight": false, "background": {"color": "var(--g-color-base-positive-light)", "enabled": true}}, "type": "title", "namespace": "default"}, {"id": "av", "data": {"tabs": [{"id": "nw", "hint": "", "title": "city-sales - Column chart", "params": {}, "chartId": "zj7yw90fzy0so", "isDefault": true, "autoHeight": false, "background": {"color": "transparent"}, "enableHint": false, "description": "", "enableDescription": false}], "hideTitle": false}, "type": "widget", "namespace": "default"}, {"id": "vO", "data": {"size": "xl", "text": "Second fixed header", "showInTOC": true, "autoHeight": false, "background": {"color": "var(--g-color-base-utility-light)", "enabled": true}}, "type": "title", "namespace": "default"}, {"id": "5Z", "data": {"tabs": [{"id": "9g", "hint": "", "title": "Table with one column", "params": {}, "chartId": "yu8pwddfbvrul", "isDefault": true, "autoHeight": false, "background": {"color": "transparent"}, "enableHint": false, "description": "", "enableDescription": false}], "hideTitle": false}, "type": "widget", "namespace": "default"}], "title": "Both fixed groups", "layout": [{"h": 2, "i": "WR", "w": 36, "x": 0, "y": 0, "parent": "__fixHead"}, {"h": 13, "i": "av", "w": 36, "x": 0, "y": 2, "parent": "__fixGCont"}, {"h": 127, "i": "5Z", "w": 18, "x": 0, "y": 0}, {"h": 2, "i": "vO", "w": 36, "x": 0, "y": 0, "parent": "__fixGCont"}], "aliases": {}, "connections": []}, {"id": "Pg", "items": [{"id": "Mx", "data": {"size": "xl", "text": "Fixed Header", "showInTOC": true, "autoHeight": false, "background": {"color": "var(--g-color-base-positive-light)", "enabled": true}}, "type": "title", "namespace": "default"}, {"id": "lN", "data": {"size": "xl", "text": "Second fixed header", "showInTOC": true, "autoHeight": false, "background": {"color": "var(--g-color-base-utility-light)", "enabled": true}}, "type": "title", "namespace": "default"}, {"id": "Gw", "data": {"tabs": [{"id": "Ne", "hint": "", "title": "Table with one column", "params": {}, "chartId": "yu8pwddfbvrul", "isDefault": true, "autoHeight": false, "background": {"color": "transparent"}, "enableHint": false, "description": "", "enableDescription": false}], "hideTitle": false}, "type": "widget", "namespace": "default"}, {"id": "Ar", "data": {"text": "Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.", "autoHeight": false, "background": {"color": "transparent", "enabled": false}}, "type": "text", "namespace": "default"}, {"id": "DQ", "data": {"tabs": [{"id": "RG", "hint": "", "title": "city-sales — Pie chart", "params": {}, "chartId": "q9z7zsseqg2qf", "isDefault": true, "autoHeight": false, "background": {"color": "transparent"}, "enableHint": false, "description": "", "enableDescription": false}], "hideTitle": false}, "type": "widget", "namespace": "default"}, {"id": "JL", "data": {"text": "Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.", "autoHeight": false, "background": {"color": "var(--g-color-base-danger-light)", "enabled": true}}, "type": "text", "namespace": "default"}, {"id": "8g", "data": {"text": "Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.", "autoHeight": false, "background": {"color": "var(--g-color-base-utility-light)", "enabled": true}}, "type": "text", "namespace": "default"}, {"id": "YK", "data": {"text": "Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.", "autoHeight": false, "background": {"color": "transparent"}}, "type": "text", "namespace": "default"}, {"id": "jd", "data": {"text": "Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.", "autoHeight": false, "background": {"color": "like-chart-bg", "enabled": true}}, "type": "text", "namespace": "default"}, {"id": "Zw", "data": {"tabs": [{"id": "B3", "hint": "", "title": "city-sales - Column chart", "params": {}, "chartId": "zj7yw90fzy0so", "isDefault": true, "autoHeight": false, "background": {"color": "transparent"}, "enableHint": false, "description": "", "enableDescription": false}], "hideTitle": false}, "type": "widget", "namespace": "default"}, {"id": "3Q", "data": {"tabs": [{"id": "qp", "hint": "", "title": "city-sales - Table chart", "params": {}, "chartId": "1txnbnqns0e2p", "isDefault": true, "autoHeight": false, "background": {"color": "transparent"}, "enableHint": false, "description": "", "enableDescription": false}], "hideTitle": false}, "type": "widget", "namespace": "default"}], "title": "Overflown fixed header", "layout": [{"h": 2, "i": "Mx", "w": 36, "x": 0, "y": 0, "parent": "__fixHead"}, {"h": 2, "i": "lN", "w": 36, "x": 0, "y": 0, "parent": "__fixGCont"}, {"h": 25, "i": "Ar", "w": 8, "x": 0, "y": 2, "parent": "__fixGCont"}, {"h": 66, "i": "DQ", "w": 36, "x": 0, "y": 0}, {"h": 131, "i": "Gw", "w": 28, "x": 8, "y": 2, "parent": "__fixGCont"}, {"h": 25, "i": "JL", "w": 8, "x": 0, "y": 27, "parent": "__fixGCont"}, {"h": 25, "i": "8g", "w": 8, "x": 0, "y": 52, "parent": "__fixGCont"}, {"h": 25, "i": "YK", "w": 8, "x": 0, "y": 77, "parent": "__fixGCont"}, {"h": 31, "i": "jd", "w": 8, "x": 0, "y": 102, "parent": "__fixGCont"}, {"h": 25, "i": "Zw", "w": 36, "x": 0, "y": 133, "parent": "__fixGCont"}, {"h": 38, "i": "3Q", "w": 36, "x": 0, "y": 66}], "aliases": {}, "connections": []}, {"id": "KR", "items": [{"id": "OY", "data": {"tabs": [{"id": "Q8", "hint": "", "title": "city-sales - Column chart", "params": {}, "chartId": "zj7yw90fzy0so", "isDefault": true, "autoHeight": false, "background": {"color": "transparent"}, "enableHint": false, "description": "", "enableDescription": false}], "hideTitle": false}, "type": "widget", "namespace": "default"}, {"id": "xK", "data": {"size": "xl", "text": "Second fixed header", "showInTOC": true, "autoHeight": false, "background": {"color": "var(--g-color-base-utility-light)", "enabled": true}}, "type": "title", "namespace": "default"}, {"id": "XM", "data": {"tabs": [{"id": "1N", "hint": "", "title": "Table with one column", "params": {}, "chartId": "yu8pwddfbvrul", "isDefault": true, "autoHeight": false, "background": {"color": "transparent"}, "enableHint": false, "description": "", "enableDescription": false}], "hideTitle": false}, "type": "widget", "namespace": "default"}], "title": "Only second group", "layout": [{"h": 13, "i": "OY", "w": 36, "x": 0, "y": 2, "parent": "__fixGCont"}, {"h": 125, "i": "XM", "w": 19, "x": 0, "y": 0}, {"h": 2, "i": "xK", "w": 36, "x": 0, "y": 0, "parent": "__fixGCont"}], "aliases": {}, "connections": []}], "counter": 40, "settings": {"hideTabs": false, "expandTOC": false, "globalParams": {}, "loadPriority": "charts", "hideDashTitle": false, "silentLoading": false, "autoupdateInterval": null, "dependentSelectors": true, "loadOnlyVisibleCharts": true, "maxConcurrentRequests": null}}', '{"is_release": true}', 'uid:systemId', '2025-03-26 09:29:14.406613+00', 'uid:systemId', '2025-03-26 09:29:14.406613+00', 1914509811190334466, 1913957332736279553, '{"1txnbnqns0e2p": "1txnbnqns0e2p", "q9z7zsseqg2qf": "q9z7zsseqg2qf", "yu8pwddfbvrul": "yu8pwddfbvrul", "zj7yw90fzy0so": "zj7yw90fzy0so"}', NULL, NULL, NULL);
|
||
INSERT INTO public.revisions (data, meta, created_by, created_at, updated_by, updated_at, rev_id, entry_id, links, annotation, version, source_version) VALUES ('{"salt": "0.8050573806669066", "tabs": [{"id": "kl", "items": [{"id": "2z", "data": {"group": [{"id": "Aq", "title": "invalid_field", "width": "", "source": {"required": false, "showHint": false, "datasetId": "v9ign8imt0qkk", "fieldType": "string", "showTitle": true, "accentType": null, "elementType": "select", "datasetFieldId": "76d42e90-87db-11f0-88c1-4d9804635dcc", "titlePlacement": "left", "datasetFieldType": "DIMENSION"}, "defaults": {"76d42e90-87db-11f0-88c1-4d9804635dcc": ""}, "namespace": "default", "sourceType": "dataset", "placementMode": "auto"}], "autoHeight": false, "buttonApply": false, "buttonReset": false, "showGroupName": false, "updateControlsOnChange": false}, "type": "group_control", "namespace": "default"}], "title": "Tab 1", "layout": [{"h": 2, "i": "2z", "w": 8, "x": 0, "y": 0}], "aliases": {}, "connections": []}], "counter": 3, "settings": {"hideTabs": false, "expandTOC": false, "globalParams": {}, "loadPriority": "charts", "hideDashTitle": false, "silentLoading": false, "autoupdateInterval": null, "dependentSelectors": true, "loadOnlyVisibleCharts": true, "maxConcurrentRequests": null}, "schemeVersion": 8}', NULL, 'uid:ggd9ibtalgfq1', '2025-09-02 09:03:31.630248+00', 'uid:ggd9ibtalgfq1', '2025-09-02 09:03:31.630248+00', 2030460986330187006, 2030460986330187005, '{"v9ign8imt0qkk": "v9ign8imt0qkk"}', NULL, NULL, NULL);
|
||
INSERT INTO public.revisions (data, meta, created_by, created_at, updated_by, updated_at, rev_id, entry_id, links, annotation, version, source_version) VALUES ('{"salt": "0.6716238111186452", "tabs": [{"id": "zG", "items": [{"id": "A3", "data": {"size": "l", "text": "Test title with long long long long long long long long content", "showInTOC": true, "autoHeight": true, "background": {"color": "var(--g-color-base-warning-light)", "enabled": true}}, "type": "title", "namespace": "default"}, {"id": "Q6", "data": {"tabs": [{"id": "nk", "title": "Table 1", "params": {}, "chartId": "1txnbnqns0e2p", "isDefault": true, "autoHeight": true, "background": {"color": "transparent", "enabled": false}, "description": ""}, {"id": "2l", "title": "Table 2", "params": {}, "chartId": "q9z7zsseqg2qf", "autoHeight": false, "description": ""}], "hideTitle": false}, "type": "widget", "namespace": "default"}, {"id": "Vw", "data": {"group": [{"id": "lb", "title": "List with inner", "width": "", "source": {"required": false, "showHint": false, "fieldName": "test 1", "showTitle": true, "innerTitle": "Inner", "elementType": "select", "showInnerTitle": true, "titlePlacement": "left", "acceptableValues": [{"title": "test 3", "value": "test 3"}, {"title": "test 2", "value": "test 2"}, {"title": "test 1", "value": "test 1"}]}, "defaults": {"test 1": ""}, "namespace": "default", "sourceType": "manual", "placementMode": "auto"}, {"id": "mW", "title": "Input with top hint", "width": "", "source": {"hint": "Hint", "required": false, "showHint": true, "fieldName": "test 2", "showTitle": true, "elementType": "input", "titlePlacement": "top"}, "defaults": {"test 2": ""}, "namespace": "default", "sourceType": "manual", "placementMode": "auto"}, {"id": "Lv", "title": "Input with required", "width": "", "source": {"required": true, "showHint": false, "fieldName": "test 3", "showTitle": true, "innerTitle": "inner", "elementType": "input", "defaultValue": "default", "showInnerTitle": false, "titlePlacement": "left"}, "defaults": {"test 3": "default"}, "namespace": "default", "sourceType": "manual", "placementMode": "auto"}, {"id": "k5", "title": "Checkbox with hint", "width": "", "source": {"hint": "Hint", "required": false, "showHint": true, "fieldName": "test 4", "showTitle": true, "elementType": "checkbox", "defaultValue": "false"}, "defaults": {"test 4": "false"}, "namespace": "default", "sourceType": "manual", "placementMode": "auto"}, {"id": "Rz", "title": "Calendar", "width": "", "source": {"hint": "Hint", "isRange": true, "required": false, "showHint": true, "fieldName": "test 5", "showTitle": true, "innerTitle": "inner", "elementType": "date", "showInnerTitle": true, "titlePlacement": "left"}, "defaults": {"test 5": ""}, "namespace": "default", "sourceType": "manual", "placementMode": "auto"}, {"id": "D0", "title": "Simple Checkbox", "width": "", "source": {"required": false, "showHint": false, "fieldName": "test 6", "showTitle": false, "elementType": "checkbox", "defaultValue": "true"}, "defaults": {"test 6": "true"}, "namespace": "default", "sourceType": "manual", "placementMode": "auto"}], "autoHeight": true, "buttonApply": true, "buttonReset": true, "updateControlsOnChange": false}, "type": "group_control", "namespace": "default"}, {"id": "o6", "data": {"text": "# Title h1\n## Title h2\n### Title h3\n#### Title h4\n\n~~strikethrough~~\n\n_**bold and italic**_.\n\n[Link](https://docs.charts.yandex-team.ru)\n\n***\n\n> ## Quote.\n>\n> 1. Line 1.\n> 2. Line 2.\n>\n> End.\n\n---\n\n- Element 1\n - Element A\n - Element B\n- Element 2\n\n1. First\n 1. Nested\n 1. Nested\n1. Second\n\n---\n\nColumn on the left edge | The column on the right edge | The column is centered\n:--- | ---: | :---:\nText | Text | Text\n\n---\n\n{% cut \"**Text under cut**\" %}\n\nHere is the detailed text\n\n{% endcut %}\n\n{gray}(some gray text)\n{yellow}(some yellow text)\n{orange}(some orange text)\n{red}(some red text)\n{green}(some green text)\n{blue}(some blue text)\n{violet}(some violet text)\n\n[*key]: explanation of a term or abbreviation using the syntax of definitions.\nThe definition of the term may include a _base_ markup.\n\nUse [term](*key) in text\n\n", "autoHeight": true, "background": {"color": "var(--g-color-base-danger-light)", "enabled": true}}, "type": "text", "namespace": "default"}], "title": "Autoheight", "layout": [{"h": 2, "i": "A3", "w": 6, "x": 30, "y": 0}, {"h": 12, "i": "Q6", "w": 15, "x": 0, "y": 0}, {"h": 2, "i": "Vw", "w": 15, "x": 15, "y": 0}, {"h": 6, "i": "o6", "w": 15, "x": 15, "y": 8}], "aliases": {}, "connections": []}, {"id": "56", "items": [{"id": "vV", "data": {"size": "l", "text": "Test title with long long long long long long long long content", "showInTOC": false, "autoHeight": false, "background": {"color": "var(--g-color-base-warning-light)", "enabled": true}}, "type": "title", "namespace": "default"}, {"id": "yb", "data": {"text": "# Title h1\n## Title h2\n### Title h3\n#### Title h4\n\n~~strikethrough~~\n\n_**bold and italic**_.\n\n[Link](https://docs.charts.yandex-team.ru)\n\n***\n\n> ## Quote.\n>\n> 1. Line 1.\n> 2. Line 2.\n>\n> End.\n\n---\n\n- Element 1\n - Element A\n - Element B\n- Element 2\n\n1. First\n 1. Nested\n 1. Nested\n1. Second\n\n---\n\nColumn on the left edge | The column on the right edge | The column is centered\n:--- | ---: | :---:\nText | Text | Text\n\n---\n\n{% cut \"**Text under cut**\" %}\n\nHere is the detailed text\n\n{% endcut %}\n\n{gray}(some gray text)\n{yellow}(some yellow text)\n{orange}(some orange text)\n{red}(some red text)\n{green}(some green text)\n{blue}(some blue text)\n{violet}(some violet text)\n\n[*key]: explanation of a term or abbreviation using the syntax of definitions.\nThe definition of the term may include a _base_ markup.\n\nUse [term](*key) in text\n\n", "autoHeight": false, "background": {"color": "var(--g-color-base-danger-light)", "enabled": true}}, "type": "text", "orderId": 1, "namespace": "default", "defaultOrderId": 3}, {"id": "7e", "data": {"group": [{"id": "P3", "title": "List with inner", "width": "", "source": {"required": false, "showHint": false, "fieldName": "test 1", "showTitle": true, "innerTitle": "Inner", "elementType": "select", "showInnerTitle": true, "titlePlacement": "left", "acceptableValues": [{"title": "test 3", "value": "test 3"}, {"title": "test 2", "value": "test 2"}, {"title": "test 1", "value": "test 1"}]}, "defaults": {"test 1": ""}, "namespace": "default", "sourceType": "manual", "placementMode": "auto"}, {"id": "jr", "title": "Input with top hint", "width": "", "source": {"hint": "Hint", "required": false, "showHint": true, "fieldName": "test 2", "showTitle": true, "elementType": "input", "titlePlacement": "top"}, "defaults": {"test 2": ""}, "namespace": "default", "sourceType": "manual", "placementMode": "auto"}, {"id": "bp", "title": "Input with required", "width": "", "source": {"required": true, "showHint": false, "fieldName": "test 3", "showTitle": true, "innerTitle": "inner", "elementType": "input", "defaultValue": "default", "showInnerTitle": false, "titlePlacement": "left"}, "defaults": {"test 3": "default"}, "namespace": "default", "sourceType": "manual", "placementMode": "auto"}, {"id": "rA", "title": "Checkbox with hint", "width": "", "source": {"hint": "Hint", "required": false, "showHint": true, "fieldName": "test 4", "showTitle": true, "elementType": "checkbox", "defaultValue": "false"}, "defaults": {"test 4": "false"}, "namespace": "default", "sourceType": "manual", "placementMode": "auto"}, {"id": "8d", "title": "Calendar", "width": "", "source": {"hint": "Hint", "isRange": true, "required": false, "showHint": true, "fieldName": "test 5", "showTitle": true, "innerTitle": "inner", "elementType": "date", "showInnerTitle": true, "titlePlacement": "left"}, "defaults": {"test 5": ""}, "namespace": "default", "sourceType": "manual", "placementMode": "auto"}, {"id": "q8", "title": "Simple Checkbox", "width": "", "source": {"required": false, "showHint": false, "fieldName": "test 6", "showTitle": false, "elementType": "checkbox", "defaultValue": "true"}, "defaults": {"test 6": "true"}, "namespace": "default", "sourceType": "manual", "placementMode": "auto"}], "autoHeight": false, "buttonApply": true, "buttonReset": true, "updateControlsOnChange": false}, "type": "group_control", "orderId": 2, "namespace": "default", "defaultOrderId": 1}, {"id": "Go", "data": {"tabs": [{"id": "91", "title": "Table 1", "params": {}, "chartId": "1txnbnqns0e2p", "isDefault": true, "autoHeight": false, "background": {"color": "transparent", "enabled": false}, "description": ""}, {"id": "E9", "title": "Table 2", "params": {}, "chartId": "q9z7zsseqg2qf", "autoHeight": false, "description": ""}], "hideTitle": false}, "type": "widget", "orderId": 3, "namespace": "default", "defaultOrderId": 0}, {"id": "go", "data": {"tabs": [{"id": "0Q", "title": "Table with one tab", "params": {"city": ["Allen"], "category": ["Furniture"]}, "chartId": "1txnbnqns0e2p", "isDefault": true, "autoHeight": false, "background": {"color": "transparent", "enabled": false}, "description": ""}], "hideTitle": false}, "type": "widget", "namespace": "default"}, {"id": "Zq0", "data": {"tabs": [{"id": "d8", "title": "Table with one tab", "params": {"city": ["not-existing"]}, "chartId": "1txnbnqns0e2p", "isDefault": true, "autoHeight": false, "background": {"color": "transparent", "enabled": false}, "description": ""}], "hideTitle": true}, "type": "widget", "namespace": "default"}], "title": "Without autoheight", "layout": [{"h": 2, "i": "vV", "w": 7, "x": 29, "y": 0}, {"h": 12, "i": "Go", "w": 14, "x": 0, "y": 0}, {"h": 10, "i": "yb", "w": 15, "x": 14, "y": 5}, {"h": 5, "i": "7e", "w": 15, "x": 14, "y": 0}, {"h": 6, "i": "go", "w": 15, "x": 14, "y": 15}, {"h": 6, "i": "Zq0", "w": 15, "x": 14, "y": 21}], "aliases": {}, "connections": []}, {"id": "3A", "items": [{"id": "64", "data": {"text": "```mermaid\ngantt\n title A Gantt Diagram\n dateFormat YYYY-MM-DD\n section Section\n A task :a1, 2014-01-01, 30d\n Another task :after a1, 20d\n section Another\n Task in Another :2014-01-12, 12d\n another task :24d\n```", "autoHeight": false, "background": {"color": "", "enabled": false}}, "type": "text", "namespace": "default"}, {"id": "wE", "data": {"text": "", "autoHeight": false, "background": {"color": "", "enabled": false}}, "type": "text", "namespace": "default"}, {"id": "E59", "data": {"text": "{% list tabs %}\n\n- Название таба 1\n\n Текст таба 1.\n\n * Можно использовать списки.\n * Верхний^регистр^\n * Нижний~регистр~\n * Эмодзи 😄\n * ++Подчеркивание++\n * ##Моноширинный текст## \n\n- Название таба 2\n\n Текст таба 2.\n\n{% endlist %}\n\n```\nconst param = null;\n```\n\n{% cut \"Заголовок ката\" %}\n\nКонтент, который отобразится по нажатию.\n\n{% endcut %}", "autoHeight": false, "background": {"color": "", "enabled": true}}, "type": "text", "namespace": "default"}], "title": "Markdown", "layout": [{"h": 8, "i": "64", "w": 18, "x": 4, "y": 0}, {"h": 8, "i": "wE", "w": 4, "x": 0, "y": 0}, {"h": 14, "i": "E59", "w": 18, "x": 0, "y": 8}], "aliases": {}, "connections": []}, {"id": "zGG", "items": [{"id": "p21", "data": {"hint": {"text": "Hint", "enabled": true}, "size": "xs", "text": "Title XS", "showInTOC": true, "textColor": "var(--g-color-text-primary)", "autoHeight": false, "background": {"color": "transparent", "enabled": false}}, "type": "title", "namespace": "default"}, {"id": "3bA", "data": {"hint": {"text": "Hint", "enabled": true}, "size": "s", "text": "Title S", "showInTOC": true, "textColor": "var(--g-color-text-primary)", "autoHeight": false, "background": {"color": "transparent", "enabled": false}}, "type": "title", "namespace": "default"}, {"id": "Aj3", "data": {"hint": {"text": "Hint", "enabled": true}, "size": "m", "text": "Title M", "showInTOC": true, "textColor": "var(--g-color-text-primary)", "autoHeight": false, "background": {"color": "transparent", "enabled": false}}, "type": "title", "namespace": "default"}, {"id": "193", "data": {"hint": {"text": "Hint", "enabled": true}, "size": "l", "text": "Title L", "showInTOC": true, "textColor": "var(--g-color-text-primary)", "autoHeight": false, "background": {"color": "transparent", "enabled": false}}, "type": "title", "namespace": "default"}, {"id": "n3k", "data": {"hint": {"text": "Hint", "enabled": true}, "size": "xl", "text": "Title XL", "showInTOC": true, "textColor": "var(--g-color-text-primary)", "autoHeight": false, "background": {"color": "transparent", "enabled": false}}, "type": "title", "namespace": "default"}, {"id": "QW6", "data": {"hint": {"text": "Hint", "enabled": true}, "size": "xs", "text": "Title XS long long long long long long", "showInTOC": true, "textColor": "var(--g-color-text-primary)", "autoHeight": false, "background": {"color": "transparent", "enabled": false}}, "type": "title", "namespace": "default"}, {"id": "lqb", "data": {"hint": {"text": "Hint", "enabled": true}, "size": "s", "text": "Title S long long long", "showInTOC": true, "textColor": "var(--g-color-text-primary)", "autoHeight": false, "background": {"color": "transparent", "enabled": false}}, "type": "title", "namespace": "default"}, {"id": "m8W", "data": {"hint": {"text": "Hint", "enabled": true}, "size": "m", "text": "Title M long long long", "showInTOC": true, "textColor": "var(--g-color-text-primary)", "autoHeight": false, "background": {"color": "transparent", "enabled": false}}, "type": "title", "namespace": "default"}, {"id": "Lwv", "data": {"hint": {"text": "Hint", "enabled": true}, "size": "l", "text": "Title L long long long", "showInTOC": true, "textColor": "var(--g-color-text-primary)", "autoHeight": false, "background": {"color": "transparent", "enabled": false}}, "type": "title", "namespace": "default"}, {"id": "kQ5", "data": {"hint": {"text": "Hint", "enabled": true}, "size": "xl", "text": "Title XL long long long", "showInTOC": true, "textColor": "var(--g-color-text-primary)", "autoHeight": false, "background": {"color": "transparent", "enabled": false}}, "type": "title", "namespace": "default"}, {"id": "Rnz", "data": {"hint": {"text": "Hint", "enabled": true}, "size": "xs", "text": "Title XS long long long long long long", "showInTOC": true, "textColor": "var(--g-color-text-primary)", "autoHeight": false, "background": {"color": "var(--g-color-base-danger-medium-hover)", "enabled": true}}, "type": "title", "namespace": "default"}, {"id": "VLw", "data": {"hint": {"text": "Hint", "enabled": true}, "size": "s", "text": "Title S long long long", "showInTOC": true, "textColor": "var(--g-color-text-primary)", "autoHeight": false, "background": {"color": "var(--g-color-base-danger-medium-hover)", "enabled": true}}, "type": "title", "namespace": "default"}, {"id": "op6", "data": {"hint": {"text": "Hint", "enabled": true}, "size": "m", "text": "Title M long long long", "showInTOC": true, "textColor": "var(--g-color-text-primary)", "autoHeight": false, "background": {"color": "var(--g-color-base-danger-medium-hover)", "enabled": true}}, "type": "title", "namespace": "default"}, {"id": "5n6", "data": {"hint": {"text": "Hint", "enabled": true}, "size": "l", "text": "Title L long long long", "showInTOC": true, "textColor": "var(--g-color-text-primary)", "autoHeight": false, "background": {"color": "var(--g-color-base-danger-medium-hover)", "enabled": true}}, "type": "title", "namespace": "default"}, {"id": "vQV", "data": {"hint": {"text": "Hint", "enabled": true}, "size": "xl", "text": "Title XL long long long", "showInTOC": true, "textColor": "var(--g-color-text-primary)", "autoHeight": false, "background": {"color": "var(--g-color-base-danger-medium-hover)", "enabled": true}}, "type": "title", "namespace": "default"}, {"id": "G0o", "data": {"hint": {"text": "Hint", "enabled": true}, "size": "xs", "text": "Title XS long long long long long long", "showInTOC": true, "autoHeight": false, "background": {"color": "var(--g-color-base-danger-medium-hover)"}}, "type": "title", "namespace": "default"}, {"id": "9K1", "data": {"hint": {"text": "Hint", "enabled": true}, "size": "s", "text": "Title S long long long", "showInTOC": true, "autoHeight": false, "background": {"color": "var(--g-color-base-danger-medium-hover)"}}, "type": "title", "namespace": "default"}, {"id": "Wq5", "data": {"hint": {"text": "Hint", "enabled": true}, "size": "m", "text": "Title M long long long", "showInTOC": true, "autoHeight": false, "background": {"color": "var(--g-color-base-danger-medium-hover)"}}, "type": "title", "namespace": "default"}, {"id": "yRb", "data": {"hint": {"text": "Hint", "enabled": true}, "size": "l", "text": "Title L long long long", "showInTOC": true, "autoHeight": false, "background": {"color": "var(--g-color-base-danger-medium-hover)"}}, "type": "title", "namespace": "default"}, {"id": "6a4", "data": {"hint": {"text": "Hint", "enabled": true}, "size": "xl", "text": "Title XL long long long", "showInTOC": true, "autoHeight": false, "background": {"color": "var(--g-color-base-danger-medium-hover)"}}, "type": "title", "namespace": "default"}, {"id": "wRE", "data": {"hint": {"text": "Hint", "enabled": true}, "size": "xs", "text": "Title XS long long long long long long", "showInTOC": true, "textColor": "var(--g-color-text-primary)", "autoHeight": false, "background": {"color": "transparent", "enabled": false}}, "type": "title", "namespace": "default"}, {"id": "Dl0", "data": {"hint": {"text": "Hint", "enabled": true}, "size": "s", "text": "Title S long long long", "showInTOC": true, "textColor": "var(--g-color-text-primary)", "autoHeight": false, "background": {"color": "transparent", "enabled": false}}, "type": "title", "namespace": "default"}, {"id": "PW3", "data": {"hint": {"text": "Hint", "enabled": true}, "size": "m", "text": "Title M long long long", "showInTOC": true, "textColor": "var(--g-color-text-primary)", "autoHeight": false, "background": {"color": "transparent", "enabled": false}}, "type": "title", "namespace": "default"}, {"id": "jnr", "data": {"hint": {"text": "Hint", "enabled": true}, "size": "l", "text": "Title L long long long", "showInTOC": true, "textColor": "var(--g-color-text-primary)", "autoHeight": false, "background": {"color": "transparent", "enabled": false}}, "type": "title", "namespace": "default"}, {"id": "bqp", "data": {"hint": {"text": "Hint", "enabled": true}, "size": "xl", "text": "Title XL long long long", "showInTOC": true, "textColor": "var(--g-color-text-primary)", "autoHeight": false, "background": {"color": "transparent", "enabled": false}}, "type": "title", "namespace": "default"}, {"id": "rWA", "data": {"hint": {"text": "Hint", "enabled": true}, "size": "xs", "text": "Title XS", "showInTOC": true, "textColor": "var(--g-color-text-primary)", "autoHeight": false, "background": {"color": "var(--g-color-base-positive-medium-hover)", "enabled": true}}, "type": "title", "namespace": "default"}, {"id": "8Ld", "data": {"hint": {"text": "Hint", "enabled": true}, "size": "s", "text": "Title S", "showInTOC": true, "textColor": "var(--g-color-text-primary)", "autoHeight": false, "background": {"color": "var(--g-color-base-positive-medium-hover)", "enabled": true}}, "type": "title", "namespace": "default"}, {"id": "qn8", "data": {"hint": {"text": "Hint", "enabled": true}, "size": "m", "text": "Title M", "showInTOC": true, "textColor": "var(--g-color-text-primary)", "autoHeight": false, "background": {"color": "var(--g-color-base-positive-medium-hover)", "enabled": true}}, "type": "title", "namespace": "default"}, {"id": "7me", "data": {"hint": {"text": "Hint", "enabled": true}, "size": "l", "text": "Title L", "showInTOC": true, "textColor": "var(--g-color-text-primary)", "autoHeight": false, "background": {"color": "var(--g-color-base-positive-medium-hover)", "enabled": true}}, "type": "title", "namespace": "default"}, {"id": "23l", "data": {"hint": {"text": "Hint", "enabled": true}, "size": "xl", "text": "Title XL", "showInTOC": true, "textColor": "var(--g-color-text-primary)", "autoHeight": false, "background": {"color": "var(--g-color-base-positive-medium-hover)", "enabled": true}}, "type": "title", "namespace": "default"}], "title": "Headers with hints", "layout": [{"h": 2, "i": "p21", "w": 16, "x": 0, "y": 0}, {"h": 2, "i": "3bA", "w": 16, "x": 0, "y": 2}, {"h": 2, "i": "Aj3", "w": 16, "x": 0, "y": 4}, {"h": 2, "i": "193", "w": 16, "x": 0, "y": 6}, {"h": 2, "i": "n3k", "w": 16, "x": 0, "y": 8}, {"h": 2, "i": "QW6", "w": 6, "x": 0, "y": 10}, {"h": 2, "i": "lqb", "w": 6, "x": 0, "y": 12}, {"h": 2, "i": "m8W", "w": 6, "x": 0, "y": 14}, {"h": 2, "i": "Lwv", "w": 6, "x": 0, "y": 16}, {"h": 2, "i": "kQ5", "w": 6, "x": 0, "y": 18}, {"h": 2, "i": "Rnz", "w": 6, "x": 8, "y": 10}, {"h": 2, "i": "VLw", "w": 6, "x": 8, "y": 12}, {"h": 2, "i": "op6", "w": 6, "x": 8, "y": 14}, {"h": 2, "i": "5n6", "w": 6, "x": 8, "y": 16}, {"h": 2, "i": "vQV", "w": 6, "x": 8, "y": 18}, {"h": 6, "i": "G0o", "w": 4, "x": 0, "y": 20}, {"h": 6, "i": "9K1", "w": 4, "x": 5, "y": 20}, {"h": 6, "i": "Wq5", "w": 4, "x": 10, "y": 20}, {"h": 6, "i": "yRb", "w": 4, "x": 0, "y": 26}, {"h": 6, "i": "6a4", "w": 4, "x": 5, "y": 26}, {"h": 6, "i": "wRE", "w": 4, "x": 18, "y": 10}, {"h": 6, "i": "Dl0", "w": 4, "x": 23, "y": 10}, {"h": 6, "i": "PW3", "w": 4, "x": 28, "y": 10}, {"h": 6, "i": "jnr", "w": 4, "x": 18, "y": 16}, {"h": 6, "i": "bqp", "w": 4, "x": 23, "y": 16}, {"h": 2, "i": "rWA", "w": 20, "x": 16, "y": 0}, {"h": 2, "i": "8Ld", "w": 20, "x": 16, "y": 2}, {"h": 2, "i": "qn8", "w": 20, "x": 16, "y": 4}, {"h": 2, "i": "7me", "w": 20, "x": 16, "y": 6}, {"h": 2, "i": "23l", "w": 20, "x": 16, "y": 8}], "aliases": {}, "connections": []}], "counter": 76, "settings": {"hideTabs": false, "expandTOC": true, "globalParams": {}, "loadPriority": "charts", "hideDashTitle": false, "silentLoading": false, "autoupdateInterval": null, "dependentSelectors": true, "loadOnlyVisibleCharts": false, "maxConcurrentRequests": null}, "schemeVersion": 8, "accessDescription": "", "supportDescription": ""}', '{"is_release": true}', 'uid:044d9nm31cuyl', '2025-09-23 13:15:49.087065+00', 'uid:044d9nm31cuyl', '2025-09-23 13:15:49.087065+00', 2045808258962162690, 1788542674546983937, '{"1txnbnqns0e2p": "1txnbnqns0e2p", "q9z7zsseqg2qf": "q9z7zsseqg2qf"}', NULL, NULL, NULL);
|
||
INSERT INTO public.revisions (data, meta, created_by, created_at, updated_by, updated_at, rev_id, entry_id, links, annotation, version, source_version) VALUES ('{"shared": "{\n \"colors\": [],\n \"colorsConfig\": {},\n \"datasetsIds\": [\n \"wiuimfkr0lful\"\n ],\n \"datasetsPartialFields\": [\n [\n {\n \"guid\": \"ce812150-9414-11ee-aad3-bff95aad7d68\",\n \"title\": \"order_count\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"9a7dda60-9414-11ee-aad3-bff95aad7d68\",\n \"title\": \"order_year\",\n \"calc_mode\": \"formula\"\n },\n {\n \"guid\": \"id\",\n \"title\": \"id\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"order_id\",\n \"title\": \"order_id\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"order_date\",\n \"title\": \"order_date\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"ship_date\",\n \"title\": \"ship_date\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"ship_mode\",\n \"title\": \"ship_mode\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"customer_id\",\n \"title\": \"customer_id\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"customer_name\",\n \"title\": \"customer_name\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"segment\",\n \"title\": \"segment\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"country\",\n \"title\": \"country\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"city\",\n \"title\": \"city\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"state\",\n \"title\": \"state\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"postal_code\",\n \"title\": \"postal_code\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"region\",\n \"title\": \"region\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"product_id\",\n \"title\": \"product_id\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"category\",\n \"title\": \"category\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"sub_category\",\n \"title\": \"sub_category\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"product_name\",\n \"title\": \"product_name\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"sales\",\n \"title\": \"sales\",\n \"calc_mode\": \"direct\"\n }\n ]\n ],\n \"extraSettings\": {},\n \"filters\": [],\n \"geopointsConfig\": {},\n \"hierarchies\": [],\n \"labels\": [],\n \"links\": [],\n \"segments\": [],\n \"shapes\": [],\n \"shapesConfig\": {},\n \"sort\": [],\n \"tooltips\": [],\n \"type\": \"datalens\",\n \"updates\": [],\n \"version\": \"15\",\n \"visualization\": {\n \"id\": \"metric\",\n \"type\": \"metric\",\n \"name\": \"label_visualization-metric\",\n \"iconProps\": {\n \"id\": \"visMetric\",\n \"width\": \"24\"\n },\n \"allowFilters\": true,\n \"allowLabels\": false,\n \"allowSort\": false,\n \"placeholders\": [\n {\n \"allowedTypes\": {},\n \"allowedFinalTypes\": {},\n \"allowedDataTypes\": {},\n \"id\": \"measures\",\n \"type\": \"measures\",\n \"title\": \"section_measure\",\n \"iconProps\": {},\n \"items\": [\n {\n \"type\": \"MEASURE\",\n \"guid\": \"ce812150-9414-11ee-aad3-bff95aad7d68\",\n \"autoaggregated\": false,\n \"cast\": \"string\",\n \"virtual\": false,\n \"title\": \"order_count\",\n \"has_auto_aggregation\": false,\n \"data_type\": \"integer\",\n \"description\": \"\",\n \"managed_by\": \"user\",\n \"initial_data_type\": \"string\",\n \"ui_settings\": \"\",\n \"aggregation\": \"countunique\",\n \"aggregation_locked\": false,\n \"hidden\": false,\n \"valid\": true,\n \"lock_aggregation\": false,\n \"source\": \"order_id\",\n \"avatar_id\": \"14544d70-9414-11ee-aad3-bff95aad7d68\",\n \"calc_mode\": \"direct\",\n \"formula\": \"\",\n \"guid_formula\": \"\",\n \"default_value\": null,\n \"value_constraint\": null,\n \"datasetId\": \"wiuimfkr0lful\",\n \"id\": \"inserted-1765292273087\",\n \"datasetName\": \"Orders\"\n }\n ],\n \"required\": true,\n \"capacity\": 1,\n \"settings\": {\n \"axisModeMap\": {\n \"ce812150-9414-11ee-aad3-bff95aad7d68\": \"continuous\"\n }\n }\n }\n ],\n \"allowLayerFilters\": false\n },\n \"convert\": false\n}"}', '{}', 'uid:8rmnmzedo7hut', '2025-12-09 14:58:00.43496+00', 'uid:8rmnmzedo7hut', '2025-12-09 14:58:00.43496+00', 2101667423580062722, 2101667423580062721, '{"dataset": "wiuimfkr0lful"}', '{"description": ""}', NULL, NULL);
|
||
INSERT INTO public.revisions (data, meta, created_by, created_at, updated_by, updated_at, rev_id, entry_id, links, annotation, version, source_version) VALUES ('{"salt": "0.38033338105048997", "tabs": [{"id": "1j", "items": [{"id": "0V", "data": {"size": "xs", "text": "Title", "showInTOC": true, "textColor": "var(--g-color-text-primary)", "autoHeight": false, "background": {"color": "transparent"}}, "type": "title", "namespace": "default"}], "title": "Tab 1", "layout": [{"h": 2, "i": "0V", "w": 36, "x": 0, "y": 0}], "aliases": {}, "connections": []}], "counter": 2, "settings": {"hideTabs": false, "expandTOC": false, "globalParams": {}, "loadPriority": "charts", "hideDashTitle": false, "silentLoading": false, "autoupdateInterval": null, "dependentSelectors": true, "loadOnlyVisibleCharts": true, "maxConcurrentRequests": null}, "schemeVersion": 8}', NULL, 'uid:8rmnmzedo7hut', '2025-12-09 15:05:54.410381+00', 'uid:8rmnmzedo7hut', '2025-12-09 15:05:54.410381+00', 2101671399562150915, 2101671399587316740, '{}', '{"description": ""}', NULL, NULL);
|
||
INSERT INTO public.revisions (data, meta, created_by, created_at, updated_by, updated_at, rev_id, entry_id, links, annotation, version, source_version) VALUES ('{"salt": "0.389402992795965", "tabs": [{"id": "N3", "items": [{"id": "jb", "data": {"size": "xs", "text": "With `background: \"transparent\"` incorrect config (should be transparent)", "showInTOC": true, "autoHeight": false, "background": "transparent"}, "type": "title", "namespace": "default"}, {"id": "o0", "data": {"size": "xs", "text": "With `{color: \"transparent\", enabled: false}` config (should be transparent)", "showInTOC": true, "autoHeight": false, "background": {"color": "transparent", "enabled": false}}, "type": "title", "namespace": "default"}, {"id": "EQ", "data": {"size": "xs", "text": "With `{color: \"like-chart-bg\", enabled: false}` config (should be transparent)", "showInTOC": true, "autoHeight": false, "background": {"color": "like-chart-bg", "enabled": false}}, "type": "title", "namespace": "default"}, {"id": "7a", "data": {"size": "xs", "text": "With `{color: \"like-chart-bg\", enabled: true}` config (should be var(--g-color-base-float))", "showInTOC": true, "autoHeight": false, "background": {"color": "like-chart-bg", "enabled": true}}, "type": "title", "namespace": "default"}, {"id": "43", "data": {"size": "xs", "text": "With `{color: \"like-chart-bg\"}` config (should be var(--g-color-base-float))", "showInTOC": true, "autoHeight": false, "background": {"color": "like-chart-bg"}}, "type": "title", "namespace": "default"}, {"id": "v1", "data": {"size": "xs", "text": "With `{color: \"var(--g-color-base-info-light)\"}` config (should be var(--g-color-base-info-light))", "showInTOC": true, "autoHeight": false, "background": {"color": "var(--g-color-base-info-light)"}}, "type": "title", "namespace": "default"}, {"id": "py", "data": {"size": "xs", "text": "With `{color: \"var(--g-color-base-info-light)\", enabled: false}` config (should be transparent)", "showInTOC": true, "autoHeight": false, "background": {"color": "var(--g-color-base-info-light)", "enabled": false}}, "type": "title", "namespace": "default"}, {"id": "OY", "data": {"size": "xs", "text": "With duplicated `{color: \"var(--g-color-base-info-medium)\"}` config (should be var(--g-color-base-info-light-hover))", "showInTOC": true, "autoHeight": false, "background": {"color": "var(--g-color-base-info-medium)"}}, "type": "title", "namespace": "default"}, {"id": "23", "data": {"size": "xs", "text": "With duplicated `{color: \"var(--g-color-base-info-medium)\", enabled: false}` config (should be transparent)", "showInTOC": true, "autoHeight": false, "background": {"color": "var(--g-color-base-info-medium)", "enabled": false}}, "type": "title", "namespace": "default"}, {"id": "Zz", "data": {"size": "xs", "text": "With unknown `{color: \"test-color\"}` config (should be inherited from dash/org settings)", "showInTOC": true, "autoHeight": false, "background": {"color": "test-color"}}, "type": "title", "namespace": "default"}, {"id": "xo", "data": {"size": "xs", "text": "With unknown `{color: \"#00aa00\"}` config (should be green)", "showInTOC": true, "autoHeight": false, "background": {"color": "#00aa00"}}, "type": "title", "namespace": "default"}, {"id": "L5", "data": {"size": "xs", "text": "With `{color: \"var(--g-color-base-generic)\"}` config (should be var(--g-color-base-generic))", "showInTOC": true, "autoHeight": false, "background": {"color": "var(--g-color-base-generic)"}}, "type": "title", "namespace": "default"}], "title": "Title bg color", "layout": [{"h": 2, "i": "jb", "w": 22, "x": 0, "y": 0}, {"h": 2, "i": "o0", "w": 22, "x": 0, "y": 2}, {"h": 2, "i": "EQ", "w": 22, "x": 0, "y": 4}, {"h": 2, "i": "7a", "w": 22, "x": 0, "y": 6}, {"h": 2, "i": "43", "w": 22, "x": 0, "y": 8}, {"h": 2, "i": "v1", "w": 23, "x": 0, "y": 10}, {"h": 2, "i": "py", "w": 23, "x": 0, "y": 12}, {"h": 2, "i": "OY", "w": 28, "x": 0, "y": 14}, {"h": 2, "i": "23", "w": 28, "x": 0, "y": 16}, {"h": 2, "i": "Zz", "w": 28, "x": 0, "y": 18}, {"h": 2, "i": "xo", "w": 16, "x": 0, "y": 20}, {"h": 2, "i": "L5", "w": 23, "x": 0, "y": 22}], "aliases": {}, "connections": []}, {"id": "kQ", "items": [{"id": "rx", "data": {"size": "xs", "text": "With `textColor: undefined` config (should be primary)", "showInTOC": true, "autoHeight": false, "background": {"color": "transparent"}}, "type": "title", "namespace": "default"}, {"id": "A8", "data": {"size": "xs", "text": "With `textColor: \"var(--g-color-text-primary)\"` config (should be primary)", "showInTOC": true, "textColor": "var(--g-color-text-primary)", "autoHeight": false, "background": {"color": "transparent"}}, "type": "title", "namespace": "default"}, {"id": "b8", "data": {"size": "xs", "text": "With `textColor: \"var(--g-color-text-secondary)\"` config (should be secondary)", "showInTOC": true, "textColor": "var(--g-color-text-secondary)", "autoHeight": false, "background": {"color": "transparent"}}, "type": "title", "namespace": "default"}, {"id": "5e", "data": {"size": "xs", "text": "With `textColor: \"var(--g-color-text-info)\"` config (should be var(--g-color-text-info))", "showInTOC": true, "textColor": "var(--g-color-text-info)", "autoHeight": false, "background": {"color": "transparent"}}, "type": "title", "namespace": "default"}, {"id": "yk", "data": {"size": "xs", "text": "With `textColor: \"#00aa00\"` config (should be green)", "showInTOC": true, "textColor": "#00aa00", "autoHeight": false, "background": {"color": "transparent"}}, "type": "title", "namespace": "default"}], "title": "Title text color", "layout": [{"h": 2, "i": "rx", "w": 14, "x": 0, "y": 0}, {"h": 2, "i": "A8", "w": 18, "x": 0, "y": 2}, {"h": 2, "i": "b8", "w": 20, "x": 0, "y": 4}, {"h": 2, "i": "5e", "w": 21, "x": 0, "y": 6}, {"h": 2, "i": "yk", "w": 14, "x": 0, "y": 8}], "aliases": {}, "connections": []}, {"id": "g4", "items": [{"id": "PG", "data": {"tabs": [{"id": "ab", "hint": "", "title": "without bg (should be var(--g-color-base-float))", "params": {}, "chartId": "0jefiu7nb2vul", "isDefault": true, "autoHeight": true, "enableHint": false, "description": "", "enableDescription": false, "backgroundSettings": {}}], "hideTitle": false}, "type": "widget", "namespace": "default"}, {"id": "VA", "data": {"tabs": [{"id": "M3", "hint": "", "title": "with `{color: \"transparent\"}` on tab[0] (should be var(--g-color-base-float))", "params": {}, "chartId": "0jefiu7nb2vul", "isDefault": true, "autoHeight": true, "background": {"color": "transparent"}, "enableHint": false, "description": "", "enableDescription": false, "backgroundSettings": {}}], "hideTitle": false}, "type": "widget", "namespace": "default"}, {"id": "WD", "data": {"tabs": [{"id": "Y1", "hint": "", "title": "with `{color: \"transparent\"}` on data (should be var(--g-color-base-float))", "params": {}, "chartId": "0jefiu7nb2vul", "isDefault": true, "autoHeight": true, "enableHint": false, "description": "", "enableDescription": false, "backgroundSettings": {}}], "hideTitle": false, "background": {"color": "transparent"}}, "type": "widget", "namespace": "default"}, {"id": "Dk", "data": {"tabs": [{"id": "lg", "hint": "", "title": "with `{color: \"#00aa00\"}` on data (should be var(--g-color-base-float))", "params": {}, "chartId": "0jefiu7nb2vul", "isDefault": true, "autoHeight": true, "enableHint": false, "description": "", "enableDescription": false, "backgroundSettings": {}}], "hideTitle": false, "background": {"color": "#00aa00"}}, "type": "widget", "namespace": "default"}, {"id": "nv", "data": {"tabs": [{"id": "1K", "hint": "", "title": "with `{color: \"#00aa00\"}` on tabs[0] (should be var(--g-color-base-float))", "params": {}, "chartId": "0jefiu7nb2vul", "isDefault": true, "autoHeight": true, "background": {"color": "#00aa00"}, "enableHint": false, "description": "", "enableDescription": false}], "hideTitle": false}, "type": "widget", "namespace": "default"}], "title": "Chart bg color", "layout": [{"h": 7, "i": "PG", "w": 20, "x": 0, "y": 0}, {"h": 7, "i": "VA", "w": 20, "x": 0, "y": 7}, {"h": 7, "i": "WD", "w": 20, "x": 0, "y": 14}, {"h": 7, "i": "Dk", "w": 20, "x": 0, "y": 21}, {"h": 12, "i": "nv", "w": 20, "x": 0, "y": 28}], "aliases": {}, "connections": []}], "counter": 32, "settings": {"hideTabs": false, "expandTOC": false, "globalParams": {}, "loadPriority": "charts", "hideDashTitle": false, "silentLoading": false, "autoupdateInterval": null, "dependentSelectors": true, "loadOnlyVisibleCharts": true, "maxConcurrentRequests": null}, "schemeVersion": 8}', NULL, 'uid:8rmnmzedo7hut', '2025-12-09 15:10:49.811731+00', 'uid:8rmnmzedo7hut', '2025-12-09 15:10:49.811731+00', 2101673877674394634, 2101673877674394633, '{"0jefiu7nb2vul": "0jefiu7nb2vul"}', '{"description": ""}', NULL, NULL);
|
||
INSERT INTO public.revisions (data, meta, created_by, created_at, updated_by, updated_at, rev_id, entry_id, links, annotation, version, source_version) VALUES ('{"host": "{{POSTGRES_HOST}}", "name": null, "port": {{POSTGRES_PORT}}, "ssl_ca": null, "db_name": "{{POSTGRES_DB}}", "username": "{{POSTGRES_USER}}", "ssl_enable": false, "table_name": null, "cache_ttl_sec": null, "raw_sql_level": "off", "schema_version": "1", "enforce_collate": "auto", "sample_table_name": null, "data_export_forbidden": false}', '{}', 'uid:hdvqvrbwxbhy1', '2026-02-18 08:51:21.218707+00', 'uid:hdvqvrbwxbhy1', '2026-02-18 08:51:21.218707+00', 2152941957729485826, 2152941957729485825, '{}', '{"description": ""}', NULL, NULL);
|
||
INSERT INTO public.revisions (data, meta, created_by, created_at, updated_by, updated_at, rev_id, entry_id, links, annotation, version, source_version) VALUES ('{"rls": [], "name": "", "revision_id": null, "result_schema": [{"cast": "integer", "guid": "id", "type": "DIMENSION", "title": "id", "valid": true, "hidden": false, "source": "id", "formula": "", "avatar_id": "12f40610-0ca7-11f1-9773-955ef721cef5", "calc_mode": "direct", "data_type": "integer", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "integer", "has_auto_aggregation": false}, {"cast": "string", "guid": "order_id", "type": "DIMENSION", "title": "order_id", "valid": true, "hidden": false, "source": "order_id", "formula": "", "avatar_id": "12f40610-0ca7-11f1-9773-955ef721cef5", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "date", "guid": "order_date", "type": "DIMENSION", "title": "order_date", "valid": true, "hidden": false, "source": "order_date", "formula": "", "avatar_id": "12f40610-0ca7-11f1-9773-955ef721cef5", "calc_mode": "direct", "data_type": "date", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "date", "has_auto_aggregation": false}, {"cast": "date", "guid": "ship_date", "type": "DIMENSION", "title": "ship_date", "valid": true, "hidden": false, "source": "ship_date", "formula": "", "avatar_id": "12f40610-0ca7-11f1-9773-955ef721cef5", "calc_mode": "direct", "data_type": "date", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "date", "has_auto_aggregation": false}, {"cast": "string", "guid": "ship_mode", "type": "DIMENSION", "title": "ship_mode", "valid": true, "hidden": false, "source": "ship_mode", "formula": "", "avatar_id": "12f40610-0ca7-11f1-9773-955ef721cef5", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "customer_id", "type": "DIMENSION", "title": "customer_id", "valid": true, "hidden": false, "source": "customer_id", "formula": "", "avatar_id": "12f40610-0ca7-11f1-9773-955ef721cef5", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "customer_name", "type": "DIMENSION", "title": "customer_name", "valid": true, "hidden": false, "source": "customer_name", "formula": "", "avatar_id": "12f40610-0ca7-11f1-9773-955ef721cef5", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "segment", "type": "DIMENSION", "title": "segment", "valid": true, "hidden": false, "source": "segment", "formula": "", "avatar_id": "12f40610-0ca7-11f1-9773-955ef721cef5", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "country", "type": "DIMENSION", "title": "country", "valid": true, "hidden": false, "source": "country", "formula": "", "avatar_id": "12f40610-0ca7-11f1-9773-955ef721cef5", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "city", "type": "DIMENSION", "title": "city", "valid": true, "hidden": false, "source": "city", "formula": "", "avatar_id": "12f40610-0ca7-11f1-9773-955ef721cef5", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "state", "type": "DIMENSION", "title": "state", "valid": true, "hidden": false, "source": "state", "formula": "", "avatar_id": "12f40610-0ca7-11f1-9773-955ef721cef5", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "postal_code", "type": "DIMENSION", "title": "postal_code", "valid": true, "hidden": false, "source": "postal_code", "formula": "", "avatar_id": "12f40610-0ca7-11f1-9773-955ef721cef5", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "region", "type": "DIMENSION", "title": "region", "valid": true, "hidden": false, "source": "region", "formula": "", "avatar_id": "12f40610-0ca7-11f1-9773-955ef721cef5", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "product_id", "type": "DIMENSION", "title": "product_id", "valid": true, "hidden": false, "source": "product_id", "formula": "", "avatar_id": "12f40610-0ca7-11f1-9773-955ef721cef5", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "category", "type": "DIMENSION", "title": "category", "valid": true, "hidden": false, "source": "category", "formula": "", "avatar_id": "12f40610-0ca7-11f1-9773-955ef721cef5", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "sub_category", "type": "DIMENSION", "title": "sub_category", "valid": true, "hidden": false, "source": "sub_category", "formula": "", "avatar_id": "12f40610-0ca7-11f1-9773-955ef721cef5", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "product_name", "type": "DIMENSION", "title": "product_name", "valid": true, "hidden": false, "source": "product_name", "formula": "", "avatar_id": "12f40610-0ca7-11f1-9773-955ef721cef5", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "sales", "type": "DIMENSION", "title": "sales", "valid": true, "hidden": false, "source": "sales", "formula": "", "avatar_id": "12f40610-0ca7-11f1-9773-955ef721cef5", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}], "schema_version": "1", "source_avatars": [{"id": "12f40610-0ca7-11f1-9773-955ef721cef5", "title": "public.sales", "valid": true, "is_root": true, "source_id": "12f40611-0ca7-11f1-9773-955ef721cef5", "managed_by": "user"}], "avatar_relations": [], "component_errors": {"items": []}, "template_enabled": false, "result_schema_aux": {"inter_dependencies": {"deps": []}}, "obligatory_filters": [], "source_collections": [{"id": "12f40611-0ca7-11f1-9773-955ef721cef5", "title": "sales", "valid": true, "origin": {"parameters": {"db_version": "PostgreSQL 16.10 (Debian 16.10-1.pgdg13+1) on aarch64-unknown-linux-gnu, compiled by gcc (Debian 14.2.0-19) 14.2.0, 64-bit", "table_name": "sales", "schema_name": "public"}, "raw_schema": [{"name": "id", "type": "integer", "title": "id", "nullable": false, "description": "", "native_type": {"name": "integer", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "order_id", "type": "string", "title": "order_id", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "order_date", "type": "date", "title": "order_date", "nullable": false, "description": "", "native_type": {"name": "date", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "ship_date", "type": "date", "title": "ship_date", "nullable": false, "description": "", "native_type": {"name": "date", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "ship_mode", "type": "string", "title": "ship_mode", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "customer_id", "type": "string", "title": "customer_id", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "customer_name", "type": "string", "title": "customer_name", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "segment", "type": "string", "title": "segment", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "country", "type": "string", "title": "country", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "city", "type": "string", "title": "city", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "state", "type": "string", "title": "state", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "postal_code", "type": "string", "title": "postal_code", "nullable": true, "description": "", "native_type": {"name": "text", "nullable": true, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "region", "type": "string", "title": "region", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "product_id", "type": "string", "title": "product_id", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "category", "type": "string", "title": "category", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "sub_category", "type": "string", "title": "sub_category", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "product_name", "type": "string", "title": "product_name", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "sales", "type": "string", "title": "sales", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}], "created_from": "PG_TABLE", "connection_id": "51jfxy4rrxwup"}, "sample": null, "managed_by": "user", "materialization": null}], "data_export_forbidden": false, "load_preview_by_default": true}', '{"created_via": "user"}', 'uid:hdvqvrbwxbhy1', '2026-02-18 08:52:04.667466+00', 'uid:hdvqvrbwxbhy1', '2026-02-18 08:52:04.667466+00', 2152942322155783171, 2152942322155783172, '{"12f40611-0ca7-11f1-9773-955ef721cef5": "51jfxy4rrxwup"}', '{"description": ""}', NULL, NULL);
|
||
INSERT INTO public.revisions (data, meta, created_by, created_at, updated_by, updated_at, rev_id, entry_id, links, annotation, version, source_version) VALUES ('{"host": "{{POSTGRES_HOST}}", "name": null, "port": {{POSTGRES_PORT}}, "ssl_ca": null, "db_name": "{{POSTGRES_DB}}", "username": "{{POSTGRES_USER}}", "ssl_enable": false, "table_name": null, "cache_ttl_sec": null, "raw_sql_level": "dashsql", "schema_version": "1", "enforce_collate": "auto", "sample_table_name": null, "data_export_forbidden": true}', '{}', 'uid:57yarqirg9pqp', '2026-03-18 06:11:00.191327+00', 'uid:57yarqirg9pqp', '2026-03-18 06:11:00.191327+00', 2173154971145470980, 2173154851817522178, '{}', '{"description": ""}', NULL, NULL);
|
||
INSERT INTO public.revisions (data, meta, created_by, created_at, updated_by, updated_at, rev_id, entry_id, links, annotation, version, source_version) VALUES ('{"rls": [], "name": "", "revision_id": null, "result_schema": [{"cast": "integer", "guid": "id", "type": "DIMENSION", "title": "id", "valid": true, "hidden": false, "source": "id", "formula": "", "avatar_id": "43ac3e80-2291-11f1-a77c-c386756d0c0c", "calc_mode": "direct", "data_type": "integer", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "integer", "has_auto_aggregation": false}, {"cast": "string", "guid": "order_id", "type": "DIMENSION", "title": "order_id", "valid": true, "hidden": false, "source": "order_id", "formula": "", "avatar_id": "43ac3e80-2291-11f1-a77c-c386756d0c0c", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "date", "guid": "order_date", "type": "DIMENSION", "title": "order_date", "valid": true, "hidden": false, "source": "order_date", "formula": "", "avatar_id": "43ac3e80-2291-11f1-a77c-c386756d0c0c", "calc_mode": "direct", "data_type": "date", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "date", "has_auto_aggregation": false}, {"cast": "date", "guid": "ship_date", "type": "DIMENSION", "title": "ship_date", "valid": true, "hidden": false, "source": "ship_date", "formula": "", "avatar_id": "43ac3e80-2291-11f1-a77c-c386756d0c0c", "calc_mode": "direct", "data_type": "date", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "date", "has_auto_aggregation": false}, {"cast": "string", "guid": "ship_mode", "type": "DIMENSION", "title": "ship_mode", "valid": true, "hidden": false, "source": "ship_mode", "formula": "", "avatar_id": "43ac3e80-2291-11f1-a77c-c386756d0c0c", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "customer_id", "type": "DIMENSION", "title": "customer_id", "valid": true, "hidden": false, "source": "customer_id", "formula": "", "avatar_id": "43ac3e80-2291-11f1-a77c-c386756d0c0c", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "customer_name", "type": "DIMENSION", "title": "customer_name", "valid": true, "hidden": false, "source": "customer_name", "formula": "", "avatar_id": "43ac3e80-2291-11f1-a77c-c386756d0c0c", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "segment", "type": "DIMENSION", "title": "segment", "valid": true, "hidden": false, "source": "segment", "formula": "", "avatar_id": "43ac3e80-2291-11f1-a77c-c386756d0c0c", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "country", "type": "DIMENSION", "title": "country", "valid": true, "hidden": false, "source": "country", "formula": "", "avatar_id": "43ac3e80-2291-11f1-a77c-c386756d0c0c", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "city", "type": "DIMENSION", "title": "city", "valid": true, "hidden": false, "source": "city", "formula": "", "avatar_id": "43ac3e80-2291-11f1-a77c-c386756d0c0c", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "state", "type": "DIMENSION", "title": "state", "valid": true, "hidden": false, "source": "state", "formula": "", "avatar_id": "43ac3e80-2291-11f1-a77c-c386756d0c0c", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "postal_code", "type": "DIMENSION", "title": "postal_code", "valid": true, "hidden": false, "source": "postal_code", "formula": "", "avatar_id": "43ac3e80-2291-11f1-a77c-c386756d0c0c", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "region", "type": "DIMENSION", "title": "region", "valid": true, "hidden": false, "source": "region", "formula": "", "avatar_id": "43ac3e80-2291-11f1-a77c-c386756d0c0c", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "product_id", "type": "DIMENSION", "title": "product_id", "valid": true, "hidden": false, "source": "product_id", "formula": "", "avatar_id": "43ac3e80-2291-11f1-a77c-c386756d0c0c", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "category", "type": "DIMENSION", "title": "category", "valid": true, "hidden": false, "source": "category", "formula": "", "avatar_id": "43ac3e80-2291-11f1-a77c-c386756d0c0c", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "sub_category", "type": "DIMENSION", "title": "sub_category", "valid": true, "hidden": false, "source": "sub_category", "formula": "", "avatar_id": "43ac3e80-2291-11f1-a77c-c386756d0c0c", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "product_name", "type": "DIMENSION", "title": "product_name", "valid": true, "hidden": false, "source": "product_name", "formula": "", "avatar_id": "43ac3e80-2291-11f1-a77c-c386756d0c0c", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "sales", "type": "DIMENSION", "title": "sales", "valid": true, "hidden": false, "source": "sales", "formula": "", "avatar_id": "43ac3e80-2291-11f1-a77c-c386756d0c0c", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}], "schema_version": "1", "source_avatars": [{"id": "43ac3e80-2291-11f1-a77c-c386756d0c0c", "title": "public.sales", "valid": true, "is_root": true, "source_id": "43ac3e81-2291-11f1-a77c-c386756d0c0c", "managed_by": "user"}], "avatar_relations": [], "component_errors": {"items": []}, "template_enabled": false, "result_schema_aux": {"inter_dependencies": {"deps": []}}, "obligatory_filters": [], "source_collections": [{"id": "43ac3e81-2291-11f1-a77c-c386756d0c0c", "title": "sales", "valid": true, "origin": {"parameters": {"db_version": "PostgreSQL 16.13 (Debian 16.13-1.pgdg13+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 14.2.0-19) 14.2.0, 64-bit", "table_name": "sales", "schema_name": "public"}, "raw_schema": [{"name": "id", "type": "integer", "title": "id", "nullable": false, "description": "", "native_type": {"name": "integer", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "order_id", "type": "string", "title": "order_id", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "order_date", "type": "date", "title": "order_date", "nullable": false, "description": "", "native_type": {"name": "date", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "ship_date", "type": "date", "title": "ship_date", "nullable": false, "description": "", "native_type": {"name": "date", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "ship_mode", "type": "string", "title": "ship_mode", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "customer_id", "type": "string", "title": "customer_id", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "customer_name", "type": "string", "title": "customer_name", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "segment", "type": "string", "title": "segment", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "country", "type": "string", "title": "country", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "city", "type": "string", "title": "city", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "state", "type": "string", "title": "state", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "postal_code", "type": "string", "title": "postal_code", "nullable": true, "description": "", "native_type": {"name": "text", "nullable": true, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "region", "type": "string", "title": "region", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "product_id", "type": "string", "title": "product_id", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "category", "type": "string", "title": "category", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "sub_category", "type": "string", "title": "sub_category", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "product_name", "type": "string", "title": "product_name", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "sales", "type": "string", "title": "sales", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}], "created_from": "PG_TABLE", "connection_id": "mojx9uxysf5c6"}, "sample": null, "managed_by": "user", "materialization": null}], "data_export_forbidden": false, "load_preview_by_default": true}', '{"created_via": "user"}', 'uid:57yarqirg9pqp', '2026-03-18 06:15:16.337113+00', 'uid:57yarqirg9pqp', '2026-03-18 06:15:16.337113+00', 2173157119904187398, 2173157119904187397, '{"43ac3e81-2291-11f1-a77c-c386756d0c0c": "mojx9uxysf5c6"}', '{"description": ""}', NULL, NULL);
|
||
INSERT INTO public.revisions (data, meta, created_by, created_at, updated_by, updated_at, rev_id, entry_id, links, annotation, version, source_version) VALUES ('{"shared": "{\n \"colors\": [],\n \"colorsConfig\": {},\n \"datasetsIds\": [\n \"572glbehjmz2p\"\n ],\n \"datasetsPartialFields\": [\n [\n {\n \"guid\": \"e07ce5c0-2291-11f1-a77c-c386756d0c0c\",\n \"title\": \"title-e07ce5c0-2291-11f1-a77c-c386756d0c0c\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"id\",\n \"title\": \"id\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"order_id\",\n \"title\": \"order_id\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"order_date\",\n \"title\": \"order_date\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"ship_date\",\n \"title\": \"ship_date\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"ship_mode\",\n \"title\": \"ship_mode\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"customer_id\",\n \"title\": \"customer_id\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"customer_name\",\n \"title\": \"customer_name\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"segment\",\n \"title\": \"segment\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"country\",\n \"title\": \"country\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"city\",\n \"title\": \"city\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"state\",\n \"title\": \"state\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"postal_code\",\n \"title\": \"postal_code\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"region\",\n \"title\": \"region\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"product_id\",\n \"title\": \"product_id\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"category\",\n \"title\": \"category\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"sub_category\",\n \"title\": \"sub_category\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"product_name\",\n \"title\": \"product_name\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"sales\",\n \"title\": \"sales\",\n \"calc_mode\": \"direct\"\n }\n ]\n ],\n \"extraSettings\": {\n \"title\": \"\",\n \"titleMode\": \"show\",\n \"labelsPosition\": \"outside\"\n },\n \"filters\": [],\n \"geopointsConfig\": {},\n \"hierarchies\": [],\n \"labels\": [],\n \"links\": [],\n \"segments\": [],\n \"shapes\": [],\n \"shapesConfig\": {},\n \"sort\": [],\n \"tooltips\": [],\n \"type\": \"datalens\",\n \"updates\": [\n {\n \"action\": \"add_field\",\n \"field\": {\n \"autoaggregated\": false,\n \"virtual\": false,\n \"initial_data_type\": \"string\",\n \"valid\": true,\n \"aggregation_locked\": false,\n \"has_auto_aggregation\": false,\n \"title\": \"title-e07ce5c0-2291-11f1-a77c-c386756d0c0c\",\n \"ui_settings\": \"\",\n \"hidden\": false,\n \"cast\": \"string\",\n \"managed_by\": \"user\",\n \"lock_aggregation\": false,\n \"data_type\": \"integer\",\n \"guid\": \"e07ce5c0-2291-11f1-a77c-c386756d0c0c\",\n \"description\": \"\",\n \"type\": \"MEASURE\",\n \"aggregation\": \"countunique\",\n \"source\": \"sales\",\n \"avatar_id\": \"43ac3e80-2291-11f1-a77c-c386756d0c0c\",\n \"calc_mode\": \"direct\",\n \"formula\": \"\",\n \"guid_formula\": \"\",\n \"local\": true,\n \"quickFormula\": true,\n \"originalTitle\": \"sales\",\n \"fakeTitle\": \"sales\",\n \"datasetId\": \"572glbehjmz2p\",\n \"id\": \"inserted-1773814535935\"\n }\n }\n ],\n \"version\": \"15\",\n \"visualization\": {\n \"id\": \"column\",\n \"type\": \"column\",\n \"name\": \"label_visualization-column\",\n \"iconProps\": {\n \"id\": \"visColumn\",\n \"width\": \"24\"\n },\n \"allowFilters\": true,\n \"allowColors\": true,\n \"allowSort\": true,\n \"allowSegments\": true,\n \"allowLabels\": true,\n \"availableLabelModes\": [\n \"absolute\"\n ],\n \"placeholders\": [\n {\n \"allowedTypes\": {},\n \"allowedDataTypes\": {},\n \"id\": \"x\",\n \"type\": \"x\",\n \"title\": \"section_x\",\n \"iconProps\": {},\n \"items\": [\n {\n \"autoaggregated\": false,\n \"virtual\": false,\n \"initial_data_type\": \"string\",\n \"valid\": true,\n \"aggregation_locked\": false,\n \"has_auto_aggregation\": false,\n \"title\": \"city\",\n \"ui_settings\": \"\",\n \"hidden\": false,\n \"cast\": \"string\",\n \"managed_by\": \"user\",\n \"lock_aggregation\": false,\n \"data_type\": \"string\",\n \"guid\": \"city\",\n \"description\": \"\",\n \"type\": \"DIMENSION\",\n \"aggregation\": \"none\",\n \"source\": \"city\",\n \"avatar_id\": \"43ac3e80-2291-11f1-a77c-c386756d0c0c\",\n \"calc_mode\": \"direct\",\n \"formula\": \"\",\n \"guid_formula\": \"\",\n \"default_value\": null,\n \"value_constraint\": null,\n \"datasetId\": \"572glbehjmz2p\",\n \"id\": \"dimension-10\",\n \"datasetName\": \"e2e-forbidden-export-dataset\"\n }\n ],\n \"required\": false,\n \"capacity\": 2,\n \"settings\": {\n \"title\": \"off\",\n \"titleValue\": \"\",\n \"type\": \"linear\",\n \"grid\": \"on\",\n \"gridStep\": \"auto\",\n \"gridStepValue\": 50,\n \"hideLabels\": \"no\",\n \"labelsView\": \"auto\",\n \"holidays\": \"off\",\n \"axisLabelDateFormat\": \"DD.MM.YYYY\",\n \"axisLabelFormating\": {},\n \"axisFormatMode\": \"auto\",\n \"axisModeMap\": {\n \"city\": \"discrete\"\n },\n \"axisVisibility\": \"show\"\n }\n },\n {\n \"allowedTypes\": {},\n \"allowedFinalTypes\": {},\n \"allowedDataTypes\": {},\n \"id\": \"y\",\n \"type\": \"y\",\n \"title\": \"section_y\",\n \"iconProps\": {},\n \"items\": [\n {\n \"autoaggregated\": false,\n \"virtual\": false,\n \"initial_data_type\": \"string\",\n \"valid\": true,\n \"aggregation_locked\": false,\n \"has_auto_aggregation\": false,\n \"title\": \"title-e07ce5c0-2291-11f1-a77c-c386756d0c0c\",\n \"ui_settings\": \"\",\n \"hidden\": false,\n \"cast\": \"string\",\n \"managed_by\": \"user\",\n \"lock_aggregation\": false,\n \"data_type\": \"integer\",\n \"guid\": \"e07ce5c0-2291-11f1-a77c-c386756d0c0c\",\n \"description\": \"\",\n \"type\": \"MEASURE\",\n \"aggregation\": \"countunique\",\n \"source\": \"sales\",\n \"avatar_id\": \"43ac3e80-2291-11f1-a77c-c386756d0c0c\",\n \"calc_mode\": \"direct\",\n \"formula\": \"\",\n \"guid_formula\": \"\",\n \"local\": true,\n \"quickFormula\": true,\n \"originalTitle\": \"sales\",\n \"fakeTitle\": \"sales\",\n \"datasetId\": \"572glbehjmz2p\",\n \"id\": \"inserted-1773814535935\"\n }\n ],\n \"settings\": {\n \"scale\": \"auto\",\n \"scaleValue\": \"min-max\",\n \"title\": \"off\",\n \"titleValue\": \"\",\n \"type\": \"linear\",\n \"grid\": \"on\",\n \"gridStep\": \"auto\",\n \"gridStepValue\": 50,\n \"hideLabels\": \"no\",\n \"labelsView\": \"auto\",\n \"nulls\": \"ignore\",\n \"axisLabelDateFormat\": \"DD.MM.YYYY\",\n \"axisLabelFormating\": {},\n \"axisFormatMode\": \"auto\",\n \"axisVisibility\": \"show\",\n \"axisModeMap\": {\n \"e07ce5c0-2291-11f1-a77c-c386756d0c0c\": \"continuous\"\n }\n }\n }\n ]\n },\n \"convert\": false\n}"}', '{}', 'uid:57yarqirg9pqp', '2026-03-18 06:15:57.608547+00', 'uid:57yarqirg9pqp', '2026-03-18 06:15:57.608547+00', 2173157466043319304, 2173157466043319303, '{"dataset": "572glbehjmz2p"}', '{"description": ""}', NULL, NULL);
|
||
INSERT INTO public.revisions (data, meta, created_by, created_at, updated_by, updated_at, rev_id, entry_id, links, annotation, version, source_version) VALUES ('{"shared": "{\n \"colors\": [],\n \"colorsConfig\": {},\n \"datasetsIds\": [\n \"y0vg5dd7bnloi\"\n ],\n \"datasetsPartialFields\": [\n [\n {\n \"guid\": \"3783d9f0-2297-11f1-9fb3-dbe839a0643c\",\n \"title\": \"title-3783d9f0-2297-11f1-9fb3-dbe839a0643c\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"id\",\n \"title\": \"id\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"order_id\",\n \"title\": \"order_id\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"order_date\",\n \"title\": \"order_date\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"ship_date\",\n \"title\": \"ship_date\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"ship_mode\",\n \"title\": \"ship_mode\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"customer_id\",\n \"title\": \"customer_id\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"customer_name\",\n \"title\": \"customer_name\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"segment\",\n \"title\": \"segment\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"country\",\n \"title\": \"country\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"city\",\n \"title\": \"city\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"state\",\n \"title\": \"state\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"postal_code\",\n \"title\": \"postal_code\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"region\",\n \"title\": \"region\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"product_id\",\n \"title\": \"product_id\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"category\",\n \"title\": \"category\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"sub_category\",\n \"title\": \"sub_category\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"product_name\",\n \"title\": \"product_name\",\n \"calc_mode\": \"direct\"\n },\n {\n \"guid\": \"sales\",\n \"title\": \"sales\",\n \"calc_mode\": \"direct\"\n }\n ]\n ],\n \"extraSettings\": {\n \"title\": \"\",\n \"titleMode\": \"show\",\n \"labelsPosition\": \"outside\"\n },\n \"filters\": [],\n \"geopointsConfig\": {},\n \"hierarchies\": [],\n \"labels\": [],\n \"links\": [],\n \"segments\": [],\n \"shapes\": [],\n \"shapesConfig\": {},\n \"sort\": [],\n \"tooltips\": [],\n \"type\": \"datalens\",\n \"updates\": [\n {\n \"action\": \"add_field\",\n \"field\": {\n \"data_type\": \"integer\",\n \"lock_aggregation\": false,\n \"managed_by\": \"user\",\n \"aggregation_locked\": false,\n \"aggregation\": \"countunique\",\n \"hidden\": false,\n \"initial_data_type\": \"string\",\n \"virtual\": false,\n \"description\": \"\",\n \"type\": \"MEASURE\",\n \"has_auto_aggregation\": false,\n \"guid\": \"3783d9f0-2297-11f1-9fb3-dbe839a0643c\",\n \"title\": \"title-3783d9f0-2297-11f1-9fb3-dbe839a0643c\",\n \"autoaggregated\": false,\n \"cast\": \"string\",\n \"ui_settings\": \"\",\n \"valid\": true,\n \"source\": \"sales\",\n \"avatar_id\": \"12ae3990-2297-11f1-9fb3-dbe839a0643c\",\n \"calc_mode\": \"direct\",\n \"formula\": \"\",\n \"guid_formula\": \"\",\n \"local\": true,\n \"quickFormula\": true,\n \"originalTitle\": \"sales\",\n \"fakeTitle\": \"sales\",\n \"datasetId\": \"y0vg5dd7bnloi\",\n \"id\": \"inserted-1773816829733\"\n }\n }\n ],\n \"version\": \"15\",\n \"visualization\": {\n \"id\": \"column\",\n \"type\": \"column\",\n \"name\": \"label_visualization-column\",\n \"iconProps\": {\n \"id\": \"visColumn\",\n \"width\": \"24\"\n },\n \"allowFilters\": true,\n \"allowColors\": true,\n \"allowSort\": true,\n \"allowSegments\": true,\n \"allowLabels\": true,\n \"availableLabelModes\": [\n \"absolute\"\n ],\n \"placeholders\": [\n {\n \"allowedTypes\": {},\n \"allowedDataTypes\": {},\n \"id\": \"x\",\n \"type\": \"x\",\n \"title\": \"section_x\",\n \"iconProps\": {},\n \"items\": [\n {\n \"data_type\": \"string\",\n \"lock_aggregation\": false,\n \"managed_by\": \"user\",\n \"aggregation_locked\": false,\n \"aggregation\": \"none\",\n \"hidden\": false,\n \"initial_data_type\": \"string\",\n \"virtual\": false,\n \"description\": \"\",\n \"type\": \"DIMENSION\",\n \"has_auto_aggregation\": false,\n \"guid\": \"city\",\n \"title\": \"city\",\n \"autoaggregated\": false,\n \"cast\": \"string\",\n \"ui_settings\": \"\",\n \"valid\": true,\n \"source\": \"city\",\n \"avatar_id\": \"12ae3990-2297-11f1-9fb3-dbe839a0643c\",\n \"calc_mode\": \"direct\",\n \"formula\": \"\",\n \"guid_formula\": \"\",\n \"default_value\": null,\n \"value_constraint\": null,\n \"datasetId\": \"y0vg5dd7bnloi\",\n \"id\": \"dimension-10\",\n \"datasetName\": \"e2e-forbidden-export-on-dataset\"\n }\n ],\n \"required\": false,\n \"capacity\": 2,\n \"settings\": {\n \"title\": \"off\",\n \"titleValue\": \"\",\n \"type\": \"linear\",\n \"grid\": \"on\",\n \"gridStep\": \"auto\",\n \"gridStepValue\": 50,\n \"hideLabels\": \"no\",\n \"labelsView\": \"auto\",\n \"holidays\": \"off\",\n \"axisLabelDateFormat\": \"DD.MM.YYYY\",\n \"axisLabelFormating\": {},\n \"axisFormatMode\": \"auto\",\n \"axisModeMap\": {\n \"city\": \"discrete\"\n },\n \"axisVisibility\": \"show\"\n }\n },\n {\n \"allowedTypes\": {},\n \"allowedFinalTypes\": {},\n \"allowedDataTypes\": {},\n \"id\": \"y\",\n \"type\": \"y\",\n \"title\": \"section_y\",\n \"iconProps\": {},\n \"items\": [\n {\n \"data_type\": \"integer\",\n \"lock_aggregation\": false,\n \"managed_by\": \"user\",\n \"aggregation_locked\": false,\n \"aggregation\": \"countunique\",\n \"hidden\": false,\n \"initial_data_type\": \"string\",\n \"virtual\": false,\n \"description\": \"\",\n \"type\": \"MEASURE\",\n \"has_auto_aggregation\": false,\n \"guid\": \"3783d9f0-2297-11f1-9fb3-dbe839a0643c\",\n \"title\": \"title-3783d9f0-2297-11f1-9fb3-dbe839a0643c\",\n \"autoaggregated\": false,\n \"cast\": \"string\",\n \"ui_settings\": \"\",\n \"valid\": true,\n \"source\": \"sales\",\n \"avatar_id\": \"12ae3990-2297-11f1-9fb3-dbe839a0643c\",\n \"calc_mode\": \"direct\",\n \"formula\": \"\",\n \"guid_formula\": \"\",\n \"local\": true,\n \"quickFormula\": true,\n \"originalTitle\": \"sales\",\n \"fakeTitle\": \"sales\",\n \"datasetId\": \"y0vg5dd7bnloi\",\n \"id\": \"inserted-1773816829733\"\n }\n ],\n \"settings\": {\n \"scale\": \"auto\",\n \"scaleValue\": \"min-max\",\n \"title\": \"off\",\n \"titleValue\": \"\",\n \"type\": \"linear\",\n \"grid\": \"on\",\n \"gridStep\": \"auto\",\n \"gridStepValue\": 50,\n \"hideLabels\": \"no\",\n \"labelsView\": \"auto\",\n \"nulls\": \"ignore\",\n \"axisLabelDateFormat\": \"DD.MM.YYYY\",\n \"axisLabelFormating\": {},\n \"axisFormatMode\": \"auto\",\n \"axisVisibility\": \"show\",\n \"axisModeMap\": {\n \"3783d9f0-2297-11f1-9fb3-dbe839a0643c\": \"continuous\"\n }\n }\n }\n ]\n },\n \"convert\": false\n}"}', '{}', 'uid:572moc17cb96p', '2026-03-18 06:53:58.834854+00', 'uid:572moc17cb96p', '2026-03-18 06:53:58.834854+00', 2173176602454656004, 2173176602437878787, '{"dataset": "y0vg5dd7bnloi"}', '{"description": ""}', NULL, NULL);
|
||
INSERT INTO public.revisions (data, meta, created_by, created_at, updated_by, updated_at, rev_id, entry_id, links, annotation, version, source_version) VALUES ('{"shared": "{\n \"type\": \"ql\",\n \"chartType\": \"sql\",\n \"connection\": {\n \"entryId\": \"mojx9uxysf5c6\",\n \"type\": \"postgres\",\n \"dataExportForbidden\": false\n },\n \"colors\": [],\n \"colorsConfig\": {},\n \"labels\": [],\n \"tooltips\": [],\n \"shapes\": [],\n \"shapesConfig\": {},\n \"extraSettings\": {\n \"pagination\": \"on\",\n \"limit\": 100\n },\n \"queryValue\": \"select city, AVG(sales::float)\\nfrom public.sales\\ngroup by city\\norder by city;\",\n \"queries\": [],\n \"params\": [],\n \"visualization\": {\n \"id\": \"flatTable\",\n \"type\": \"table\",\n \"name\": \"label_visualization-flat-table\",\n \"iconProps\": {\n \"id\": \"visFlatTable\",\n \"width\": \"24\"\n },\n \"allowFilters\": false,\n \"allowColors\": true,\n \"allowSort\": false,\n \"placeholders\": [\n {\n \"allowedTypes\": {},\n \"id\": \"flat-table-columns\",\n \"type\": \"flat-table-columns\",\n \"title\": \"section_columns\",\n \"iconProps\": {},\n \"items\": [\n {\n \"guid\": \"city\",\n \"title\": \"city\",\n \"datasetId\": \"ql-mocked-dataset\",\n \"data_type\": \"string\",\n \"cast\": \"string\",\n \"type\": \"DIMENSION\",\n \"calc_mode\": \"direct\",\n \"inspectHidden\": true,\n \"formulaHidden\": true,\n \"noEdit\": true\n },\n {\n \"guid\": \"avg\",\n \"title\": \"avg\",\n \"datasetId\": \"ql-mocked-dataset\",\n \"data_type\": \"float\",\n \"cast\": \"float\",\n \"type\": \"DIMENSION\",\n \"calc_mode\": \"direct\",\n \"inspectHidden\": true,\n \"formulaHidden\": true,\n \"noEdit\": true\n }\n ],\n \"required\": true,\n \"settings\": {\n \"groupping\": \"on\",\n \"axisModeMap\": {}\n }\n }\n ],\n \"allowSegments\": false,\n \"allowAvailable\": true,\n \"allowLayerFilters\": false\n },\n \"order\": null,\n \"version\": \"7\",\n \"geopointsConfig\": {}\n}"}', '{}', 'uid:572moc17cb96p', '2026-03-18 07:07:36.791779+00', 'uid:572moc17cb96p', '2026-03-18 07:07:36.791779+00', 2173183463958512646, 2173183463950124037, '{"connection": "mojx9uxysf5c6"}', '{"description": ""}', NULL, NULL);
|
||
INSERT INTO public.revisions (data, meta, created_by, created_at, updated_by, updated_at, rev_id, entry_id, links, annotation, version, source_version) VALUES ('{"shared": "{\n \"type\": \"ql\",\n \"chartType\": \"sql\",\n \"connection\": {\n \"entryId\": \"dr0y3yyi1gjk2\",\n \"type\": \"postgres\",\n \"dataExportForbidden\": false\n },\n \"colors\": [],\n \"colorsConfig\": {},\n \"labels\": [],\n \"tooltips\": [],\n \"shapes\": [],\n \"shapesConfig\": {},\n \"extraSettings\": {\n \"title\": \"\",\n \"titleMode\": \"show\",\n \"labelsPosition\": \"outside\"\n },\n \"queryValue\": \"select city, AVG(sales::float)\\nfrom public.sales\\ngroup by city\\norder by city;\",\n \"queries\": [],\n \"params\": [],\n \"visualization\": {\n \"id\": \"column\",\n \"type\": \"column\",\n \"name\": \"label_visualization-column\",\n \"iconProps\": {\n \"id\": \"visColumn\",\n \"width\": \"24\"\n },\n \"allowFilters\": false,\n \"allowColors\": true,\n \"allowSort\": false,\n \"allowSegments\": false,\n \"allowLabels\": true,\n \"availableLabelModes\": [\n \"absolute\"\n ],\n \"placeholders\": [\n {\n \"allowedTypes\": {},\n \"allowedDataTypes\": {},\n \"id\": \"x\",\n \"type\": \"x\",\n \"title\": \"section_x\",\n \"iconProps\": {},\n \"items\": [\n {\n \"guid\": \"city\",\n \"title\": \"city\",\n \"datasetId\": \"ql-mocked-dataset\",\n \"data_type\": \"string\",\n \"cast\": \"string\",\n \"type\": \"DIMENSION\",\n \"calc_mode\": \"direct\",\n \"inspectHidden\": true,\n \"formulaHidden\": true,\n \"noEdit\": true\n }\n ],\n \"required\": false,\n \"capacity\": 2,\n \"settings\": {\n \"title\": \"off\",\n \"titleValue\": \"\",\n \"type\": \"linear\",\n \"grid\": \"on\",\n \"gridStep\": \"auto\",\n \"gridStepValue\": 50,\n \"hideLabels\": \"no\",\n \"labelsView\": \"auto\",\n \"holidays\": \"off\",\n \"axisLabelDateFormat\": \"DD.MM.YYYY\",\n \"axisLabelFormating\": {},\n \"axisFormatMode\": \"auto\",\n \"axisModeMap\": {\n \"city\": \"discrete\"\n },\n \"axisVisibility\": \"show\",\n \"disableAxisMode\": true\n }\n },\n {\n \"allowedTypes\": {},\n \"allowedFinalTypes\": {},\n \"allowedDataTypes\": {},\n \"id\": \"y\",\n \"type\": \"y\",\n \"title\": \"section_y\",\n \"iconProps\": {},\n \"items\": [\n {\n \"guid\": \"avg\",\n \"title\": \"avg\",\n \"datasetId\": \"ql-mocked-dataset\",\n \"data_type\": \"float\",\n \"cast\": \"float\",\n \"type\": \"DIMENSION\",\n \"calc_mode\": \"direct\",\n \"inspectHidden\": true,\n \"formulaHidden\": true,\n \"noEdit\": true\n }\n ],\n \"settings\": {\n \"scale\": \"auto\",\n \"scaleValue\": \"min-max\",\n \"title\": \"off\",\n \"titleValue\": \"\",\n \"type\": \"linear\",\n \"grid\": \"on\",\n \"gridStep\": \"auto\",\n \"gridStepValue\": 50,\n \"hideLabels\": \"no\",\n \"labelsView\": \"auto\",\n \"nulls\": \"ignore\",\n \"axisLabelDateFormat\": \"DD.MM.YYYY\",\n \"axisLabelFormating\": {},\n \"axisFormatMode\": \"auto\",\n \"axisVisibility\": \"show\"\n }\n }\n ],\n \"allowAvailable\": true\n },\n \"order\": null,\n \"version\": \"7\",\n \"geopointsConfig\": {}\n}"}', '{}', 'uid:572moc17cb96p', '2026-03-18 07:09:40.361535+00', 'uid:572moc17cb96p', '2026-03-18 07:09:40.361535+00', 2173184500530414600, 2173184500530414599, '{"connection": "dr0y3yyi1gjk2"}', '{"description": ""}', NULL, NULL);
|
||
INSERT INTO public.revisions (data, meta, created_by, created_at, updated_by, updated_at, rev_id, entry_id, links, annotation, version, source_version) VALUES ('{"rls": [], "name": "", "revision_id": "RpVWHqnjnjRQGJu8CL7MgL", "result_schema": [{"cast": "integer", "guid": "id", "type": "DIMENSION", "title": "id", "valid": true, "hidden": false, "source": "id", "formula": "", "avatar_id": "12ae3990-2297-11f1-9fb3-dbe839a0643c", "calc_mode": "direct", "data_type": "integer", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "integer", "has_auto_aggregation": false}, {"cast": "string", "guid": "order_id", "type": "DIMENSION", "title": "order_id", "valid": true, "hidden": false, "source": "order_id", "formula": "", "avatar_id": "12ae3990-2297-11f1-9fb3-dbe839a0643c", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "date", "guid": "order_date", "type": "DIMENSION", "title": "order_date", "valid": true, "hidden": false, "source": "order_date", "formula": "", "avatar_id": "12ae3990-2297-11f1-9fb3-dbe839a0643c", "calc_mode": "direct", "data_type": "date", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "date", "has_auto_aggregation": false}, {"cast": "date", "guid": "ship_date", "type": "DIMENSION", "title": "ship_date", "valid": true, "hidden": false, "source": "ship_date", "formula": "", "avatar_id": "12ae3990-2297-11f1-9fb3-dbe839a0643c", "calc_mode": "direct", "data_type": "date", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "date", "has_auto_aggregation": false}, {"cast": "string", "guid": "ship_mode", "type": "DIMENSION", "title": "ship_mode", "valid": true, "hidden": false, "source": "ship_mode", "formula": "", "avatar_id": "12ae3990-2297-11f1-9fb3-dbe839a0643c", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "customer_id", "type": "DIMENSION", "title": "customer_id", "valid": true, "hidden": false, "source": "customer_id", "formula": "", "avatar_id": "12ae3990-2297-11f1-9fb3-dbe839a0643c", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "customer_name", "type": "DIMENSION", "title": "customer_name", "valid": true, "hidden": false, "source": "customer_name", "formula": "", "avatar_id": "12ae3990-2297-11f1-9fb3-dbe839a0643c", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "segment", "type": "DIMENSION", "title": "segment", "valid": true, "hidden": false, "source": "segment", "formula": "", "avatar_id": "12ae3990-2297-11f1-9fb3-dbe839a0643c", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "country", "type": "DIMENSION", "title": "country", "valid": true, "hidden": false, "source": "country", "formula": "", "avatar_id": "12ae3990-2297-11f1-9fb3-dbe839a0643c", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "city", "type": "DIMENSION", "title": "city", "valid": true, "hidden": false, "source": "city", "formula": "", "avatar_id": "12ae3990-2297-11f1-9fb3-dbe839a0643c", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "state", "type": "DIMENSION", "title": "state", "valid": true, "hidden": false, "source": "state", "formula": "", "avatar_id": "12ae3990-2297-11f1-9fb3-dbe839a0643c", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "postal_code", "type": "DIMENSION", "title": "postal_code", "valid": true, "hidden": false, "source": "postal_code", "formula": "", "avatar_id": "12ae3990-2297-11f1-9fb3-dbe839a0643c", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "region", "type": "DIMENSION", "title": "region", "valid": true, "hidden": false, "source": "region", "formula": "", "avatar_id": "12ae3990-2297-11f1-9fb3-dbe839a0643c", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "product_id", "type": "DIMENSION", "title": "product_id", "valid": true, "hidden": false, "source": "product_id", "formula": "", "avatar_id": "12ae3990-2297-11f1-9fb3-dbe839a0643c", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "category", "type": "DIMENSION", "title": "category", "valid": true, "hidden": false, "source": "category", "formula": "", "avatar_id": "12ae3990-2297-11f1-9fb3-dbe839a0643c", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "sub_category", "type": "DIMENSION", "title": "sub_category", "valid": true, "hidden": false, "source": "sub_category", "formula": "", "avatar_id": "12ae3990-2297-11f1-9fb3-dbe839a0643c", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "product_name", "type": "DIMENSION", "title": "product_name", "valid": true, "hidden": false, "source": "product_name", "formula": "", "avatar_id": "12ae3990-2297-11f1-9fb3-dbe839a0643c", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}, {"cast": "string", "guid": "sales", "type": "DIMENSION", "title": "sales", "valid": true, "hidden": false, "source": "sales", "formula": "", "avatar_id": "12ae3990-2297-11f1-9fb3-dbe839a0643c", "calc_mode": "direct", "data_type": "string", "managed_by": "user", "aggregation": "none", "description": "", "ui_settings": "", "guid_formula": "", "default_value": null, "lock_aggregation": false, "value_constraint": null, "initial_data_type": "string", "has_auto_aggregation": false}], "schema_version": "1", "source_avatars": [{"id": "12ae3990-2297-11f1-9fb3-dbe839a0643c", "title": "public.sales", "valid": true, "is_root": true, "source_id": "12ae3991-2297-11f1-9fb3-dbe839a0643c", "managed_by": "user"}], "avatar_relations": [], "component_errors": {"items": []}, "template_enabled": false, "result_schema_aux": {"inter_dependencies": {"deps": []}}, "obligatory_filters": [], "source_collections": [{"id": "12ae3991-2297-11f1-9fb3-dbe839a0643c", "title": "sales", "valid": true, "origin": {"parameters": {"db_version": "PostgreSQL 16.13 (Debian 16.13-1.pgdg13+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 14.2.0-19) 14.2.0, 64-bit", "table_name": "sales", "schema_name": "public"}, "raw_schema": [{"name": "id", "type": "integer", "title": "id", "nullable": false, "description": "", "native_type": {"name": "integer", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "order_id", "type": "string", "title": "order_id", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "order_date", "type": "date", "title": "order_date", "nullable": false, "description": "", "native_type": {"name": "date", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "ship_date", "type": "date", "title": "ship_date", "nullable": false, "description": "", "native_type": {"name": "date", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "ship_mode", "type": "string", "title": "ship_mode", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "customer_id", "type": "string", "title": "customer_id", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "customer_name", "type": "string", "title": "customer_name", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "segment", "type": "string", "title": "segment", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "country", "type": "string", "title": "country", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "city", "type": "string", "title": "city", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "state", "type": "string", "title": "state", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "postal_code", "type": "string", "title": "postal_code", "nullable": true, "description": "", "native_type": {"name": "text", "nullable": true, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "region", "type": "string", "title": "region", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "product_id", "type": "string", "title": "product_id", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "category", "type": "string", "title": "category", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "sub_category", "type": "string", "title": "sub_category", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "product_name", "type": "string", "title": "product_name", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}, {"name": "sales", "type": "string", "title": "sales", "nullable": false, "description": "", "native_type": {"name": "text", "nullable": false, "native_type_class_name": "common_native_type"}, "lock_aggregation": false, "has_auto_aggregation": false}], "created_from": "PG_TABLE", "connection_id": "dr0y3yyi1gjk2"}, "sample": null, "managed_by": "user", "materialization": null}], "data_export_forbidden": true, "load_preview_by_default": true}', '{"created_via": "user"}', 'uid:573n34fbufbyp', '2026-03-18 10:19:05.375042+00', 'uid:573n34fbufbyp', '2026-03-18 10:19:05.375042+00', 2173279837236495362, 2173176182344778754, '{"12ae3991-2297-11f1-9fb3-dbe839a0643c": "dr0y3yyi1gjk2"}', '{"description": ""}', NULL, NULL);
|
||
|
||
COMMIT;
|