Changes for page Hjem

Last modified by Normann P. Nielsen on 2026/11/20 07:06

From version 33.1
edited by Normann P. Nielsen
on 2026/11/18 18:10
Change comment: There is no comment for this version
To version 34.1
edited by Normann P. Nielsen
on 2026/11/18 18:45
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -8,8 +8,9 @@
8 8  
9 9  |=(((
10 10  = Nyeste Blogs =
11 +
11 11  {{velocity}}
12 -#set ($hql = "select distinct doc.fullName from XWikiDocument doc, BaseObject obj where obj.name = doc.fullName and obj.className = 'Blog.BlogPostClass' and doc.hidden = false order by doc.creationDate desc")
13 +#set ($hql = "select doc.fullName from XWikiDocument doc where doc.hidden = false and exists (select obj.id from BaseObject obj where obj.name = doc.fullName and obj.className = 'Blog.BlogPostClass') order by doc.creationDate desc")
13 13  #set ($query = $services.query.hql($hql))
14 14  #set ($discard = $query.setLimit(500))
15 15  #set ($pages = $query.execute())
... ... @@ -33,6 +33,7 @@
33 33  {{/velocity}}
34 34  
35 35  = Nyeste sider =
37 +
36 36  {{velocity}}
37 37  #set ($hql = "select doc.fullName from XWikiDocument doc where doc.hidden = false and doc.fullName not in (select obj.name from BaseObject obj where obj.className = 'Blog.BlogPostClass') order by doc.creationDate desc")
38 38  #set ($query = $services.query.hql($hql))