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
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
on 2026/11/18 18:45
Change comment:
There is no comment for this version
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -8,8 +8,9 @@ 8 8 9 9 |=((( 10 10 = Nyeste Blogs = 11 + 11 11 {{velocity}} 12 -#set ($hql = "select d istinct 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))