Wiki source code of simpA Publications

version	line-number	content
6.1	1	{{include document="Main.MacroSheet"/}}{{include document="Publications.MacroSheetOld"/}}{{include document="ReSpecT.MacroSheet"/}}
	2	{{velocity filter="none"}}{{html clean="false" wiki="true"}}
4.1	3	== Publications about simpA in the #apice() Space ==
1.1	4
4.1	5	##tagged research on Publications space based on tag "simpA"
	6	#set( $pubTag = "simpA")
	7	#set ( $from = ", BaseObject as obj0, DBStringListProperty as prop0 join prop0.list item, BaseObject as obj1, StringProperty as prop1, LongProperty as prop2" )
	8	#set ( $where = "obj0.className='XWiki.TagClass' and obj0.name=doc.fullName and obj0.id=prop0.id.id and prop0.id.name='tags' and lower(item)=lower('$pubTag') and obj1.name=doc.fullName and obj1.className='Publications.PublicationClass' and obj1.name<>'Publications.PublicationClassTemplate' and prop1.id.id=obj1.id and prop1.name='status' and prop1.value='Published' and prop2.id.id=obj1.id and prop2.name = 'year' order by prop2.value desc" )
	9	#set ( $sql = $from + " where " + $where )
	10	#set($pubFound = $xwiki.searchDocuments($sql))
	11	#foreach ($pub in $pubFound)
	12	* {{pubLinks}}$pub{{/pubLinks}}
1.1	13	#end
	14
6.1	15	{{/html}}{{/velocity}}