@flamber
Sorry for the late reply.
Please check the below data about revision and report_card.
( ***masked***
means masked data)
revision
[
{
"id" : 202,
"model" : "Card",
"model_id" : 41,
"user_id" : 8,
"timestamp" : "2022-02-27 05:12:26.000000",
"object" : "{\"description\":null,\"archived\":false,\"collection_position\":null,\"table_id\":49,\"database_id\":2,\"enable_embedding\":false,\"collection_id\":18,\"query_type\":\"query\",\"name\":\"***masked***\",\"creator_id\":1,\"made_public_by_id\":null,\"embedding_params\":null,\"cache_ttl\":null,\"dataset_query\":{\"database\":2,\"query\":{\"source-table\":49,\"aggregation\":[[\"distinct\",[\"field\",414,null]]]},\"type\":\"query\"},\"id\":41,\"display\":\"scalar\",\"visualization_settings\":{},\"public_uuid\":null}",
"is_reversion" : "0",
"is_creation" : "0",
"message" : null
},
{
"id" : 255,
"model" : "Card",
"model_id" : 41,
"user_id" : 1,
"timestamp" : "2022-03-02 06:55:13.000000",
"object" : "{\"description\":null,\"archived\":false,\"collection_position\":null,\"table_id\":49,\"database_id\":2,\"enable_embedding\":false,\"collection_id\":18,\"query_type\":\"query\",\"name\":\"***masked***\",\"creator_id\":1,\"made_public_by_id\":null,\"embedding_params\":null,\"cache_ttl\":null,\"dataset_query\":{\"type\":\"query\",\"query\":{\"source-table\":49,\"aggregation\":[[\"distinct\",[\"field\",414,null]]],\"filter\":[\"=\",[\"field\",416,null],1]},\"database\":2},\"id\":41,\"display\":\"scalar\",\"visualization_settings\":{},\"public_uuid\":null}",
"is_reversion" : "0",
"is_creation" : "0",
"message" : null
},
{
"id" : 256,
"model" : "Card",
"model_id" : 41,
"user_id" : 1,
"timestamp" : "2022-03-02 06:57:03.000000",
"object" : "{\"description\":null,\"archived\":false,\"collection_position\":null,\"table_id\":49,\"database_id\":2,\"enable_embedding\":false,\"collection_id\":18,\"query_type\":\"query\",\"name\":\"***masked***\",\"creator_id\":1,\"made_public_by_id\":null,\"embedding_params\":null,\"cache_ttl\":null,\"dataset_query\":{\"type\":\"query\",\"query\":{\"source-table\":49,\"aggregation\":[[\"distinct\",[\"field\",414,null]]],\"filter\":[\"=\",[\"field\",416,null],1]},\"database\":2},\"id\":41,\"display\":\"scalar\",\"visualization_settings\":{},\"public_uuid\":null}",
"is_reversion" : "0",
"is_creation" : "0",
"message" : null
},
{
"id" : 1000,
"model" : "Card",
"model_id" : 41,
"user_id" : 1,
"timestamp" : "2022-03-10 07:48:25.000000",
"object" : "{\"description\":null,\"archived\":false,\"collection_position\":null,\"table_id\":49,\"database_id\":2,\"enable_embedding\":false,\"collection_id\":18,\"query_type\":\"query\",\"name\":\"***masked***\",\"creator_id\":1,\"made_public_by_id\":null,\"embedding_params\":null,\"cache_ttl\":null,\"dataset_query\":{\"type\":\"query\",\"query\":{\"source-table\":49,\"aggregation\":[[\"distinct\",[\"field\",414,null]]],\"filter\":[\"=\",[\"field\",416,null],1]},\"database\":2},\"id\":41,\"display\":\"scalar\",\"visualization_settings\":{},\"public_uuid\":null}",
"is_reversion" : "0",
"is_creation" : "0",
"message" : null
},
{
"id" : 1396,
"model" : "Card",
"model_id" : 41,
"user_id" : 1,
"timestamp" : "2022-03-15 01:59:25.000000",
"object" : "{\"description\":null,\"archived\":false,\"collection_position\":null,\"table_id\":49,\"database_id\":2,\"enable_embedding\":false,\"collection_id\":18,\"query_type\":\"query\",\"name\":\"***masked***\",\"creator_id\":1,\"made_public_by_id\":null,\"embedding_params\":null,\"cache_ttl\":null,\"dataset_query\":{\"type\":\"query\",\"query\":{\"source-table\":49,\"aggregation\":[[\"distinct\",[\"field\",414,null]]],\"filter\":[\"=\",[\"field\",416,null],1]},\"database\":2},\"id\":41,\"display\":\"scalar\",\"visualization_settings\":{},\"dataset\":false,\"public_uuid\":null}",
"is_reversion" : "0",
"is_creation" : "0",
"message" : null
},
{
"id" : 2922,
"model" : "Card",
"model_id" : 41,
"user_id" : 1,
"timestamp" : "2022-04-01 05:38:54.000000",
"object" : "{\"description\":null,\"archived\":false,\"collection_position\":null,\"table_id\":49,\"database_id\":2,\"enable_embedding\":false,\"collection_id\":18,\"query_type\":\"query\",\"name\":\"***masked***\",\"creator_id\":1,\"made_public_by_id\":null,\"embedding_params\":null,\"cache_ttl\":null,\"dataset_query\":{\"database\":2,\"query\":{\"source-table\":49,\"aggregation\":[[\"distinct\",[\"field\",414,null]]],\"filter\":[\"and\",[\"=\",[\"field\",416,null],1],[\">\",[\"field\",413,null],\"2022-02-21\"]]},\"type\":\"query\"},\"id\":41,\"display\":\"scalar\",\"visualization_settings\":{},\"dataset\":false,\"public_uuid\":null}",
"is_reversion" : "0",
"is_creation" : "0",
"message" : null
},
{
"id" : 11873,
"model" : "Card",
"model_id" : 41,
"user_id" : 7,
"timestamp" : "2022-08-15 02:02:07.000000",
"object" : "{\"description\":null,\"archived\":false,\"collection_position\":null,\"table_id\":null,\"database_id\":7,\"enable_embedding\":false,\"collection_id\":18,\"query_type\":\"native\",\"name\":\"***masked***\",\"creator_id\":1,\"made_public_by_id\":null,\"embedding_params\":null,\"cache_ttl\":null,\"dataset_query\":{\"type\":\"native\",\"native\":{\"template-tags\":{\"date\":{\"id\":\"a64c05b9-d3d0-d973-bb23-220e2e24d921\",\"name\":\"date\",\"display-name\":\"Date\",\"type\":\"dimension\",\"dimension\":[\"field\",9437,null],\"widget-type\":\"date/all-options\",\"default\":null}},\"query\":\"***masked***"},\"database\":7},\"id\":41,\"parameter_mappings\":null,\"display\":\"scalar\",\"entity_id\":null,\"collection_preview\":true,\"visualization_settings\":{},\"parameters\":[{\"id\":\"a64c05b9-d3d0-d973-bb23-220e2e24d921\",\"type\":\"date/all-options\",\"target\":[\"dimension\",[\"template-tag\",\"date\"]],\"name\":\"Date\",\"slug\":\"date\"}],\"dataset\":false,\"public_uuid\":null}",
"is_reversion" : "0",
"is_creation" : "0",
"message" : null
},
{
"id" : 11881,
"model" : "Card",
"model_id" : 41,
"user_id" : 7,
"timestamp" : "2022-08-15 02:12:00.000000",
"object" : "{\"description\":null,\"archived\":false,\"collection_position\":null,\"table_id\":null,\"database_id\":7,\"enable_embedding\":false,\"collection_id\":18,\"query_type\":\"native\",\"name\":\"***masked***\",\"creator_id\":1,\"made_public_by_id\":null,\"embedding_params\":null,\"cache_ttl\":null,\"dataset_query\":{\"type\":\"native\",\"native\":{\"template-tags\":{\"date\":{\"id\":\"a64c05b9-d3d0-d973-bb23-220e2e24d921\",\"name\":\"date\",\"display-name\":\"Date\",\"type\":\"dimension\",\"dimension\":[\"field\",9437,null],\"widget-type\":\"date/all-options\",\"default\":null}},\"query\":\"***masked***\"},\"database\":7},\"id\":41,\"parameter_mappings\":null,\"display\":\"scalar\",\"entity_id\":null,\"collection_preview\":true,\"visualization_settings\":{},\"parameters\":[{\"id\":\"a64c05b9-d3d0-d973-bb23-220e2e24d921\",\"type\":\"date/all-options\",\"target\":[\"dimension\",[\"template-tag\",\"date\"]],\"name\":\"Date\",\"slug\":\"date\"}],\"dataset\":false,\"public_uuid\":null}",
"is_reversion" : "0",
"is_creation" : "0",
"message" : null
},
{
"id" : 11882,
"model" : "Card",
"model_id" : 41,
"user_id" : 7,
"timestamp" : "2022-08-15 02:15:32.000000",
"object" : "{\"description\":null,\"archived\":false,\"collection_position\":null,\"table_id\":null,\"database_id\":7,\"enable_embedding\":false,\"collection_id\":18,\"query_type\":\"native\",\"name\":\"***masked***\",\"creator_id\":1,\"made_public_by_id\":null,\"embedding_params\":null,\"cache_ttl\":null,\"dataset_query\":{\"database\":7,\"native\":{\"query\":\"***masked***\",\"template-tags\":{\"date\":{\"id\":\"de5701d9-76ea-6f03-03f3-08930f4906f7\",\"name\":\"date\",\"display-name\":\"Date\",\"type\":\"dimension\",\"dimension\":[\"field\",9437,null],\"widget-type\":\"date/all-options\",\"default\":null}}},\"type\":\"native\"},\"id\":41,\"parameter_mappings\":null,\"display\":\"scalar\",\"entity_id\":null,\"collection_preview\":true,\"visualization_settings\":{},\"parameters\":[{\"id\":\"de5701d9-76ea-6f03-03f3-08930f4906f7\",\"type\":\"date/all-options\",\"target\":[\"dimension\",[\"template-tag\",\"date\"]],\"name\":\"Date\",\"slug\":\"date\"}],\"dataset\":false,\"public_uuid\":null}",
"is_reversion" : "0",
"is_creation" : "0",
"message" : null
},
{
"id" : 11886,
"model" : "Card",
"model_id" : 41,
"user_id" : 7,
"timestamp" : "2022-08-15 02:22:52.000000",
"object" : "{\"description\":null,\"archived\":false,\"collection_position\":null,\"table_id\":null,\"database_id\":7,\"enable_embedding\":false,\"collection_id\":18,\"query_type\":\"native\",\"name\":\"***masked***\",\"creator_id\":1,\"made_public_by_id\":null,\"embedding_params\":null,\"cache_ttl\":null,\"dataset_query\":{\"database\":7,\"native\":{\"query\":\***masked***\",\"template-tags\":{\"date\":{\"id\":\"de5701d9-76ea-6f03-03f3-08930f4906f7\",\"name\":\"date\",\"display-name\":\"Date\",\"type\":\"dimension\",\"dimension\":[\"field\",9437,null],\"widget-type\":\"date/all-options\",\"default\":null}}},\"type\":\"native\"},\"id\":41,\"parameter_mappings\":null,\"display\":\"scalar\",\"entity_id\":null,\"collection_preview\":true,\"visualization_settings\":{},\"parameters\":[{\"id\":\"de5701d9-76ea-6f03-03f3-08930f4906f7\",\"type\":\"date/all-options\",\"target\":[\"dimension\",[\"template-tag\",\"date\"]],\"name\":\"Date\",\"slug\":\"date\"}],\"dataset\":false,\"public_uuid\":null}",
"is_reversion" : "0",
"is_creation" : "0",
"message" : null
},
{
"id" : 11901,
"model" : "Card",
"model_id" : 41,
"user_id" : 7,
"timestamp" : "2022-08-15 02:36:18.000000",
"object" : "{\"description\":null,\"archived\":false,\"collection_position\":null,\"table_id\":null,\"database_id\":7,\"enable_embedding\":false,\"collection_id\":18,\"query_type\":\"native\",\"name\":\"***masked***\",\"creator_id\":1,\"made_public_by_id\":null,\"embedding_params\":null,\"cache_ttl\":null,\"dataset_query\":{\"database\":7,\"native\":{\"query\":\"***masked***\",\"template-tags\":{\"date\":{\"id\":\"de5701d9-76ea-6f03-03f3-08930f4906f7\",\"name\":\"date\",\"display-name\":\"Date\",\"type\":\"dimension\",\"dimension\":[\"field\",9437,null],\"widget-type\":\"date/all-options\",\"default\":null}}},\"type\":\"native\"},\"id\":41,\"parameter_mappings\":null,\"display\":\"scalar\",\"entity_id\":null,\"collection_preview\":true,\"visualization_settings\":{},\"parameters\":[{\"id\":\"de5701d9-76ea-6f03-03f3-08930f4906f7\",\"type\":\"date/all-options\",\"target\":[\"dimension\",[\"template-tag\",\"date\"]],\"name\":\"Date\",\"slug\":\"date\"}],\"dataset\":false,\"public_uuid\":null}",
"is_reversion" : "0",
"is_creation" : "0",
"message" : null
},
{
"id" : 11925,
"model" : "Card",
"model_id" : 41,
"user_id" : 7,
"timestamp" : "2022-08-15 03:29:15.000000",
"object" : "{\"description\":null,\"archived\":false,\"collection_position\":null,\"table_id\":null,\"database_id\":7,\"enable_embedding\":false,\"collection_id\":18,\"query_type\":\"native\",\"name\":\"***masked***",\"creator_id\":1,\"made_public_by_id\":null,\"embedding_params\":null,\"cache_ttl\":null,\"dataset_query\":{\"database\":7,\"native\":{\"query\":\"***masked***\",\"template-tags\":{\"date\":{\"id\":\"de5701d9-76ea-6f03-03f3-08930f4906f7\",\"name\":\"date\",\"display-name\":\"Date\",\"type\":\"dimension\",\"dimension\":[\"field\",9437,null],\"widget-type\":\"date/all-options\",\"default\":null}}},\"type\":\"native\"},\"id\":41,\"parameter_mappings\":null,\"display\":\"scalar\",\"entity_id\":null,\"collection_preview\":true,\"visualization_settings\":{},\"parameters\":[{\"id\":\"de5701d9-76ea-6f03-03f3-08930f4906f7\",\"type\":\"date/all-options\",\"target\":[\"dimension\",[\"template-tag\",\"date\"]],\"name\":\"Date\",\"slug\":\"date\"}],\"dataset\":false,\"public_uuid\":null}",
"is_reversion" : "0",
"is_creation" : "0",
"message" : null
},
{
"id" : 11926,
"model" : "Card",
"model_id" : 41,
"user_id" : 7,
"timestamp" : "2022-08-15 03:29:30.000000",
"object" : "{\"description\":null,\"archived\":false,\"collection_position\":null,\"table_id\":null,\"database_id\":7,\"enable_embedding\":false,\"collection_id\":18,\"query_type\":\"native\",\"name\":\"***masked***\",\"creator_id\":1,\"made_public_by_id\":null,\"embedding_params\":null,\"cache_ttl\":null,\"dataset_query\":{\"database\":7,\"native\":{\"query\":\"***masked***\",\"template-tags\":{\"date\":{\"id\":\"de5701d9-76ea-6f03-03f3-08930f4906f7\",\"name\":\"date\",\"display-name\":\"Date\",\"type\":\"dimension\",\"dimension\":[\"field\",9437,null],\"widget-type\":\"date/all-options\",\"default\":null}}},\"type\":\"native\"},\"id\":41,\"parameter_mappings\":null,\"display\":\"scalar\",\"entity_id\":null,\"collection_preview\":true,\"visualization_settings\":{},\"parameters\":[{\"id\":\"de5701d9-76ea-6f03-03f3-08930f4906f7\",\"type\":\"date/all-options\",\"target\":[\"dimension\",[\"template-tag\",\"date\"]],\"name\":\"Date\",\"slug\":\"date\"}],\"dataset\":false,\"public_uuid\":null}",
"is_reversion" : "0",
"is_creation" : "0",
"message" : null
},
{
"id" : 11927,
"model" : "Card",
"model_id" : 41,
"user_id" : 7,
"timestamp" : "2022-08-15 03:33:30.000000",
"object" : "{\"description\":null,\"archived\":false,\"collection_position\":null,\"table_id\":null,\"database_id\":7,\"enable_embedding\":false,\"collection_id\":18,\"query_type\":\"native\",\"name\":\"***masked***\",\"creator_id\":1,\"made_public_by_id\":null,\"embedding_params\":null,\"cache_ttl\":null,\"dataset_query\":{\"database\":7,\"native\":{\"query\":\"***masked***\",\"template-tags\":{\"date\":{\"id\":\"de5701d9-76ea-6f03-03f3-08930f4906f7\",\"name\":\"date\",\"display-name\":\"Date\",\"type\":\"dimension\",\"dimension\":[\"field\",9437,null],\"widget-type\":\"date/all-options\",\"default\":null}}},\"type\":\"native\"},\"id\":41,\"parameter_mappings\":null,\"display\":\"scalar\",\"entity_id\":null,\"collection_preview\":true,\"visualization_settings\":{},\"parameters\":[{\"id\":\"de5701d9-76ea-6f03-03f3-08930f4906f7\",\"type\":\"date/all-options\",\"target\":[\"dimension\",[\"template-tag\",\"date\"]],\"name\":\"Date\",\"slug\":\"date\"}],\"dataset\":false,\"public_uuid\":null}",
"is_reversion" : "0",
"is_creation" : "0",
"message" : null
},
{
"id" : 11928,
"model" : "Card",
"model_id" : 41,
"user_id" : 7,
"timestamp" : "2022-08-15 03:35:18.000000",
"object" : "{\"description\":null,\"archived\":false,\"collection_position\":null,\"table_id\":null,\"database_id\":7,\"enable_embedding\":false,\"collection_id\":18,\"query_type\":\"native\",\"name\":\"***masked***\",\"creator_id\":1,\"made_public_by_id\":null,\"embedding_params\":null,\"cache_ttl\":null,\"dataset_query\":{\"database\":7,\"native\":{\"query\":\"***masked***",\"template-tags\":{\"date\":{\"id\":\"de5701d9-76ea-6f03-03f3-08930f4906f7\",\"name\":\"date\",\"display-name\":\"Date\",\"type\":\"dimension\",\"dimension\":[\"field\",9437,null],\"widget-type\":\"date/all-options\",\"default\":null}}},\"type\":\"native\"},\"id\":41,\"parameter_mappings\":null,\"display\":\"scalar\",\"entity_id\":null,\"collection_preview\":true,\"visualization_settings\":{},\"parameters\":[{\"id\":\"de5701d9-76ea-6f03-03f3-08930f4906f7\",\"type\":\"date/all-options\",\"target\":[\"dimension\",[\"template-tag\",\"date\"]],\"name\":\"Date\",\"slug\":\"date\"}],\"dataset\":false,\"public_uuid\":null}",
"is_reversion" : "0",
"is_creation" : "0",
"message" : null
},
{
"id" : 11933,
"model" : "Card",
"model_id" : 41,
"user_id" : 7,
"timestamp" : "2022-08-15 03:41:53.000000",
"object" : "{\"description\":null,\"archived\":false,\"collection_position\":null,\"table_id\":49,\"database_id\":2,\"enable_embedding\":false,\"collection_id\":18,\"query_type\":\"query\",\"name\":\"***masked***\",\"creator_id\":1,\"made_public_by_id\":null,\"embedding_params\":null,\"cache_ttl\":null,\"dataset_query\":{\"database\":2,\"query\":{\"source-table\":49,\"aggregation\":[[\"distinct\",[\"field\",414,null]]],\"filter\":[\"and\",[\"=\",[\"field\",416,null],1],[\">\",[\"field\",413,null],\"2022-02-21\"]]},\"type\":\"query\"},\"id\":41,\"display\":\"scalar\",\"visualization_settings\":{},\"dataset\":false,\"public_uuid\":null}",
"is_reversion" : "1",
"is_creation" : "0",
"message" : null
},
{
"id" : 11934,
"model" : "Card",
"model_id" : 41,
"user_id" : 7,
"timestamp" : "2022-08-15 03:43:25.000000",
"object" : "{\"description\":null,\"archived\":false,\"collection_position\":null,\"table_id\":null,\"database_id\":7,\"enable_embedding\":false,\"collection_id\":18,\"query_type\":\"native\",\"name\":\"***masked***\",\"creator_id\":1,\"made_public_by_id\":null,\"embedding_params\":null,\"cache_ttl\":null,\"dataset_query\":{\"database\":7,\"native\":{\"query\":\"***masked***\",\"template-tags\":{\"date\":{\"id\":\"de5701d9-76ea-6f03-03f3-08930f4906f7\",\"name\":\"date\",\"display-name\":\"Date\",\"type\":\"dimension\",\"dimension\":[\"field\",9437,null],\"widget-type\":\"date/all-options\",\"default\":null}}},\"type\":\"native\"},\"id\":41,\"parameter_mappings\":null,\"display\":\"scalar\",\"entity_id\":null,\"collection_preview\":true,\"visualization_settings\":{},\"parameters\":[{\"id\":\"de5701d9-76ea-6f03-03f3-08930f4906f7\",\"type\":\"date/all-options\",\"target\":[\"dimension\",[\"template-tag\",\"date\"]],\"name\":\"Date\",\"slug\":\"date\"}],\"dataset\":false,\"public_uuid\":null}",
"is_reversion" : "1",
"is_creation" : "0",
"message" : null
},
{
"id" : 12481,
"model" : "Card",
"model_id" : 41,
"user_id" : 2,
"timestamp" : "2022-08-22 07:33:07.000000",
"object" : "{\"description\":null,\"archived\":false,\"collection_position\":null,\"table_id\":49,\"database_id\":2,\"enable_embedding\":false,\"collection_id\":18,\"query_type\":\"query\",\"name\":\"***masked***\",\"creator_id\":1,\"made_public_by_id\":null,\"embedding_params\":null,\"cache_ttl\":null,\"dataset_query\":{\"database\":2,\"query\":{\"source-table\":49,\"aggregation\":[[\"distinct\",[\"field\",414,null]]],\"filter\":[\"and\",[\"=\",[\"field\",416,null],1],[\">\",[\"field\",413,null],\"2022-02-21\"]]},\"type\":\"query\"},\"id\":41,\"display\":\"scalar\",\"visualization_settings\":{},\"dataset\":false,\"public_uuid\":null}",
"is_reversion" : "1",
"is_creation" : "0",
"message" : null
}
]
report_card
[
{
"id" : 41,
"created_at" : "2022-02-22 08:23:36",
"updated_at" : "2022-08-30 05:25:17",
"name" : "***masked***",
"description" : null,
"display" : "scalar",
"dataset_query" : "{\"database\":2,\"query\":{\"source-table\":49,\"aggregation\":[[\"distinct\",[\"field\",414,null]]],\"filter\":[\"and\",[\"=\",[\"field\",416,null],1],[\">\",[\"field\",413,null],\"2022-02-21\"]]},\"type\":\"query\"}",
"visualization_settings" : "{}",
"creator_id" : 1,
"database_id" : 2,
"table_id" : 49,
"query_type" : "query",
"archived" : "0",
"collection_id" : 18,
"public_uuid" : null,
"made_public_by_id" : null,
"enable_embedding" : "0",
"embedding_params" : null,
"cache_ttl" : null,
"result_metadata" : "***masked***",
"collection_position" : null,
"dataset" : "0",
"entity_id" : null,
"parameters" : "[{\"id\":\"de5701d9-76ea-6f03-03f3-08930f4906f7\",\"type\":\"date/all-options\",\"target\":[\"dimension\",[\"template-tag\",\"date\"]],\"name\":\"Date\",\"slug\":\"date\"}]",
"parameter_mappings" : null,
"collection_preview" : "1"
}
]