Foreign: Difference between revisions
No edit summary |
No edit summary |
||
| Line 6: | Line 6: | ||
SELECT ?Nom ?Prenom (CONCAT("<a href='", STR(?personne), "' target='_blank'>", REPLACE(STR(?personne), "https://data.arch.be/entity/", ""), "</a>") AS ?PersonneID) | SELECT ?Nom ?Prenom (CONCAT("<a href='", STR(?personne), "' target='_blank'>", REPLACE(STR(?personne), "https://data.arch.be/entity/", ""), "</a>") AS ?PersonneID) | ||
(CONCAT(SUBSTR(STR(?dateNaissance), 1, 4), "-", SUBSTR(STR(?dateNaissance), 6, 2), "-", SUBSTR(STR(?dateNaissance), 9, 2)) AS ?DateNaissance) | (CONCAT(SUBSTR(STR(?dateNaissance), 1, 4), "-", SUBSTR(STR(?dateNaissance), 6, 2), "-", SUBSTR(STR(?dateNaissance), 9, 2)) AS ?DateNaissance) | ||
?domicileLabel | ?paysLabel ?domicileLabel ?FondsArchivesLabel ?NoInventaire | ||
WHERE { | WHERE { | ||
| Line 27: | Line 27: | ||
# Récupérer les labels automatiquement en français | # Récupérer les labels automatiquement en français | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],fr". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],fr". } | ||
} | |||
ORDER BY ASC(?paysLabel) ASC(?DomicileLabel) ASC(?Nom) | |||
| chart=bordercloud.visualization.DataTable | | chart=bordercloud.visualization.DataTable | ||
Revision as of 09:52, 20 September 2024