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

De Mythemes
(Page créée avec « <includeonly> {{#cargo_query:tables=ResAnalyses=Re, Mythemes2=My |join on=Re.mythemeId=My.mythemeId |fields=Re._pageName, Re.word, Re.pos, My.titre=Mytheme, Re.liste=Liste, My.categorie, Re.effGlob, Re.effLoc, Re.coefRep, Re.coefSurRep, Re.distance, Re.coocClassique, Re.csrd |where=Re.oeuvreId="{{{oeuvreId|}}}" {{#if:{{{mythemeId|}}}|AND ( {{#arraymap:{{{mythemeId}}}|;|XXX| My.mythemeId = "XXX" | \s OR \s }}) }} {{#if:{{{mythemeIdExclus|}}}|AND ( {{#arraymap:{{{m... »)
 
Aucun résumé des modifications
 
(3 versions intermédiaires par le même utilisateur non affichées)
Ligne 3 : Ligne 3 :
|join on=Re.mythemeId=My.mythemeId
|join on=Re.mythemeId=My.mythemeId
|fields=Re._pageName, Re.word, Re.pos, My.titre=Mytheme, Re.liste=Liste, My.categorie, Re.effGlob, Re.effLoc, Re.coefRep, Re.coefSurRep, Re.distance, Re.coocClassique, Re.csrd
|fields=Re._pageName, Re.word, Re.pos, My.titre=Mytheme, Re.liste=Liste, My.categorie, Re.effGlob, Re.effLoc, Re.coefRep, Re.coefSurRep, Re.distance, Re.coocClassique, Re.csrd
|where=Re.oeuvreId="{{{oeuvreId|}}}" {{#if:{{{mythemeId|}}}|AND ( {{#arraymap:{{{mythemeId}}}|;|XXX| My.mythemeId = "XXX" | \s OR \s }}) }} {{#if:{{{mythemeIdExclus|}}}|AND ( {{#arraymap:{{{mythemeIdExclus}}}|;|XXX| My.mythemeId <> "XXX" | \s AND \s }}) }} {{#if:{{{pos|}}}|AND ( {{#arraymap:{{{pos}}}|;|XXX| Re.pos HOLDS "XXX"| \s OR \s }}) }} {{#if:{{{liste|}}}|AND ( {{#arraymap:{{{liste}}}|;|XXX| Re.liste HOLDS "XXX"}}) }} 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.oeuvreId="{{{oeuvreId|}}}" {{#if:{{{mythemeId|}}}|AND ( {{#arraymap:{{{mythemeId}}}|;|XXX| My.mythemeId = "XXX" | \s OR \s }}) }} {{#if:{{{mythemeIdExclus|}}}|AND ( {{#arraymap:{{{mythemeIdExclus}}}|;|XXX| My.mythemeId <> "XXX" | \s AND \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 :
|join on=Re.mythemeId=My.mythemeId
|join on=Re.mythemeId=My.mythemeId
|fields=CONCAT(Re.word,' (tr)')=target, CONCAT(My.titre,' (my)'), Re.mythemeId=source, Re.pos, Re.liste=Liste, My.categorie, Re.effGlob, Re.effLoc, Re.coefRep, Re.coefSurRep, Re.distance, Re.coocClassique, Re.csrd
|fields=CONCAT(Re.word,' (tr)')=target, CONCAT(My.titre,' (my)'), Re.mythemeId=source, Re.pos, Re.liste=Liste, My.categorie, Re.effGlob, Re.effLoc, Re.coefRep, Re.coefSurRep, Re.distance, Re.coocClassique, Re.csrd
|where=Re.oeuvreId="{{{oeuvreId|}}}" {{#if:{{{mythemeId|}}}|AND ( {{#arraymap:{{{mythemeId}}}|;|XXX| My.mythemeId = "XXX" | \s OR \s }}) }} {{#if:{{{mythemeIdExclus|}}}|AND ( {{#arraymap:{{{mythemeIdExclus}}}|;|XXX| My.mythemeId <> "XXX" | \s AND \s }}) }} {{#if:{{{pos|}}}|AND ( {{#arraymap:{{{pos}}}|;|XXX| Re.pos HOLDS "XXX"| \s OR \s }}) }} {{#if:{{{liste|}}}|AND ( {{#arraymap:{{{liste}}}|;|XXX| Re.liste HOLDS "XXX"}}) }} 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.oeuvreId="{{{oeuvreId|}}}" {{#if:{{{mythemeId|}}}|AND ( {{#arraymap:{{{mythemeId}}}|;|XXX| My.mythemeId = "XXX" | \s OR \s }}) }} {{#if:{{{mythemeIdExclus|}}}|AND ( {{#arraymap:{{{mythemeIdExclus}}}|;|XXX| My.mythemeId <> "XXX" | \s AND \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=5000
|limit=5000
|format=csv
|format=csv
|filename=Edges-{{#replace:{{{oeuvreId|}}}| |_}}.csv
|filename=Edges-{{#replace:{{{oeuvreId|}}}| |_}}.csv
|link text=Edges : {{int:Oeuvre-Telecharger_en_csv}}
|link text=Edges : {{tr|Télécharger les arêtes en csv}}
|delimiter=;
|delimiter=;
}}
}}
Ligne 27 : Ligne 27 :
|join on=Re.mythemeId=My.mythemeId
|join on=Re.mythemeId=My.mythemeId
|fields=Re.mythemeId=Id, My.titre=Mytheme, My.categorie=Type
|fields=Re.mythemeId=Id, My.titre=Mytheme, My.categorie=Type
|where=Re.oeuvreId="{{{oeuvreId|}}}" {{#if:{{{mythemeId|}}}|AND ( {{#arraymap:{{{mythemeId}}}|;|XXX| My.mythemeId = "XXX" | \s OR \s }}) }} {{#if:{{{mythemeIdExclus|}}}|AND ( {{#arraymap:{{{mythemeIdExclus}}}|;|XXX| My.mythemeId <> "XXX" | \s AND \s }}) }} {{#if:{{{pos|}}}|AND ( {{#arraymap:{{{pos}}}|;|XXX| Re.pos HOLDS "XXX"| \s OR \s }}) }} {{#if:{{{liste|}}}|AND ( {{#arraymap:{{{liste}}}|;|XXX| Re.liste HOLDS "XXX"}}) }} 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.oeuvreId="{{{oeuvreId|}}}" {{#if:{{{mythemeId|}}}|AND ( {{#arraymap:{{{mythemeId}}}|;|XXX| My.mythemeId = "XXX" | \s OR \s }}) }} {{#if:{{{mythemeIdExclus|}}}|AND ( {{#arraymap:{{{mythemeIdExclus}}}|;|XXX| My.mythemeId <> "XXX" | \s AND \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.mythemeId
|group by=Re.mythemeId
|limit=5000
|limit=5000
|format=csv
|format=csv
|filename=Nodes-{{#replace:{{{oeuvreId|}}}| |_}}.csv
|filename=Nodes-{{#replace:{{{oeuvreId|}}}| |_}}.csv
|link text=Nodes : {{int:Oeuvre-Telecharger_en_csv}}
|link text=Nodes : {{tr|Télécharger les nœuds en csv}}
|delimiter=;
|delimiter=;
}}
}}
</includeonly>
</includeonly>

Version actuelle datée du 1 septembre 2023 à 09:42