 |
3.1 |
8 |
#set( $pubTag = "DPDF") |
|
|
9 |
#set ( $from = ", BaseObject as obj0, DBStringListProperty as prop0 join prop0.list item, BaseObject as obj1, StringProperty as prop1, LongProperty as prop2" ) |
|
|
10 |
#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" ) |
|
|
11 |
#set ( $sql = $from + " where " + $where ) |
|
|
12 |
#set($pubFound = $xwiki.searchDocuments($sql)) |
|
|
13 |
#foreach ($pub in $pubFound) |
|
|
14 |
* {{pubLinks}}$pub{{/pubLinks}} |
| |
3.1 |
19 |
##tagged research on Publications space based on tag "SME" |
|
|
20 |
#set( $pubTag = "SME") |
|
|
21 |
#set ( $from = ", BaseObject as obj0, DBStringListProperty as prop0 join prop0.list item, BaseObject as obj1, StringProperty as prop1, LongProperty as prop2" ) |
|
|
22 |
#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" ) |
|
|
23 |
#set ( $sql = $from + " where " + $where ) |
|
|
24 |
#set($pubFound = $xwiki.searchDocuments($sql)) |
|
|
25 |
#foreach ($pub in $pubFound) |
|
|
26 |
* {{pubLinks}}$pub{{/pubLinks}} |
|
|
27 |
#end |
