Changes for page Publications

Summary

• Page properties (2 modified, 0 added, 0 removed)

Details

Page properties

Title

...	...	@@ -1,0 +1,1 @@
	1	+Arg2P Publications

Content

...	...	@@ -1,4 +1,34 @@
1		-= {{stringIta}}Pubblicazioni {{/stringIta}}{{arg2p/}}{{stringEng}} Publications{{/stringEng}} =
2		-{{velocity}}#set( $tag = 'Arg2P' ){{/velocity}}
3		-{{include reference="Publications.Tag"/}}
4		-{{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	+#### select tags
	22	+== {{english}}{{arg2p/}} Publications{{/english}}{{italian}}Pubblicazioni {{arg2p/}}{{/italian}} ==
	23	+#### set query parameters for specific sort/tag
	24	+ #set ( $where2 = " and lower(item)=lower('$tag') " )
	25	+ #set ( $sql = $from + " where " + $where1 + $where2 + $where3 )
	26	+ #set($pubsFound = $xwiki.searchDocuments($sql))
	27	+#### list pubs for each sort/tag
	28	+ #foreach ($pub in $pubsFound)
	29	+ * {{pubLinks}}$pub{{/pubLinks}}
	30	+ #end
	31	+#end{{/velocity}}{{include reference='Arg2p.MacroSheet'/}}
	32	+
	33	+
	34	+