« Modèle:ReqMytheme2 » : différence entre les versions

De Mythemes
Aucun résumé des modifications
Aucun résumé des modifications
 
(9 versions intermédiaires par le même utilisateur non affichées)
Ligne 3 : Ligne 3 :
|fields=Re._pageName, Re.word, Re.pos, Oe._pageName=Œuvre,Oe.univers=Univers, My.categorie, Re.liste=Liste, Re.effGlob, Re.effLoc, Re.coefRep, Re.coefSurRep, Re.distance, Re.coocClassique, Re.csrd
|fields=Re._pageName, Re.word, Re.pos, Oe._pageName=Œuvre,Oe.univers=Univers, My.categorie, Re.liste=Liste, Re.effGlob, Re.effLoc, Re.coefRep, Re.coefSurRep, Re.distance, Re.coocClassique, Re.csrd
|join on=Re.oeuvreId=Oe.oeuvreId, Re.mythemeId=My.mythemeId
|join on=Re.oeuvreId=Oe.oeuvreId, Re.mythemeId=My.mythemeId
|where=Re.mythemeId="{{{mythemeId|}}}" {{#if:{{{auteurs|}}}|AND ( {{#arraymap:{{{auteurs}}}|;|XXX| Oe.auteurs HOLDS "XXX"|\s OR \s}}) }}{{#if:{{{lieuPub|}}}|AND lieuPub NEAR ("{{{lieuPub}}}",10 km) }}{{#if:{{{langs|}}}|AND ( {{#arraymap:{{{langs}}}|;|XXX| Oe.lang = "XXX"|\s OR \s}}) }}{{#if:{{{datePubInf|}}}|AND Oe.datePub > {{{datePubInf}}} }}{{#if:{{{datePubSup|}}}| AND Oe.datePub < {{{datePubSup}}} }}{{#if:{{{dateFiction|}}}| AND ( {{#arraymap:{{{dateFiction}}}|;|XXX| Oe.dateFiction HOLDS "XXX"|\s OR \s}}) }}{{#if:{{{lieuFiction|}}}|AND ( {{#arraymap:{{{lieuFiction}}}|;|XXX| Oe.lieuFiction HOLDS "XXX"| \s OR \s }}) }}{{#if:{{{univers|}}}|AND ( {{#arraymap:{{{univers}}}|;|XXX| univers HOLDS "XXX"| \s OR \s }}) }}{{#if:{{{pos|}}}|AND ( {{#arraymap:{{{pos}}}|;|XXX| Re.pos HOLDS "XXX"| \s OR \s }}) }} AND effGlob > "{{{effGlob|1}}}" AND effLoc > "{{{effLoc|1}}}" AND coefRep > "{{{coefRep|0}}}" AND coefSurRep > "{{{coefSurRep|1}}}" AND distance < "{{{distance|2}}}" AND csrd > "{{{csrd|0}}}" {{#if:{{{categorie|}}}|AND ( {{#arraymap:{{{categorie}}}|;|XXX| My.categorie HOLDS "XXX"| \s OR \s }}) }}
|where=Re.mythemeId="{{{mythemeId|}}}" {{#if:{{{auteurs|}}}|AND ( {{#arraymap:{{{auteurs}}}|;|XXX| Oe.auteurs HOLDS "XXX"|\s OR \s}}) }}{{#if:{{{lieuPub|}}}|AND lieuPub NEAR ("{{{lieuPub}}}",10 km) }}{{#if:{{{langs|}}}|AND ( {{#arraymap:{{{langs}}}|;|XXX| Oe.lang = "XXX"|\s OR \s}}) }}{{#if:{{{datePubInf|}}}| AND YEAR(Oe.datePub) > {{{datePubInf}}} }} {{#if:{{{datePubSup|}}}| AND YEAR(Oe.datePub) < {{{datePubSup}}} }}{{#if:{{{dateFiction|}}}| AND ( {{#arraymap:{{{dateFiction}}}|;|XXX| Oe.dateFiction HOLDS "XXX"|\s OR \s}}) }}{{#if:{{{lieuFiction|}}}|AND ( {{#arraymap:{{{lieuFiction}}}|;|XXX| Oe.lieuFiction HOLDS "XXX"| \s OR \s }}) }}{{#if:{{{univers|}}}|AND ( {{#arraymap:{{{univers}}}|;|XXX| univers HOLDS "XXX"| \s OR \s }}) }}{{#if:{{{pos|}}}|AND ( {{#arraymap:{{{pos}}}|;|XXX| Re.pos HOLDS "XXX"| \s OR \s }}) }} AND effGlob > "{{{effGlob|1}}}" AND effLoc > "{{{effLoc|1}}}" AND coefRep > "{{{coefRep|0}}}" AND coefSurRep > "{{{coefSurRep|1}}}" AND distance < "{{{distance|2}}}" AND csrd > "{{{csrd|0}}}" {{#if:{{{categorie|}}}|AND ( {{#arraymap:{{{categorie}}}|;|XXX| My.categorie HOLDS "XXX"| \s OR \s }}) }}
|group by=Re.word,Re.oeuvreId,Re.mythemeId
|group by=Re.word,Re.oeuvreId,Re.mythemeId
|format= dynamic table
|format= dynamic table
Ligne 15 : Ligne 15 :
|fields=Re._pageName, CONCAT(Re.word,' (tr)')=target, Re.pos, Oe._pageName=Œuvre,Oe.univers=Univers, My.categorie, Re.liste=Liste, Re.effGlob, Re.effLoc, Re.coefRep, Re.coefSurRep, Re.distance, Re.coocClassique, Re.csrd
|fields=Re._pageName, CONCAT(Re.word,' (tr)')=target, Re.pos, Oe._pageName=Œuvre,Oe.univers=Univers, My.categorie, Re.liste=Liste, Re.effGlob, Re.effLoc, Re.coefRep, Re.coefSurRep, Re.distance, Re.coocClassique, Re.csrd
|join on=Re.oeuvreId=Oe.oeuvreId, Re.mythemeId=My.mythemeId
|join on=Re.oeuvreId=Oe.oeuvreId, Re.mythemeId=My.mythemeId
|where=Re.mythemeId="{{{mythemeId|}}}" {{#if:{{{auteurs|}}}|AND ( {{#arraymap:{{{auteurs}}}|;|XXX| Oe.auteurs HOLDS "XXX"}}) }}{{#if:{{{lieuPub|}}}|AND lieuPub NEAR ("{{{lieuPub}}}",10 km) }}{{#if:{{{langs|}}}|AND ( {{#arraymap:{{{langs}}}|;|XXX| Oe.lang = "XXX"}}) }}{{#if:{{{datePubInf|}}}|AND Oe.datePub > "{{{datePubInf}}}" }}{{#if:{{{datePubSup|}}}| AND Oe.datePub < "{{{datePubSup}}}" }}{{#if:{{{dateFiction|}}}| AND ( {{#arraymap:{{{dateFiction}}}|;|XXX| Oe.dateFiction = "XXX"}}) }}{{#if:{{{lieuFiction|}}}|AND ( {{#arraymap:{{{lieuFiction}}}|;|XXX| Oe.lieuFiction = "XXX"| \s OR \s }}) }}{{#if:{{{univers|}}}|AND ( {{#arraymap:{{{univers}}}|;|XXX| univers HOLDS "XXX"| \s OR \s }}) }}{{#if:{{{pos|}}}|AND ( {{#arraymap:{{{pos}}}|;|XXX| Re.pos HOLDS "XXX"| \s OR \s }}) }} AND effGlob > "{{{effGlob|1}}}" AND effLoc > "{{{effLoc|1}}}" AND coefRep > "{{{coefRep|0}}}" AND coefSurRep > "{{{coefSurRep|1}}}" AND distance < "{{{distance|2}}}" AND csrd > "{{{csrd|0}}}" {{#if:{{{categorie|}}}|AND ( {{#arraymap:{{{categorie}}}|;|XXX| My.categorie HOLDS "XXX"| \s OR \s }}) }}
|where=Re.mythemeId="{{{mythemeId|}}}" {{#if:{{{auteurs|}}}|AND ( {{#arraymap:{{{auteurs}}}|;|XXX| Oe.auteurs HOLDS "XXX"|\s OR \s}}) }}{{#if:{{{lieuPub|}}}|AND lieuPub NEAR ("{{{lieuPub}}}",10 km) }}{{#if:{{{langs|}}}|AND ( {{#arraymap:{{{langs}}}|;|XXX| Oe.lang = "XXX"|\s OR \s}}) }}{{#if:{{{datePubInf|}}}| AND YEAR(Oe.datePub) > {{{datePubInf}}} }} {{#if:{{{datePubSup|}}}| AND YEAR(Oe.datePub) < {{{datePubSup}}} }}{{#if:{{{dateFiction|}}}| AND ( {{#arraymap:{{{dateFiction}}}|;|XXX| Oe.dateFiction HOLDS "XXX"|\s OR \s}}) }}{{#if:{{{lieuFiction|}}}|AND ( {{#arraymap:{{{lieuFiction}}}|;|XXX| Oe.lieuFiction HOLDS "XXX"| \s OR \s }}) }}{{#if:{{{univers|}}}|AND ( {{#arraymap:{{{univers}}}|;|XXX| univers HOLDS "XXX"| \s OR \s }}) }}{{#if:{{{pos|}}}|AND ( {{#arraymap:{{{pos}}}|;|XXX| Re.pos HOLDS "XXX"| \s OR \s }}) }} AND effGlob > "{{{effGlob|1}}}" AND effLoc > "{{{effLoc|1}}}" AND coefRep > "{{{coefRep|0}}}" AND coefSurRep > "{{{coefSurRep|1}}}" AND distance < "{{{distance|2}}}" AND csrd > "{{{csrd|0}}}" {{#if:{{{categorie|}}}|AND ( {{#arraymap:{{{categorie}}}|;|XXX| My.categorie HOLDS "XXX"| \s OR \s }}) }}
|group by=Re.word,Re.oeuvreId,Re.mythemeId
|group by=Re.word,Re.oeuvreId,Re.mythemeId
|limit=10000
|limit=10000
Ligne 23 : Ligne 23 :
|delimiter=;
|delimiter=;
}}
}}
{{#cargo_query:tables=ResAnalyses=Re, Oeuvres2=Oe
|join on=Re.oeuvreId=Oe.oeuvreId
|fields=CONCAT(Re.word,' (tr)')=target, CONCAT(Oe.titre,' (oe)'), Re.oeuvreId=source, Re.pos, Re.liste=Liste, Re.effGlob, Re.effLoc, Re.coefRep, Re.coefSurRep, Re.distance, Re.coocClassique, Re.csrd
|where=Re.mythemeId="{{{mythemeId|}}}" {{#if:{{{pos|}}}|AND ( {{#arraymap:{{{pos}}}|;|XXX| Re.pos HOLDS "XXX"| \s OR \s }}) }} AND effGlob > {{{effGlob|1}}} AND effLoc > {{{effLoc|1}}} AND coefRep > {{{coefRep|0}}} AND coefSurRep > {{{coefSurRep|1}}} AND distance < {{{distance|2}}} AND csrd > {{{csrd|0}}}
|group by=Re.word, Re.oeuvreId, Re.mythemeId
|limit=5000
|format=csv
|filename=Edges-{{#replace:{{{mythemeId|}}}| |_}}.csv
|link text=Edges : {{tr|Télécharger les arêtes en csv}}
|delimiter=;
}}


{{#cargo_query:tables=ResAnalyses=Re, Oeuvres2=Oe
{{#cargo_query:tables=ResAnalyses=Re, Oeuvres2=Oe
|fields=Oe._pageName=Œuvre,Oe.univers=Univers
|fields=Oe._pageName=Œuvre,Oe.univers=Univers
|join on=Re.oeuvreId=Oe.oeuvreId
|join on=Re.oeuvreId=Oe.oeuvreId
|where=Re.mythemeId="{{{mythemeId|}}}" {{#if:{{{auteurs|}}}|AND ( {{#arraymap:{{{auteurs}}}|;|XXX| Oe.auteurs HOLDS "XXX"}}) }}{{#if:{{{lieuPub|}}}|AND lieuPub NEAR ("{{{lieuPub}}}",10 km) }}{{#if:{{{langs|}}}|AND ( {{#arraymap:{{{langs}}}|;|XXX| Oe.lang = "XXX"}}) }}{{#if:{{{datePubInf|}}}|AND Oe.datePub > "{{{datePubInf}}}" }}{{#if:{{{datePubSup|}}}| AND Oe.datePub < "{{{datePubSup}}}" }}{{#if:{{{dateFiction|}}}| AND ( {{#arraymap:{{{dateFiction}}}|;|XXX| Oe.dateFiction = "XXX"}}) }}{{#if:{{{lieuFiction|}}}|AND ( {{#arraymap:{{{lieuFiction}}}|;|XXX| Oe.lieuFiction = "XXX"| \s OR \s }}) }}{{#if:{{{univers|}}}|AND ( {{#arraymap:{{{univers}}}|;|XXX| univers HOLDS "XXX"| \s OR \s }}) }}{{#if:{{{pos|}}}|AND ( {{#arraymap:{{{pos}}}|;|XXX| Re.pos HOLDS "XXX"| \s OR \s }}) }} AND effGlob > "{{{effGlob|1}}}" AND effLoc > "{{{effLoc|1}}}" AND coefRep > "{{{coefRep|0}}}" AND coefSurRep > "{{{coefSurRep|1}}}" AND distance < "{{{distance|2}}}" AND csrd > "{{{csrd|0}}}" {{#if:{{{categorie|}}}|AND ( {{#arraymap:{{{categorie}}}|;|XXX| My.categorie HOLDS "XXX"| \s OR \s }}) }}
|where=Re.mythemeId="{{{mythemeId|}}}" {{#if:{{{auteurs|}}}|AND ( {{#arraymap:{{{auteurs}}}|;|XXX| Oe.auteurs HOLDS "XXX"|\s OR \s}}) }}{{#if:{{{lieuPub|}}}|AND lieuPub NEAR ("{{{lieuPub}}}",10 km) }}{{#if:{{{langs|}}}|AND ( {{#arraymap:{{{langs}}}|;|XXX| Oe.lang = "XXX"|\s OR \s}}) }}{{#if:{{{datePubInf|}}}| AND YEAR(Oe.datePub) > {{{datePubInf}}} }} {{#if:{{{datePubSup|}}}| AND YEAR(Oe.datePub) < {{{datePubSup}}} }}{{#if:{{{dateFiction|}}}| AND ( {{#arraymap:{{{dateFiction}}}|;|XXX| Oe.dateFiction HOLDS "XXX"|\s OR \s}}) }}{{#if:{{{lieuFiction|}}}|AND ( {{#arraymap:{{{lieuFiction}}}|;|XXX| Oe.lieuFiction HOLDS "XXX"| \s OR \s }}) }}{{#if:{{{univers|}}}|AND ( {{#arraymap:{{{univers}}}|;|XXX| univers HOLDS "XXX"| \s OR \s }}) }}{{#if:{{{pos|}}}|AND ( {{#arraymap:{{{pos}}}|;|XXX| Re.pos HOLDS "XXX"| \s OR \s }}) }} AND effGlob > "{{{effGlob|1}}}" AND effLoc > "{{{effLoc|1}}}" AND coefRep > "{{{coefRep|0}}}" AND coefSurRep > "{{{coefSurRep|1}}}" AND distance < "{{{distance|2}}}" AND csrd > "{{{csrd|0}}}" {{#if:{{{categorie|}}}|AND ( {{#arraymap:{{{categorie}}}|;|XXX| My.categorie HOLDS "XXX"| \s OR \s }}) }}
|group by=Re.word,Re.oeuvreId,Re.mythemeId
|group by=Re.oeuvreId
|limit=10000
|limit=10000
|format= csv
|format= csv
|filename=Nodes-{{#replace:{{{mythemeId|}}}| |_}}.csv
|filename=Nodes-{{#replace:{{{mythemeId|}}}| |_}}.csv
|link text={{int:Oeuvre-Telecharger_en_csv}}
|link text=Nodes : {{tr|Télécharger les nœuds en csv}}
|delimiter=;
|delimiter=;
}}
}}

Version actuelle datée du 1 septembre 2023 à 10:23

Aucun résultat

Télécharger en csv

Edges : Télécharger les arêtes en csv


Nodes : Télécharger les nœuds en csv

Récupérée de « https://mythemes.unistra.fr/w/index.php?title=Modèle:ReqMytheme2&oldid=384243 »