Template:Include featured references models cargo: Difference between revisions

From CSDMS
No edit summary
No edit summary
(14 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{#ifeq:{{#cargo_query:tables=RefsInt1,RefsInt2|join on=RefsInt1._pageName=RefsInt2._pageName|fields=FeatureRef,PublicationMultipleModelsCargo|where = RefsInt1.FeatureRef="YES" AND PublicationMultipleModelsCargo LIKE "{{PAGENAME}}"|default=}}|||{{Publication_table_models2}} {{#arraydefine:refs |{{#cargo_query:tables=RefsInt1,RefsInt2|join on=RefsInt1._pageName=RefsInt2._pageName|fields=FeatureRef,PublicationMultipleModelsCargo|where = RefsInt1.FeatureRef="YES" AND PublicationMultipleModelsCargo LIKE "{{PAGENAME}}"|fields=RefsInt2._pageName|format=template|template=Test3a}} }} }}
{{#ifeq:
{{#cargo_query:tables=RefsInt1,RefsInt2
|join on=RefsInt1._pageName=RefsInt2._pageName
|fields=FeatureRef,PublicationMultipleModelsCargo
|where = FeatureRef="Yes" AND PublicationMultipleModelsCargo LIKE "{{PAGENAME}}"
|default=}}
||
|{{Publication_table_models2}} {{#arraydefine:refs |
{{#cargo_query:tables=RefsInt1,RefsInt2
|join on=RefsInt1._pageName=RefsInt2._pageName
|fields=FeatureRef,PublicationMultipleModelsCargo
|where = RefsInt1.FeatureRef="Yes" AND PublicationMultipleModelsCargo LIKE "{{PAGENAME}}"
|fields=RefsInt2._pageName|format=template|template=Test3a}} }} }}
{{
{{
   #loop: i
   #loop: i
Line 6: Line 18:
   | <tr><td> {{
   | <tr><td> {{
     #arraydefine: val | {{#arrayindex:refs | {{#var:i}} }} | ;
     #arraydefine: val | {{#arrayindex:refs | {{#var:i}} }} | ;
     }}{{#ifeq:{{#cargo_query:tables=RefsExt2|where = _pageName = '{{#arrayindex: val | 0}}'|default=|fields=ItemType}}| |{{#cargo_query:tables= AuthorsMan|where = _pageName = '{{#arrayindex: val | 0}}'|default=|fields=_ID, Firstname|order by=_ID ASC |format=template|template=Test4b}}{{#cargo_query:tables=BibEntryCargo|where = _pageName = '{{#arrayindex: val | 0}}'|default=|fields=_pageName, BibType,Title, Editors, Year, Journal, Booktitle, Volume,Pages, URL, DOI, ISBN, Note|format=template|template=Test6a}}|{{#cargo_query:tables=RefsExt|where = _pageName = '{{#arrayindex: val | 0}}'|default=|fields=_ID, Lastname, Firstname|order by=_ID ASC |format=template|template=Test4a}}{{#cargo_query:tables=RefsExt2|where = _pageName = '{{#arrayindex: val | 0}}'|default=|fields=_pageName, ItemType, Title , PublicationTitle,  Booktitle, JournalAbbreviation, Volume, Issue, Url, DOI, Pagenumbers, Publicationdate, AccessDate |format=template|template=Test5a}} }}</td><td>{{#cargo_query:tables=RefsInt2|where = _pageName = '{{#arrayindex: val | 0}}'|default=|fields= PublicationMultipleModelsCargo|format=template|template=Test7a}}</td><td>{{#cargo_query:tables=RefsInt1|where = _pageName = '{{#arrayindex: val | 0}}'|default=|fields= PublicationWhatKindOf, PublicationClusterID, PublicationCitationsNr, MS_PublicationClusterID|format=template|template=Test8a}}</td>
     }}
}}</table></div></div>
{{#ifeq:
{{#cargo_query:tables=RefsExt2
|where = _pageName = '{{#arrayindex: val | 0}}'
|default=
|fields=ItemType}}
| |
{{#cargo_query:tables=BibEntryCargo
|where = _pageName = '{{#arrayindex: val | 0}}'
|default=  
|fields=_pageName=Page, BibType=bib,Title=tit, Editors=eds, DATE_FORMAT(Year,"%Y")=var1, Journal=jour, Booktitle=book, Volume=vol, Pages=pag, URL=url, DOI=doi, ISBN=isb, Note=note, Firstname=name
|named args=yes
|format=template|template=Test6b}}
|{{#cargo_query:tables=RefsExt
|where = _pageName = '{{#arrayindex: val | 0}}'
|default=
|fields=_ID=id, Lastname=lastname, Firstname=firstname
|named args=yes
|order by=_ID ASC
|format=template
|template=Test4a}}{{#cargo_query:tables=RefsExt2
|where = _pageName = '{{#arrayindex: val | 0}}'
|default=
|fields=_pageName=Page, ItemType=item, Title=tit , PublicationTitle=pubtit,  Booktitle=booktit, JournalAbbreviation=jourabb, Volume=vol, Issue=issue, Url=url, DOI=doi, Pagenumbers=pages, Publicationdate=pubdate, AccessDate=accessdate
|named args=yes
|format=template|template=Test5a}} }}</td>
<td>{{#cargo_query:tables=RefsInt2
|where = _pageName = '{{#arrayindex: val | 0}}'
|default=
|fields= PublicationMultipleModelsCargo
|format=template
|template=Test7a}}</td>
<td>{{#cargo_query:tables=RefsInt1
|where = _pageName = '{{#arrayindex: val | 0}}'
|default=
|fields= PublicationWhatKindOf, PublicationClusterID, PublicationCitationsNr, MS_PublicationClusterID
|format=template|template=Test8a}}</td>
}}
{{#ifexist:{{PAGENAME}}-Publications|<tr><td>[[{{PAGENAME}}-Publications|See more publications of {{PAGENAME}}]]</td><td></td><td></td><td></td><td></td></tr>}}</table></div></div>

Revision as of 15:22, 27 October 2021