Changes
On February 5, 2026 at 9:00:40 AM UTC,
user_d4c:
-
Added field
date_modification
with value2026-02-05
to test nico jointure -
Changed value of field
dataset-model
to{"organizationId":"anfr","datasetId":"3c771d6f-72ad-4b0a-8fae-be7e255baef8","resourceId":"f3aed104-d23f-4bc4-9775-16e962f60915","mainColumns":["id_pays","id_dim","nb_users"],"hasJoin":1,"joinOrganizationId":"anfr","joinDatasetId":"b_-_cra","joinResourceId":"1c33fc60-c9f2-482b-924d-19823a937c4a","joinColumns":["valeur1","valeur2"],"joinType":"INNER_JOIN","joinLeftColumn":"id_dim","joinRightColumn":"id","kpisColumnsDefinition":[],"kpisDefinition":[],"kpisJoinDefinition":[],"groupByDefinitions":[]}
(previously{"organizationId":"anfr","datasetId":"3c771d6f-72ad-4b0a-8fae-be7e255baef8","resourceId":"f3aed104-d23f-4bc4-9775-16e962f60915","mainColumns":["id_pays","id_dim","nb_users"],"hasJoin":1,"joinOrganizationId":"anfr","joinDatasetId":"b_-_cra","joinResourceId":"1c33fc60-c9f2-482b-924d-19823a937c4a","joinColumns":["id","valeur1","valeur2"],"joinType":"INNER_JOIN","joinLeftColumn":"id_dim","joinRightColumn":"id","kpisColumnsDefinition":[],"kpisDefinition":[],"kpisJoinDefinition":[],"groupByDefinitions":[]}
) in test nico jointure
| f | 1 | { | f | 1 | { |
| 2 | "author": "", | 2 | "author": "", | ||
| 3 | "author_email": "", | 3 | "author_email": "", | ||
| 4 | "creator_user_id": "7a355746-a021-4879-9800-d3cee381d9a5", | 4 | "creator_user_id": "7a355746-a021-4879-9800-d3cee381d9a5", | ||
| 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": "kpi" | 24 | "value": "kpi" | ||
| 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 | sDefinition\":[],\"kpisJoinDefinition\":[],\"groupByDefinitions\":[]}" | 37 | sDefinition\":[],\"kpisJoinDefinition\":[],\"groupByDefinitions\":[]}" | ||
| 38 | }, | 38 | }, | ||
| 39 | { | 39 | { | ||
| 40 | "key": "dataset_not_visible", | 40 | "key": "dataset_not_visible", | ||
| 41 | "value": "0" | 41 | "value": "0" | ||
| 42 | }, | 42 | }, | ||
| 43 | { | 43 | { | ||
| 44 | "key": "dataset_size", | 44 | "key": "dataset_size", | ||
| 45 | "value": "0.00040435791015625" | 45 | "value": "0.00040435791015625" | ||
| 46 | }, | 46 | }, | ||
| 47 | { | 47 | { | ||
| 48 | "key": "date_dataset", | 48 | "key": "date_dataset", | ||
| 49 | "value": "2026-02-05" | 49 | "value": "2026-02-05" | ||
| 50 | }, | 50 | }, | ||
| 51 | { | 51 | { | ||
| 52 | "key": "date_deposit", | 52 | "key": "date_deposit", | ||
| n | n | 53 | "value": "2026-02-05" | ||
| 54 | }, | ||||
| 55 | { | ||||
| 56 | "key": "date_modification", | ||||
| 53 | "value": "2026-02-05" | 57 | "value": "2026-02-05" | ||
| 54 | }, | 58 | }, | ||
| 55 | { | 59 | { | ||
| 56 | "key": "date_moissonnage_last_modification", | 60 | "key": "date_moissonnage_last_modification", | ||
| 57 | "value": "2026-02-05T08:58:45.202118" | 61 | "value": "2026-02-05T08:58:45.202118" | ||
| 58 | }, | 62 | }, | ||
| 59 | { | 63 | { | ||
| 60 | "key": "default_visu", | 64 | "key": "default_visu", | ||
| 61 | "value": "0" | 65 | "value": "0" | ||
| 62 | }, | 66 | }, | ||
| 63 | { | 67 | { | ||
| 64 | "key": "disable_export_type", | 68 | "key": "disable_export_type", | ||
| 65 | "value": | 69 | "value": | ||
| 66 | e_formats\":false,\"data_analysis_formats\":false,\"metadata\":false}" | 70 | e_formats\":false,\"data_analysis_formats\":false,\"metadata\":false}" | ||
| 67 | }, | 71 | }, | ||
| 68 | { | 72 | { | ||
| 69 | "key": "donnees_source", | 73 | "key": "donnees_source", | ||
| 70 | "value": "" | 74 | "value": "" | ||
| 71 | }, | 75 | }, | ||
| 72 | { | 76 | { | ||
| 73 | "key": "edition_security", | 77 | "key": "edition_security", | ||
| 74 | "value": | 78 | "value": | ||
| 75 | *152*\",\"*155*\",\"*185*\",\"*208*\",\"*206*\",\"*209*\",\"*210*\"]}" | 79 | *152*\",\"*155*\",\"*185*\",\"*208*\",\"*206*\",\"*209*\",\"*210*\"]}" | ||
| 76 | }, | 80 | }, | ||
| 77 | { | 81 | { | ||
| 78 | "key": "encoding", | 82 | "key": "encoding", | ||
| 79 | "value": "UTF-8" | 83 | "value": "UTF-8" | ||
| 80 | }, | 84 | }, | ||
| 81 | { | 85 | { | ||
| 82 | "key": "features", | 86 | "key": "features", | ||
| 83 | "value": "analyze,api,table,raw_data" | 87 | "value": "analyze,api,table,raw_data" | ||
| 84 | }, | 88 | }, | ||
| 85 | { | 89 | { | ||
| 86 | "key": "map_color", | 90 | "key": "map_color", | ||
| 87 | "value": "" | 91 | "value": "" | ||
| 88 | }, | 92 | }, | ||
| 89 | { | 93 | { | ||
| 90 | "key": "nb_geo_features", | 94 | "key": "nb_geo_features", | ||
| 91 | "value": "0" | 95 | "value": "0" | ||
| 92 | }, | 96 | }, | ||
| 93 | { | 97 | { | ||
| 94 | "key": "nb_views", | 98 | "key": "nb_views", | ||
| 95 | "value": "00000001" | 99 | "value": "00000001" | ||
| 96 | }, | 100 | }, | ||
| 97 | { | 101 | { | ||
| 98 | "key": "not_visible_in_chart_interface", | 102 | "key": "not_visible_in_chart_interface", | ||
| 99 | "value": "0" | 103 | "value": "0" | ||
| 100 | }, | 104 | }, | ||
| 101 | { | 105 | { | ||
| 102 | "key": "not_visible_in_map_interface", | 106 | "key": "not_visible_in_map_interface", | ||
| 103 | "value": "0" | 107 | "value": "0" | ||
| 104 | }, | 108 | }, | ||
| 105 | { | 109 | { | ||
| 106 | "key": "producer", | 110 | "key": "producer", | ||
| 107 | "value": "" | 111 | "value": "" | ||
| 108 | }, | 112 | }, | ||
| 109 | { | 113 | { | ||
| 110 | "key": "records_count", | 114 | "key": "records_count", | ||
| 111 | "value": | 115 | "value": | ||
| 112 | "{\"f188099a-6eab-4b51-a15b-9ce788e8667a\":\"0000000016\"}" | 116 | "{\"f188099a-6eab-4b51-a15b-9ce788e8667a\":\"0000000016\"}" | ||
| 113 | }, | 117 | }, | ||
| 114 | { | 118 | { | ||
| 115 | "key": "show_cube_tab", | 119 | "key": "show_cube_tab", | ||
| 116 | "value": "0" | 120 | "value": "0" | ||
| 117 | }, | 121 | }, | ||
| 118 | { | 122 | { | ||
| 119 | "key": "themes", | 123 | "key": "themes", | ||
| 120 | "value": "[]" | 124 | "value": "[]" | ||
| 121 | }, | 125 | }, | ||
| 122 | { | 126 | { | ||
| 123 | "key": "uploader", | 127 | "key": "uploader", | ||
| 124 | "value": "nra" | 128 | "value": "nra" | ||
| 125 | }, | 129 | }, | ||
| 126 | { | 130 | { | ||
| 127 | "key": "weight", | 131 | "key": "weight", | ||
| 128 | "value": "0" | 132 | "value": "0" | ||
| 129 | }, | 133 | }, | ||
| 130 | { | 134 | { | ||
| 131 | "key": "wfs_link", | 135 | "key": "wfs_link", | ||
| 132 | "value": "" | 136 | "value": "" | ||
| 133 | }, | 137 | }, | ||
| 134 | { | 138 | { | ||
| 135 | "key": "wms_link", | 139 | "key": "wms_link", | ||
| 136 | "value": "" | 140 | "value": "" | ||
| 137 | } | 141 | } | ||
| 138 | ], | 142 | ], | ||
| 139 | "groups": [], | 143 | "groups": [], | ||
| 140 | "id": "3574d34f-6759-4584-bd89-d4f1eb661969", | 144 | "id": "3574d34f-6759-4584-bd89-d4f1eb661969", | ||
| 141 | "isopen": true, | 145 | "isopen": true, | ||
| 142 | "license_id": "ODbL-1.0", | 146 | "license_id": "ODbL-1.0", | ||
| 143 | "license_title": "Open Data Commons Open Database License 1.0", | 147 | "license_title": "Open Data Commons Open Database License 1.0", | ||
| 144 | "license_url": "https://opendefinition.org/licenses/odc-odbl", | 148 | "license_url": "https://opendefinition.org/licenses/odc-odbl", | ||
| 145 | "maintainer": "", | 149 | "maintainer": "", | ||
| 146 | "maintainer_email": "", | 150 | "maintainer_email": "", | ||
| 147 | "metadata_created": "2026-02-05T08:58:36.148827", | 151 | "metadata_created": "2026-02-05T08:58:36.148827", | ||
| t | 148 | "metadata_modified": "2026-02-05T08:58:53.138260", | t | 152 | "metadata_modified": "2026-02-05T09:00:40.246221", |
| 149 | "name": "test_nico_jointure", | 153 | "name": "test_nico_jointure", | ||
| 150 | "notes": "", | 154 | "notes": "", | ||
| 151 | "num_resources": 1, | 155 | "num_resources": 1, | ||
| 152 | "num_tags": 0, | 156 | "num_tags": 0, | ||
| 153 | "organization": { | 157 | "organization": { | ||
| 154 | "approval_status": "approved", | 158 | "approval_status": "approved", | ||
| 155 | "created": "2026-01-29T09:14:24.610002", | 159 | "created": "2026-01-29T09:14:24.610002", | ||
| 156 | "description": "c", | 160 | "description": "c", | ||
| 157 | "id": "ae31323e-41b5-450c-a1d5-9ec881188327", | 161 | "id": "ae31323e-41b5-450c-a1d5-9ec881188327", | ||
| 158 | "image_url": | 162 | "image_url": | ||
| 159 | noble-dev.data4citizen.com/sites/default/files/organization/scol.png", | 163 | noble-dev.data4citizen.com/sites/default/files/organization/scol.png", | ||
| 160 | "is_organization": true, | 164 | "is_organization": true, | ||
| 161 | "name": "nicorabier_corp", | 165 | "name": "nicorabier_corp", | ||
| 162 | "state": "active", | 166 | "state": "active", | ||
| 163 | "title": "NicoRabier_CORP", | 167 | "title": "NicoRabier_CORP", | ||
| 164 | "type": "organization" | 168 | "type": "organization" | ||
| 165 | }, | 169 | }, | ||
| 166 | "owner_org": "ae31323e-41b5-450c-a1d5-9ec881188327", | 170 | "owner_org": "ae31323e-41b5-450c-a1d5-9ec881188327", | ||
| 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-02-05T08:58:40.892048", | 178 | "created": "2026-02-05T08:58:40.892048", | ||
| 175 | "datastore_active": true, | 179 | "datastore_active": true, | ||
| 176 | "description": "", | 180 | "description": "", | ||
| 177 | "format": "CSV", | 181 | "format": "CSV", | ||
| 178 | "hash": "fed5ebaef4c0d7363881a0e7d519a616", | 182 | "hash": "fed5ebaef4c0d7363881a0e7d519a616", | ||
| 179 | "id": "f188099a-6eab-4b51-a15b-9ce788e8667a", | 183 | "id": "f188099a-6eab-4b51-a15b-9ce788e8667a", | ||
| 180 | "last_modified": null, | 184 | "last_modified": null, | ||
| 181 | "metadata_modified": "2026-02-05T08:58:45.209708", | 185 | "metadata_modified": "2026-02-05T08:58:45.209708", | ||
| 182 | "mimetype": "text/csv", | 186 | "mimetype": "text/csv", | ||
| 183 | "mimetype_inner": null, | 187 | "mimetype_inner": null, | ||
| 184 | "name": "test_nico_jointure.csv", | 188 | "name": "test_nico_jointure.csv", | ||
| 185 | "package_id": "3574d34f-6759-4584-bd89-d4f1eb661969", | 189 | "package_id": "3574d34f-6759-4584-bd89-d4f1eb661969", | ||
| 186 | "parent_id": null, | 190 | "parent_id": null, | ||
| 187 | "position": 0, | 191 | "position": 0, | ||
| 188 | "preview": true, | 192 | "preview": true, | ||
| 189 | "preview_rows": 16, | 193 | "preview_rows": 16, | ||
| 190 | "resource_type": null, | 194 | "resource_type": null, | ||
| 191 | "size": null, | 195 | "size": null, | ||
| 192 | "state": "active", | 196 | "state": "active", | ||
| 193 | "total_record_count": 16, | 197 | "total_record_count": 16, | ||
| 194 | "url": | 198 | "url": | ||
| 195 | dataset/357/4d34f-6759-4584-bd89-d4f1eb661969/test_nico_jointure.csv", | 199 | dataset/357/4d34f-6759-4584-bd89-d4f1eb661969/test_nico_jointure.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": "test nico jointure", | 205 | "title": "test nico jointure", | ||
| 202 | "type": "dataset", | 206 | "type": "dataset", | ||
| 203 | "url": | 207 | "url": | ||
| 204 | ev.data4citizen.com/visualisation/information/?id=test_nico_jointure", | 208 | ev.data4citizen.com/visualisation/information/?id=test_nico_jointure", | ||
| 205 | "version": "" | 209 | "version": "" | ||
| 206 | } | 210 | } |