Changes
On March 2, 2026 at 8:43:48 AM UTC,
user_d4c:
-
Added field
date_modification
with value2026-03-02
to 0302_sql_update_v1 -
Changed value of field
dataset-model
to{"db_type":"mysql","db_name":"sampledata","host":"data4citizen-vanilla-mysql","port":"3306","login":"biplatform","password":"biplatform","sql_query":"select * from customers where country = 'France';"}
(previously{"db_type":"mysql","db_name":"sampledata","host":"data4citizen-vanilla-mysql","port":"3306","login":"biplatform","password":"biplatform","sql_query":"select * from customers;"}
) in 0302_sql_update_v1
| f | 1 | { | f | 1 | { |
| 2 | "author": "", | 2 | "author": "", | ||
| 3 | "author_email": "", | 3 | "author_email": "", | ||
| 4 | "creator_user_id": "ba16fa5c-7043-40ba-9d66-147c51abe248", | 4 | "creator_user_id": "ba16fa5c-7043-40ba-9d66-147c51abe248", | ||
| 5 | "extras": [ | 5 | "extras": [ | ||
| 6 | { | 6 | { | ||
| 7 | "key": "FTP_API", | 7 | "key": "FTP_API", | ||
| 8 | "value": "FTP" | 8 | "value": "FTP" | ||
| 9 | }, | 9 | }, | ||
| 10 | { | 10 | { | ||
| 11 | "key": "LinkedDataSet", | 11 | "key": "LinkedDataSet", | ||
| 12 | "value": "[\"\"]" | 12 | "value": "[\"\"]" | ||
| 13 | }, | 13 | }, | ||
| 14 | { | 14 | { | ||
| 15 | "key": "Picto", | 15 | "key": "Picto", | ||
| 16 | "value": "" | 16 | "value": "" | ||
| 17 | }, | 17 | }, | ||
| 18 | { | 18 | { | ||
| 19 | "key": "allow_data_inputs", | 19 | "key": "allow_data_inputs", | ||
| 20 | "value": "0" | 20 | "value": "0" | ||
| 21 | }, | 21 | }, | ||
| 22 | { | 22 | { | ||
| 23 | "key": "data4citizen-type", | 23 | "key": "data4citizen-type", | ||
| 24 | "value": "sql" | 24 | "value": "sql" | ||
| 25 | }, | 25 | }, | ||
| 26 | { | 26 | { | ||
| 27 | "key": "data_interop", | 27 | "key": "data_interop", | ||
| 28 | "value": "0" | 28 | "value": "0" | ||
| 29 | }, | 29 | }, | ||
| 30 | { | 30 | { | ||
| 31 | "key": "data_rgpd", | 31 | "key": "data_rgpd", | ||
| 32 | "value": "false" | 32 | "value": "false" | ||
| 33 | }, | 33 | }, | ||
| 34 | { | 34 | { | ||
| 35 | "key": "dataset-model", | 35 | "key": "dataset-model", | ||
| 36 | "value": | 36 | "value": | ||
| 37 | in\":\"biplatform\",\"password\":\"biplatform\",\"sql_query\":\"select | 37 | in\":\"biplatform\",\"password\":\"biplatform\",\"sql_query\":\"select | ||
| n | 38 | * from customers;\"}" | n | 38 | * from customers where country = 'France';\"}" |
| 39 | }, | 39 | }, | ||
| 40 | { | 40 | { | ||
| 41 | "key": "dataset_not_visible", | 41 | "key": "dataset_not_visible", | ||
| 42 | "value": "0" | 42 | "value": "0" | ||
| 43 | }, | 43 | }, | ||
| 44 | { | 44 | { | ||
| 45 | "key": "dataset_size", | 45 | "key": "dataset_size", | ||
| 46 | "value": "0.013629913330078125" | 46 | "value": "0.013629913330078125" | ||
| 47 | }, | 47 | }, | ||
| 48 | { | 48 | { | ||
| 49 | "key": "date_dataset", | 49 | "key": "date_dataset", | ||
| 50 | "value": "2026-03-02" | 50 | "value": "2026-03-02" | ||
| 51 | }, | 51 | }, | ||
| 52 | { | 52 | { | ||
| 53 | "key": "date_deposit", | 53 | "key": "date_deposit", | ||
| n | n | 54 | "value": "2026-03-02" | ||
| 55 | }, | ||||
| 56 | { | ||||
| 57 | "key": "date_modification", | ||||
| 54 | "value": "2026-03-02" | 58 | "value": "2026-03-02" | ||
| 55 | }, | 59 | }, | ||
| 56 | { | 60 | { | ||
| 57 | "key": "date_moissonnage_last_modification", | 61 | "key": "date_moissonnage_last_modification", | ||
| 58 | "value": "2026-03-02T08:39:51.989531" | 62 | "value": "2026-03-02T08:39:51.989531" | ||
| 59 | }, | 63 | }, | ||
| 60 | { | 64 | { | ||
| 61 | "key": "default_visu", | 65 | "key": "default_visu", | ||
| 62 | "value": "0" | 66 | "value": "0" | ||
| 63 | }, | 67 | }, | ||
| 64 | { | 68 | { | ||
| 65 | "key": "disable_export_type", | 69 | "key": "disable_export_type", | ||
| 66 | "value": | 70 | "value": | ||
| 67 | e_formats\":false,\"data_analysis_formats\":false,\"metadata\":false}" | 71 | e_formats\":false,\"data_analysis_formats\":false,\"metadata\":false}" | ||
| 68 | }, | 72 | }, | ||
| 69 | { | 73 | { | ||
| 70 | "key": "donnees_source", | 74 | "key": "donnees_source", | ||
| 71 | "value": "" | 75 | "value": "" | ||
| 72 | }, | 76 | }, | ||
| 73 | { | 77 | { | ||
| 74 | "key": "edition_security", | 78 | "key": "edition_security", | ||
| 75 | "value": | 79 | "value": | ||
| 76 | 1*\",\"*19*\",\"*18*\",\"*17*\",\"*13*\",\"*16*\",\"*11*\",\"*12*\"]}" | 80 | 1*\",\"*19*\",\"*18*\",\"*17*\",\"*13*\",\"*16*\",\"*11*\",\"*12*\"]}" | ||
| 77 | }, | 81 | }, | ||
| 78 | { | 82 | { | ||
| 79 | "key": "encoding", | 83 | "key": "encoding", | ||
| 80 | "value": "UTF-8" | 84 | "value": "UTF-8" | ||
| 81 | }, | 85 | }, | ||
| 82 | { | 86 | { | ||
| 83 | "key": "features", | 87 | "key": "features", | ||
| 84 | "value": "analyze,api,table,raw_data" | 88 | "value": "analyze,api,table,raw_data" | ||
| 85 | }, | 89 | }, | ||
| 86 | { | 90 | { | ||
| 87 | "key": "map_color", | 91 | "key": "map_color", | ||
| 88 | "value": "" | 92 | "value": "" | ||
| 89 | }, | 93 | }, | ||
| 90 | { | 94 | { | ||
| 91 | "key": "nb_geo_features", | 95 | "key": "nb_geo_features", | ||
| 92 | "value": "0" | 96 | "value": "0" | ||
| 93 | }, | 97 | }, | ||
| 94 | { | 98 | { | ||
| 95 | "key": "nb_views", | 99 | "key": "nb_views", | ||
| 96 | "value": "00000005" | 100 | "value": "00000005" | ||
| 97 | }, | 101 | }, | ||
| 98 | { | 102 | { | ||
| 99 | "key": "not_visible_in_chart_interface", | 103 | "key": "not_visible_in_chart_interface", | ||
| 100 | "value": "0" | 104 | "value": "0" | ||
| 101 | }, | 105 | }, | ||
| 102 | { | 106 | { | ||
| 103 | "key": "not_visible_in_map_interface", | 107 | "key": "not_visible_in_map_interface", | ||
| 104 | "value": "0" | 108 | "value": "0" | ||
| 105 | }, | 109 | }, | ||
| 106 | { | 110 | { | ||
| 107 | "key": "producer", | 111 | "key": "producer", | ||
| 108 | "value": "" | 112 | "value": "" | ||
| 109 | }, | 113 | }, | ||
| 110 | { | 114 | { | ||
| 111 | "key": "records_count", | 115 | "key": "records_count", | ||
| 112 | "value": | 116 | "value": | ||
| 113 | "{\"9689705a-0514-49ff-84e9-1892c5cc5e5f\":\"0000000122\"}" | 117 | "{\"9689705a-0514-49ff-84e9-1892c5cc5e5f\":\"0000000122\"}" | ||
| 114 | }, | 118 | }, | ||
| 115 | { | 119 | { | ||
| 116 | "key": "themes", | 120 | "key": "themes", | ||
| 117 | "value": "[]" | 121 | "value": "[]" | ||
| 118 | }, | 122 | }, | ||
| 119 | { | 123 | { | ||
| 120 | "key": "tooltip", | 124 | "key": "tooltip", | ||
| 121 | "value": | 125 | "value": | ||
| 122 | alcode,country,salesrepemployeenumber,creditlimit,map_reference\"}}]}" | 126 | alcode,country,salesrepemployeenumber,creditlimit,map_reference\"}}]}" | ||
| 123 | }, | 127 | }, | ||
| 124 | { | 128 | { | ||
| 125 | "key": "uploader", | 129 | "key": "uploader", | ||
| 126 | "value": "user_d4c" | 130 | "value": "user_d4c" | ||
| 127 | }, | 131 | }, | ||
| 128 | { | 132 | { | ||
| 129 | "key": "weight", | 133 | "key": "weight", | ||
| 130 | "value": "0" | 134 | "value": "0" | ||
| 131 | }, | 135 | }, | ||
| 132 | { | 136 | { | ||
| 133 | "key": "wfs_link", | 137 | "key": "wfs_link", | ||
| 134 | "value": "" | 138 | "value": "" | ||
| 135 | }, | 139 | }, | ||
| 136 | { | 140 | { | ||
| 137 | "key": "wms_link", | 141 | "key": "wms_link", | ||
| 138 | "value": "" | 142 | "value": "" | ||
| 139 | } | 143 | } | ||
| 140 | ], | 144 | ], | ||
| 141 | "groups": [], | 145 | "groups": [], | ||
| 142 | "id": "8e4f6903-70c7-4967-8b64-af15465cb8f8", | 146 | "id": "8e4f6903-70c7-4967-8b64-af15465cb8f8", | ||
| 143 | "isopen": false, | 147 | "isopen": false, | ||
| 144 | "license_id": "notspecified", | 148 | "license_id": "notspecified", | ||
| 145 | "license_title": "License not specified", | 149 | "license_title": "License not specified", | ||
| 146 | "maintainer": "", | 150 | "maintainer": "", | ||
| 147 | "maintainer_email": "", | 151 | "maintainer_email": "", | ||
| 148 | "metadata_created": "2026-03-02T08:39:44.571470", | 152 | "metadata_created": "2026-03-02T08:39:44.571470", | ||
| t | 149 | "metadata_modified": "2026-03-02T08:43:08.523025", | t | 153 | "metadata_modified": "2026-03-02T08:43:47.818958", |
| 150 | "name": "0302_sql_update_v1", | 154 | "name": "0302_sql_update_v1", | ||
| 151 | "notes": "", | 155 | "notes": "", | ||
| 152 | "num_resources": 1, | 156 | "num_resources": 1, | ||
| 153 | "num_tags": 0, | 157 | "num_tags": 0, | ||
| 154 | "organization": { | 158 | "organization": { | ||
| 155 | "approval_status": "approved", | 159 | "approval_status": "approved", | ||
| 156 | "created": "2024-08-20T12:21:08.505344", | 160 | "created": "2024-08-20T12:21:08.505344", | ||
| 157 | "description": "", | 161 | "description": "", | ||
| 158 | "id": "24294b48-47a1-4bfa-943c-5ade716c3c47", | 162 | "id": "24294b48-47a1-4bfa-943c-5ade716c3c47", | ||
| 159 | "image_url": "", | 163 | "image_url": "", | ||
| 160 | "is_organization": true, | 164 | "is_organization": true, | ||
| 161 | "name": "bpm", | 165 | "name": "bpm", | ||
| 162 | "state": "active", | 166 | "state": "active", | ||
| 163 | "title": "bpm", | 167 | "title": "bpm", | ||
| 164 | "type": "organization" | 168 | "type": "organization" | ||
| 165 | }, | 169 | }, | ||
| 166 | "owner_org": "24294b48-47a1-4bfa-943c-5ade716c3c47", | 170 | "owner_org": "24294b48-47a1-4bfa-943c-5ade716c3c47", | ||
| 167 | "private": false, | 171 | "private": false, | ||
| 168 | "relationships_as_object": [], | 172 | "relationships_as_object": [], | ||
| 169 | "relationships_as_subject": [], | 173 | "relationships_as_subject": [], | ||
| 170 | "resources": [ | 174 | "resources": [ | ||
| 171 | { | 175 | { | ||
| 172 | "cache_last_updated": null, | 176 | "cache_last_updated": null, | ||
| 173 | "cache_url": null, | 177 | "cache_url": null, | ||
| 174 | "created": "2026-03-02T08:39:52.121770", | 178 | "created": "2026-03-02T08:39:52.121770", | ||
| 175 | "datastore_active": true, | 179 | "datastore_active": true, | ||
| 176 | "description": "", | 180 | "description": "", | ||
| 177 | "format": "CSV", | 181 | "format": "CSV", | ||
| 178 | "hash": "6e8dab256bc98be3c0b91b116cc74129", | 182 | "hash": "6e8dab256bc98be3c0b91b116cc74129", | ||
| 179 | "id": "9689705a-0514-49ff-84e9-1892c5cc5e5f", | 183 | "id": "9689705a-0514-49ff-84e9-1892c5cc5e5f", | ||
| 180 | "last_modified": null, | 184 | "last_modified": null, | ||
| 181 | "metadata_modified": "2026-03-02T08:42:21.927178", | 185 | "metadata_modified": "2026-03-02T08:42:21.927178", | ||
| 182 | "mimetype": "text/csv", | 186 | "mimetype": "text/csv", | ||
| 183 | "mimetype_inner": null, | 187 | "mimetype_inner": null, | ||
| 184 | "name": "0302_sql_update_v1.csv", | 188 | "name": "0302_sql_update_v1.csv", | ||
| 185 | "package_id": "8e4f6903-70c7-4967-8b64-af15465cb8f8", | 189 | "package_id": "8e4f6903-70c7-4967-8b64-af15465cb8f8", | ||
| 186 | "parent_id": null, | 190 | "parent_id": null, | ||
| 187 | "position": 0, | 191 | "position": 0, | ||
| 188 | "preview": true, | 192 | "preview": true, | ||
| 189 | "preview_rows": 122, | 193 | "preview_rows": 122, | ||
| 190 | "resource_type": null, | 194 | "resource_type": null, | ||
| 191 | "size": null, | 195 | "size": null, | ||
| 192 | "state": "active", | 196 | "state": "active", | ||
| 193 | "total_record_count": 122, | 197 | "total_record_count": 122, | ||
| 194 | "url": | 198 | "url": | ||
| 195 | dataset/8e4/f6903-70c7-4967-8b64-af15465cb8f8/0302_sql_update_v1.csv", | 199 | dataset/8e4/f6903-70c7-4967-8b64-af15465cb8f8/0302_sql_update_v1.csv", | ||
| 196 | "url_type": null | 200 | "url_type": null | ||
| 197 | } | 201 | } | ||
| 198 | ], | 202 | ], | ||
| 199 | "state": "active", | 203 | "state": "active", | ||
| 200 | "tags": [], | 204 | "tags": [], | ||
| 201 | "title": "0302_sql_update_v1", | 205 | "title": "0302_sql_update_v1", | ||
| 202 | "type": "dataset", | 206 | "type": "dataset", | ||
| 203 | "url": | 207 | "url": | ||
| 204 | .public.dash4all.ai/visualisation/information/?id=0302_sql_update_v1", | 208 | .public.dash4all.ai/visualisation/information/?id=0302_sql_update_v1", | ||
| 205 | "version": "" | 209 | "version": "" | ||
| 206 | } | 210 | } |