Changes for page Publications
From version 27.1
edited by Andrea Omicini
on 12/11/2021 22:48
on 12/11/2021 22:48
Change comment:
There is no comment for this version
To version 16.2
edited by Andrea Omicini
on 08/08/2021 01:47
on 08/08/2021 01:47
Change comment:
There is no comment for this version
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -1,3 +1,32 @@ 1 -{{velocity}}###set( $tag = 'Arg2P' ){{/velocity}} 2 -{{include reference="Publications.Tag;tag=Arg2P"/}} 3 -{{include reference='Environment'/}} 1 +{{velocity}}## 2 +## generic query parameters 3 +#set ( $from = ", BaseObject as obj0, DBStringListProperty as prop0 join prop0.list item, BaseObject as obj1, StringProperty as prop1, LongProperty as prop2" ) 4 +#set( $where1 = " 5 + obj0.className = 'XWiki.TagClass' and 6 + obj0.name = doc.fullName and 7 + obj0.id = prop0.id.id and 8 + prop0.id.name = 'tags' and 9 + obj1.name = doc.fullName and 10 + obj1.className = 'Publications.PublicationClass' and 11 + obj1.name <> 'Publications.PublicationClassTemplate' and 12 + obj1.name <> 'Publications.PublicationTemplate' and 13 + prop1.id.id = obj1.id and 14 + prop1.name = 'status' and 15 + prop1.value = 'Published' and 16 + prop2.id.id=obj1.id and 17 + prop2.name = 'year' 18 +" ) 19 +#set ( $where3 = "order by prop2.value asc" ) 20 +#set ( $tag = 'Arg2P' ) 21 +#### set query parameters for specific sort/tag 22 +#set( $where2 = " and lower(item)=lower('$tag') " ) 23 +#set( $sql = $from + " where " + $where1 + $where2 + $where3 ) 24 +#set( $pubsFound = $xwiki.searchDocuments($sql) ) 25 +#### list pubs for each sort/tag 26 +#foreach ($pub in $pubsFound) 27 +* {{pubLinks}}$pub{{/pubLinks}} 28 +#end 29 +{{/velocity}}{{include reference='Arg2p.MacroSheet'/}} 30 + 31 + 32 +