- xwiki-devs@xwiki.org - lists.xwiki.org

Re: [xwiki-devs] Ref: Displaying lists of wiki pages given a set of criteria
by goldring, richard 09 Oct '07

09 Oct '07

Guillaume, I'll make time and see what I can do. Regards, Richard -----Original Message----- From: devs-bounces(a)xwiki.org [mailto:devs-bounces@xwiki.org]On Behalf Of Guillaume Lerouge Sent: 09 October 2007 14:09 To: XWiki Developers Subject: Re: [xwiki-devs] Ref: Displaying lists of wiki pages given a set of criteria Hi Richard, how would you feel about writing a tutorial about what you did and adding it to the tutorial page on the DevGuide with some screenshots? I'm sure this would be quite useful for a lot of us... And you would help set the tone towards more user-contributed documentation ;-) (plus I'm sure you could be added to XWiki's Hall of Fame for doing this :-) Many thanks in advance, Guillaume On 09/10/2007, goldring, richard < richard.goldring(a)uk.thalesgroup.com <mailto:richard.goldring@uk.thalesgroup.com> > wrote: Hey it works! I coded it thus: 1.1 Listing documents by searching on their object properties - XWikiUsers and first name #set ($list = $xwiki.search("select doc.fullName from XWikiDocument doc, BaseObject obj, StringProperty prop where doc.fullName=obj.name and obj.className='XWiki.XWikiUsers' and prop.id.id=obj.id and prop.name='first_name' and prop.value='Graham'", 5, 0)) #includeForm("XWiki.Results") 1.1 Listing documents by searching on their object properties - Article and title #set ($list = $xwiki.search("select doc.fullName from XWikiDocument doc, BaseObject obj, StringProperty prop where doc.fullName=obj.name and obj.className='XWiki.ArticleClass' and prop.id.id=obj.id and prop.name='title' and prop.value like 'Art%'", 5, 0)) #includeForm("XWiki.Results") and it displays the results using the Results table (although with two #includeForm("XWiki.Results") it displays the filter columns twice on the first table and no fitler columns on the second table on the same page?). So thanks again Jean-Vincent!!!! This is really going to help me (and others) use XWiki to develop useful applications with it. Best Regards, Richard -----Original Message----- From: devs-bounces(a)xwiki.org <mailto:devs-bounces@xwiki.org> [mailto: devs-bounces(a)xwiki.org <mailto:devs-bounces@xwiki.org> ]On Behalf Of Jean-Vincent Drean Sent: 09 October 2007 13:12 To: XWiki Developers Subject: Re: [xwiki-devs] Ref: Displaying lists of wiki pages given a set of criteria Added here : http://www.xwiki.org/xwiki/bin/view/DevGuide/velocityHqlExamples#HGettingdoc <http://www.xwiki.org/xwiki/bin/view/DevGuide/velocityHqlExamples#HGettingdo c> umentswhereobjects27propertiesequalssomevalue JV. 2007/10/9, goldring, richard < richard.goldring(a)uk.thalesgroup.com <mailto:richard.goldring@uk.thalesgroup.com> >: > Thanks Jean-Vincent, > > What you've done helps ... but how does one list documents with a certain > object attached whom's properties = a certain value? > > Regards, > > Richard > > -----Original Message----- > From: devs-bounces(a)xwiki.org <mailto:devs-bounces@xwiki.org> [mailto: devs-bounces(a)xwiki.org <mailto:devs-bounces@xwiki.org> ]On Behalf Of > Jean-Vincent Drean > Sent: 09 October 2007 12:34 > To: XWiki Developers > Subject: Re: [xwiki-devs] Ref: Displaying lists of wiki pages given a > set of criteria > > > I've started documenting hql queries through public and privileged APIs > here: > http://www.xwiki.org/xwiki/bin/view/DevGuide/velocityHqlExamples <http://www.xwiki.org/xwiki/bin/view/DevGuide/velocityHqlExamples> > > The privileged API will fit your need (don't forget to protect the > edition of your scripts pages by non-admins). > > JV. > > 2007/10/9, goldring, richard < richard.goldring(a)uk.thalesgroup.com <mailto:richard.goldring@uk.thalesgroup.com> >: > > Jean-Vincent, > > > > Thanks - I tried it and it worked. > > > > What I'd like to do now is to have a set of pages with objects attached > and > > to search those pages by the attributes on those objects. > > > > So for example the pages could represent 'tasks', the objects would store > > details of those tasks e.g. task status, task owner, task description, > task > > date, etc. On a browser page a search/filter could then be done on say > task > > status to list all uncompleted tasks. > > > > Any idea how to do that? > > > > Also is there any documentation on how to do these searches using: > > > > $xwiki.xWiki.search("select count(doc) from XWikiDocument doc ${query}", > > $context.context).get(0)) > > > > and > > > > #set ($list = $xwiki.searchDocuments($query, $resultsPerPage, $start)) > > > > i.e. what database tables to search - a description of how these methods > > work and how to use them, etc > > > > If anyone has some more examples and explaination of these then it would > > really help! Thanks! > > > > Regards, > > > > Richard > > > > -----Original Message----- > > From: devs-bounces(a)xwiki.org <mailto:devs-bounces@xwiki.org> [mailto: devs-bounces(a)xwiki.org <mailto:devs-bounces@xwiki.org> ]On Behalf Of > > Jean-Vincent Drean > > Sent: 03 October 2007 15:00 > > To: XWiki Developers > > Subject: Re: [xwiki-devs] Ref: Displaying lists of wiki pages given a > > set of criteria > > > > > > The snippet on xwiki.org <http://xwiki.org> : > > http://www.xwiki.org/xwiki/bin/view/Code/PaginateSearch <http://www.xwiki.org/xwiki/bin/view/Code/PaginateSearch> > > > > 2007/10/3, Jean-Vincent Drean < jv(a)xwiki.com <mailto:jv@xwiki.com> >: > > > Hi, > > > > > > It's a recurrent need but AFAIK we don't have any generic solution. > > > I've made a 5' snippet, hope it will be useful. > > > > > > This snippet requires programming rights ($xwiki.xWiki.search) so > > > you'll have to make sure that simple users can't edit this page. > > > > > > > > > -----------------------------------------------8<--------------------------- > > ---------------------------------------- > > > #macro(paginedSearch $query $currentPage $resultsPerPage) > > > #set ($start = $resultsPerPage * $currentPage) > > > #set ($resultsnb = $xwiki.xWiki.search("select count(doc) from > > > XWikiDocument doc ${query}", $context.context).get(0)) > > > #if ($resultsnb > $resultsPerPage) > > > #set ($pagesnb = $resultsnb / $resultsPerPage) > > > #foreach ($pagenb in [0..$pagesnb]) > > > [$pagenb>$doc.fullName?page=$pagenb] > > > #end > > > #end > > > #set ($list = $xwiki.searchDocuments($query, $resultsPerPage, $start)) > > > #foreach ($item in $list) > > > * $item > > > #end > > > #end > > > > > > #if ($request.page) > > > #set ($desiredStart = $xwiki.parseInt($request.page)) > > > #else > > > #set ($desiredStart = 0) > > > #end > > > > > > #paginedSearch("where 1=1" $desiredStart 5) > > > > > > -----------------------------------------------8<--------------------------- > > ---------------------------------------- > > > > > > 2007/10/3, goldring, richard < richard.goldring(a)uk.thalesgroup.com <mailto:richard.goldring@uk.thalesgroup.com> >: > > > > Anyone? > > > > > > > > > > > > Hi all, > > > > > > > > Does anyone know how to generate a list of links to wiki pages that > meet > > a > > > > set of defined features i.e. filter and sort (features defined on the > > > > objects or tags on those pages)? Perhaps like the Google search, list > > the > > > > first 20 or 30 pages and have a next/previous, 1, 2, 3, etc buttons to > > list > > > > the next selections of page links (to cope with the display of large > > numbers > > > > of page links). > > > > > > > > If anyones got any code snipits to get me started then that would be > > really > > > > useful - thanks. > > > > > > > > The idea is perhaps to explore how to use XWiki to semi automatically > > > > generate pages to record tasks or issues, and then to list those pages > > > > (tasks/issues) according to say the status or owners of those > > tasks/issues. > > > > For tasks I'm thinking XWiki might be used to help guide users through > > > > business processes and semi-automatically document they have followed > > those > > > > processes (for CMMI) so they can be simply audited. Documents > generated > > > > through users following the tasks/processes can then be generated from > > > > templates and stored within the wiki. If anyone else has any > ideas/code > > that > > > > could help perhaps realise this then let me know! > > > > > > > > Regards, > > > > > > > > Richard Goldring > > > > > > > > TAO > > > > Wookey Hole Road > > > > Wells, Somerset > > > > BA5 1AA > > > > > > > > Direct Line: 01749 682694 > > > > Switchboard: 01749 672081 > > > > richard.goldring(a)uk.thalesgroup.com <mailto:richard.goldring@uk.thalesgroup.com> > > > > > > > > > > > > > > > > > > > > Thales UK Ltd (Wells) DISCLAIMER: The information contained in this > > e-mail > > > > is confidential. It may also be legally privileged. It is intended > only > > for > > > > the stated addressee(s) and access to it by any other person is > > > > unauthorised. If you are not an addressee, you must not disclose, > copy, > > > > circulate or in any other way use or rely on the information contained > > in > > > > this e-mail. Such unauthorised use may be unlawful. We may monitor all > > > > e-mail communications through our networks. If you have received this > > e-mail > > > > in error, please inform us immediately on +44 (0) 1749 672081 and > delete > > it > > > > and all copies from your system. We accept no responsibility for > changes > > to > > > > any e-mail which occur after it has been sent. Attachments to this > > e-mail > > > > may contain software viruses which could damage your system. We > > therefore > > > > recommend you virus-check all attachments before opening. A business > of > > > > Thales UK Ltd. Registered Office: 2 Dashwood Lang Road, The Bourne > > Business > > > > Park, Addlestone, Weybridge, Surrey KT15 2NX Registered in England No. > > > > 868273 > > > > _______________________________________________ > > > > devs mailing list > > > > devs(a)xwiki.org <mailto:devs@xwiki.org> > > > > http://lists.xwiki.org/mailman/listinfo/devs <http://lists.xwiki.org/mailman/listinfo/devs> > > > > > > > > > _______________________________________________ > > devs mailing list > > devs(a)xwiki.org <mailto:devs@xwiki.org> > > http://lists.xwiki.org/mailman/listinfo/devs <http://lists.xwiki.org/mailman/listinfo/devs> > > > > Thales UK Ltd (Wells) DISCLAIMER: The information contained in this e-mail > > is confidential. It may also be legally privileged. It is intended only > for > > the stated addressee(s) and access to it by any other person is > > unauthorised. If you are not an addressee, you must not disclose, copy, > > circulate or in any other way use or rely on the information contained in > > this e-mail. Such unauthorised use may be unlawful. We may monitor all > > e-mail communications through our networks. If you have received this > e-mail > > in error, please inform us immediately on +44 (0) 1749 672081 and delete > it > > and all copies from your system. We accept no responsibility for changes > to > > any e-mail which occur after it has been sent. Attachments to this e-mail > > may contain software viruses which could damage your system. We therefore > > recommend you virus-check all attachments before opening. A business of > > Thales UK Ltd. Registered Office: 2 Dashwood Lang Road, The Bourne > Business > > Park, Addlestone, Weybridge, Surrey KT15 2NX Registered in England No. > > 868273 > > _______________________________________________ > > devs mailing list > > devs(a)xwiki.org <mailto:devs@xwiki.org> > > http://lists.xwiki.org/mailman/listinfo/devs <http://lists.xwiki.org/mailman/listinfo/devs> > > > _______________________________________________ > devs mailing list > devs(a)xwiki.org <mailto:devs@xwiki.org> > http://lists.xwiki.org/mailman/listinfo/devs <http://lists.xwiki.org/mailman/listinfo/devs> > > Thales UK Ltd (Wells) DISCLAIMER: The information contained in this e-mail > is confidential. It may also be legally privileged. It is intended only for > the stated addressee(s) and access to it by any other person is > unauthorised. If you are not an addressee, you must not disclose, copy, > circulate or in any other way use or rely on the information contained in > this e-mail. Such unauthorised use may be unlawful. We may monitor all > e-mail communications through our networks. If you have received this e-mail > in error, please inform us immediately on +44 (0) 1749 672081 and delete it > and all copies from your system. We accept no responsibility for changes to > any e-mail which occur after it has been sent. Attachments to this e-mail > may contain software viruses which could damage your system. We therefore > recommend you virus-check all attachments before opening. A business of > Thales UK Ltd. Registered Office: 2 Dashwood Lang Road, The Bourne Business > Park, Addlestone, Weybridge, Surrey KT15 2NX Registered in England No. > 868273 > _______________________________________________ > devs mailing list > devs(a)xwiki.org <mailto:devs@xwiki.org> > http://lists.xwiki.org/mailman/listinfo/devs <http://lists.xwiki.org/mailman/listinfo/devs> > _______________________________________________ devs mailing list devs(a)xwiki.org <mailto:devs@xwiki.org> http://lists.xwiki.org/mailman/listinfo/devs <http://lists.xwiki.org/mailman/listinfo/devs> Thales UK Ltd (Wells) DISCLAIMER: The information contained in this e-mail is confidential. It may also be legally privileged. It is intended only for the stated addressee(s) and access to it by any other person is unauthorised. If you are not an addressee, you must not disclose, copy, circulate or in any other way use or rely on the information contained in this e-mail. Such unauthorised use may be unlawful. We may monitor all e-mail communications through our networks. If you have received this e-mail in error, please inform us immediately on +44 (0) 1749 672081 and delete it and all copies from your system. We accept no responsibility for changes to any e-mail which occur after it has been sent. Attachments to this e-mail may contain software viruses which could damage your system. We therefore recommend you virus-check all attachments before opening. A business of Thales UK Ltd. Registered Office: 2 Dashwood Lang Road, The Bourne Business Park, Addlestone, Weybridge, Surrey KT15 2NX Registered in England No. 868273 _______________________________________________ devs mailing list devs(a)xwiki.org <mailto:devs@xwiki.org> http://lists.xwiki.org/mailman/listinfo/devs <http://lists.xwiki.org/mailman/listinfo/devs> -- http://wikibc.blogspot.com/ <http://wikibc.blogspot.com/> Thales UK Ltd (Wells) DISCLAIMER: The information contained in this e-mail is confidential. It may also be legally privileged. It is intended only for the stated addressee(s) and access to it by any other person is unauthorised. If you are not an addressee, you must not disclose, copy, circulate or in any other way use or rely on the information contained in this e-mail. Such unauthorised use may be unlawful. We may monitor all e-mail communications through our networks. If you have received this e-mail in error, please inform us immediately on +44 (0) 1749 672081 and delete it and all copies from your system. We accept no responsibility for changes to any e-mail which occur after it has been sent. Attachments to this e-mail may contain software viruses which could damage your system. We therefore recommend you virus-check all attachments before opening. A business of Thales UK Ltd. Registered Office: 2 Dashwood Lang Road, The Bourne Business Park, Addlestone, Weybridge, Surrey KT15 2NX Registered in England No. 868273

1 0

Re: [xwiki-devs] Ref: Displaying lists of wiki pages given a set of criteria
by goldring, richard 09 Oct '07

09 Oct '07

Thanks Jean-Vincent, What you've done helps ... but how does one list documents with a certain object attached whom's properties = a certain value? Regards, Richard -----Original Message----- From: devs-bounces(a)xwiki.org [mailto:devs-bounces@xwiki.org]On Behalf Of Jean-Vincent Drean Sent: 09 October 2007 12:34 To: XWiki Developers Subject: Re: [xwiki-devs] Ref: Displaying lists of wiki pages given a set of criteria I've started documenting hql queries through public and privileged APIs here: http://www.xwiki.org/xwiki/bin/view/DevGuide/velocityHqlExamples The privileged API will fit your need (don't forget to protect the edition of your scripts pages by non-admins). JV. 2007/10/9, goldring, richard <richard.goldring(a)uk.thalesgroup.com>: > Jean-Vincent, > > Thanks - I tried it and it worked. > > What I'd like to do now is to have a set of pages with objects attached and > to search those pages by the attributes on those objects. > > So for example the pages could represent 'tasks', the objects would store > details of those tasks e.g. task status, task owner, task description, task > date, etc. On a browser page a search/filter could then be done on say task > status to list all uncompleted tasks. > > Any idea how to do that? > > Also is there any documentation on how to do these searches using: > > $xwiki.xWiki.search("select count(doc) from XWikiDocument doc ${query}", > $context.context).get(0)) > > and > > #set ($list = $xwiki.searchDocuments($query, $resultsPerPage, $start)) > > i.e. what database tables to search - a description of how these methods > work and how to use them, etc > > If anyone has some more examples and explaination of these then it would > really help! Thanks! > > Regards, > > Richard > > -----Original Message----- > From: devs-bounces(a)xwiki.org [mailto:devs-bounces@xwiki.org]On Behalf Of > Jean-Vincent Drean > Sent: 03 October 2007 15:00 > To: XWiki Developers > Subject: Re: [xwiki-devs] Ref: Displaying lists of wiki pages given a > set of criteria > > > The snippet on xwiki.org : > http://www.xwiki.org/xwiki/bin/view/Code/PaginateSearch > > 2007/10/3, Jean-Vincent Drean <jv(a)xwiki.com>: > > Hi, > > > > It's a recurrent need but AFAIK we don't have any generic solution. > > I've made a 5' snippet, hope it will be useful. > > > > This snippet requires programming rights ($xwiki.xWiki.search) so > > you'll have to make sure that simple users can't edit this page. > > > > > -----------------------------------------------8<--------------------------- > ---------------------------------------- > > #macro(paginedSearch $query $currentPage $resultsPerPage) > > #set ($start = $resultsPerPage * $currentPage) > > #set ($resultsnb = $xwiki.xWiki.search("select count(doc) from > > XWikiDocument doc ${query}", $context.context).get(0)) > > #if ($resultsnb > $resultsPerPage) > > #set ($pagesnb = $resultsnb / $resultsPerPage) > > #foreach ($pagenb in [0..$pagesnb]) > > [$pagenb>$doc.fullName?page=$pagenb] > > #end > > #end > > #set ($list = $xwiki.searchDocuments($query, $resultsPerPage, $start)) > > #foreach ($item in $list) > > * $item > > #end > > #end > > > > #if ($request.page) > > #set ($desiredStart = $xwiki.parseInt($request.page)) > > #else > > #set ($desiredStart = 0) > > #end > > > > #paginedSearch("where 1=1" $desiredStart 5) > > > -----------------------------------------------8<--------------------------- > ---------------------------------------- > > > > 2007/10/3, goldring, richard <richard.goldring(a)uk.thalesgroup.com>: > > > Anyone? > > > > > > > > > Hi all, > > > > > > Does anyone know how to generate a list of links to wiki pages that meet > a > > > set of defined features i.e. filter and sort (features defined on the > > > objects or tags on those pages)? Perhaps like the Google search, list > the > > > first 20 or 30 pages and have a next/previous, 1, 2, 3, etc buttons to > list > > > the next selections of page links (to cope with the display of large > numbers > > > of page links). > > > > > > If anyones got any code snipits to get me started then that would be > really > > > useful - thanks. > > > > > > The idea is perhaps to explore how to use XWiki to semi automatically > > > generate pages to record tasks or issues, and then to list those pages > > > (tasks/issues) according to say the status or owners of those > tasks/issues. > > > For tasks I'm thinking XWiki might be used to help guide users through > > > business processes and semi-automatically document they have followed > those > > > processes (for CMMI) so they can be simply audited. Documents generated > > > through users following the tasks/processes can then be generated from > > > templates and stored within the wiki. If anyone else has any ideas/code > that > > > could help perhaps realise this then let me know! > > > > > > Regards, > > > > > > Richard Goldring > > > > > > TAO > > > Wookey Hole Road > > > Wells, Somerset > > > BA5 1AA > > > > > > Direct Line: 01749 682694 > > > Switchboard: 01749 672081 > > > richard.goldring(a)uk.thalesgroup.com > > > > > > > > > > > > > > > Thales UK Ltd (Wells) DISCLAIMER: The information contained in this > e-mail > > > is confidential. It may also be legally privileged. It is intended only > for > > > the stated addressee(s) and access to it by any other person is > > > unauthorised. If you are not an addressee, you must not disclose, copy, > > > circulate or in any other way use or rely on the information contained > in > > > this e-mail. Such unauthorised use may be unlawful. We may monitor all > > > e-mail communications through our networks. If you have received this > e-mail > > > in error, please inform us immediately on +44 (0) 1749 672081 and delete > it > > > and all copies from your system. We accept no responsibility for changes > to > > > any e-mail which occur after it has been sent. Attachments to this > e-mail > > > may contain software viruses which could damage your system. We > therefore > > > recommend you virus-check all attachments before opening. A business of > > > Thales UK Ltd. Registered Office: 2 Dashwood Lang Road, The Bourne > Business > > > Park, Addlestone, Weybridge, Surrey KT15 2NX Registered in England No. > > > 868273 > > > _______________________________________________ > > > devs mailing list > > > devs(a)xwiki.org > > > http://lists.xwiki.org/mailman/listinfo/devs > > > > > > _______________________________________________ > devs mailing list > devs(a)xwiki.org > http://lists.xwiki.org/mailman/listinfo/devs > > Thales UK Ltd (Wells) DISCLAIMER: The information contained in this e-mail > is confidential. It may also be legally privileged. It is intended only for > the stated addressee(s) and access to it by any other person is > unauthorised. If you are not an addressee, you must not disclose, copy, > circulate or in any other way use or rely on the information contained in > this e-mail. Such unauthorised use may be unlawful. We may monitor all > e-mail communications through our networks. If you have received this e-mail > in error, please inform us immediately on +44 (0) 1749 672081 and delete it > and all copies from your system. We accept no responsibility for changes to > any e-mail which occur after it has been sent. Attachments to this e-mail > may contain software viruses which could damage your system. We therefore > recommend you virus-check all attachments before opening. A business of > Thales UK Ltd. Registered Office: 2 Dashwood Lang Road, The Bourne Business > Park, Addlestone, Weybridge, Surrey KT15 2NX Registered in England No. > 868273 > _______________________________________________ > devs mailing list > devs(a)xwiki.org > http://lists.xwiki.org/mailman/listinfo/devs > _______________________________________________ devs mailing list devs(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/devs Thales UK Ltd (Wells) DISCLAIMER: The information contained in this e-mail is confidential. It may also be legally privileged. It is intended only for the stated addressee(s) and access to it by any other person is unauthorised. If you are not an addressee, you must not disclose, copy, circulate or in any other way use or rely on the information contained in this e-mail. Such unauthorised use may be unlawful. We may monitor all e-mail communications through our networks. If you have received this e-mail in error, please inform us immediately on +44 (0) 1749 672081 and delete it and all copies from your system. We accept no responsibility for changes to any e-mail which occur after it has been sent. Attachments to this e-mail may contain software viruses which could damage your system. We therefore recommend you virus-check all attachments before opening. A business of Thales UK Ltd. Registered Office: 2 Dashwood Lang Road, The Bourne Business Park, Addlestone, Weybridge, Surrey KT15 2NX Registered in England No. 868273

2 1

Re: [xwiki-devs] Ref: Displaying lists of wiki pages given a set of criteria
by goldring, richard 09 Oct '07

09 Oct '07

Jean-Vincent, Thanks - I tried it and it worked. What I'd like to do now is to have a set of pages with objects attached and to search those pages by the attributes on those objects. So for example the pages could represent 'tasks', the objects would store details of those tasks e.g. task status, task owner, task description, task date, etc. On a browser page a search/filter could then be done on say task status to list all uncompleted tasks. Any idea how to do that? Also is there any documentation on how to do these searches using: $xwiki.xWiki.search("select count(doc) from XWikiDocument doc ${query}", $context.context).get(0)) and #set ($list = $xwiki.searchDocuments($query, $resultsPerPage, $start)) i.e. what database tables to search - a description of how these methods work and how to use them, etc If anyone has some more examples and explaination of these then it would really help! Thanks! Regards, Richard -----Original Message----- From: devs-bounces(a)xwiki.org [mailto:devs-bounces@xwiki.org]On Behalf Of Jean-Vincent Drean Sent: 03 October 2007 15:00 To: XWiki Developers Subject: Re: [xwiki-devs] Ref: Displaying lists of wiki pages given a set of criteria The snippet on xwiki.org : http://www.xwiki.org/xwiki/bin/view/Code/PaginateSearch 2007/10/3, Jean-Vincent Drean <jv(a)xwiki.com>: > Hi, > > It's a recurrent need but AFAIK we don't have any generic solution. > I've made a 5' snippet, hope it will be useful. > > This snippet requires programming rights ($xwiki.xWiki.search) so > you'll have to make sure that simple users can't edit this page. > > -----------------------------------------------8<--------------------------- ---------------------------------------- > #macro(paginedSearch $query $currentPage $resultsPerPage) > #set ($start = $resultsPerPage * $currentPage) > #set ($resultsnb = $xwiki.xWiki.search("select count(doc) from > XWikiDocument doc ${query}", $context.context).get(0)) > #if ($resultsnb > $resultsPerPage) > #set ($pagesnb = $resultsnb / $resultsPerPage) > #foreach ($pagenb in [0..$pagesnb]) > [$pagenb>$doc.fullName?page=$pagenb] > #end > #end > #set ($list = $xwiki.searchDocuments($query, $resultsPerPage, $start)) > #foreach ($item in $list) > * $item > #end > #end > > #if ($request.page) > #set ($desiredStart = $xwiki.parseInt($request.page)) > #else > #set ($desiredStart = 0) > #end > > #paginedSearch("where 1=1" $desiredStart 5) > -----------------------------------------------8<--------------------------- ---------------------------------------- > > 2007/10/3, goldring, richard <richard.goldring(a)uk.thalesgroup.com>: > > Anyone? > > > > > > Hi all, > > > > Does anyone know how to generate a list of links to wiki pages that meet a > > set of defined features i.e. filter and sort (features defined on the > > objects or tags on those pages)? Perhaps like the Google search, list the > > first 20 or 30 pages and have a next/previous, 1, 2, 3, etc buttons to list > > the next selections of page links (to cope with the display of large numbers > > of page links). > > > > If anyones got any code snipits to get me started then that would be really > > useful - thanks. > > > > The idea is perhaps to explore how to use XWiki to semi automatically > > generate pages to record tasks or issues, and then to list those pages > > (tasks/issues) according to say the status or owners of those tasks/issues. > > For tasks I'm thinking XWiki might be used to help guide users through > > business processes and semi-automatically document they have followed those > > processes (for CMMI) so they can be simply audited. Documents generated > > through users following the tasks/processes can then be generated from > > templates and stored within the wiki. If anyone else has any ideas/code that > > could help perhaps realise this then let me know! > > > > Regards, > > > > Richard Goldring > > > > TAO > > Wookey Hole Road > > Wells, Somerset > > BA5 1AA > > > > Direct Line: 01749 682694 > > Switchboard: 01749 672081 > > richard.goldring(a)uk.thalesgroup.com > > > > > > > > > > Thales UK Ltd (Wells) DISCLAIMER: The information contained in this e-mail > > is confidential. It may also be legally privileged. It is intended only for > > the stated addressee(s) and access to it by any other person is > > unauthorised. If you are not an addressee, you must not disclose, copy, > > circulate or in any other way use or rely on the information contained in > > this e-mail. Such unauthorised use may be unlawful. We may monitor all > > e-mail communications through our networks. If you have received this e-mail > > in error, please inform us immediately on +44 (0) 1749 672081 and delete it > > and all copies from your system. We accept no responsibility for changes to > > any e-mail which occur after it has been sent. Attachments to this e-mail > > may contain software viruses which could damage your system. We therefore > > recommend you virus-check all attachments before opening. A business of > > Thales UK Ltd. Registered Office: 2 Dashwood Lang Road, The Bourne Business > > Park, Addlestone, Weybridge, Surrey KT15 2NX Registered in England No. > > 868273 > > _______________________________________________ > > devs mailing list > > devs(a)xwiki.org > > http://lists.xwiki.org/mailman/listinfo/devs > > > _______________________________________________ devs mailing list devs(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/devs Thales UK Ltd (Wells) DISCLAIMER: The information contained in this e-mail is confidential. It may also be legally privileged. It is intended only for the stated addressee(s) and access to it by any other person is unauthorised. If you are not an addressee, you must not disclose, copy, circulate or in any other way use or rely on the information contained in this e-mail. Such unauthorised use may be unlawful. We may monitor all e-mail communications through our networks. If you have received this e-mail in error, please inform us immediately on +44 (0) 1749 672081 and delete it and all copies from your system. We accept no responsibility for changes to any e-mail which occur after it has been sent. Attachments to this e-mail may contain software viruses which could damage your system. We therefore recommend you virus-check all attachments before opening. A business of Thales UK Ltd. Registered Office: 2 Dashwood Lang Road, The Bourne Business Park, Addlestone, Weybridge, Surrey KT15 2NX Registered in England No. 868273

2 1

[xwiki-devs] org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction
by sharans 08 Oct '07

08 Oct '07

As an administrator, when i tried to modify the access right of a particular user and then when i click on save, it gives me an exception saying org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction(or unsaved-value mapping was incorrect). What does this mean and how do i get rid of this problem..... -- View this message in context: http://www.nabble.com/org.hibernate.StaleObjectStateException%3A-Row-was-up… Sent from the XWiki- Dev mailing list archive at Nabble.com.

1 0

[xwiki-devs] Ref: fly out menus on XWiki
by goldring, richard 08 Oct '07

08 Oct '07

Also See http://www.codeproject.com/html/purecssmenus.asp?df=100&forumid=30098&exp=0& select=1097203 for flyout CSS menus! -----Original Message----- From: devs-bounces(a)xwiki.org [mailto:devs-bounces@xwiki.org]On Behalf Of goldring, richard Sent: 08 October 2007 08:46 To: 'XWiki Developers'; XWiki Users Subject: Ref: fly out menus on XWiki Hi All, Is it possible to implement flyout left/right hand column menus - so the menus only appear when you hover the cursor to the left or right of the wiki page? This would free up more viewing space on the wiki page. I found http://www.washington.edu/webinfo/case/flyout/ that talks about jscript implementation - but how could I integrate this with the menu panels to implement it within XWiki? I don't know much about jscript or CSS but maybe the web link here could help someone in the know to put this feature into XWiki or maybe point me in the right direction? Regards, Richard Thales UK Ltd (Wells) DISCLAIMER: The information contained in this e-mail is confidential. It may also be legally privileged. It is intended only for the stated addressee(s) and access to it by any other person is unauthorised. If you are not an addressee, you must not disclose, copy, circulate or in any other way use or rely on the information contained in this e-mail. Such unauthorised use may be unlawful. We may monitor all e-mail communications through our networks. If you have received this e-mail in error, please inform us immediately on +44 (0) 1749 672081 and delete it and all copies from your system. We accept no responsibility for changes to any e-mail which occur after it has been sent. Attachments to this e-mail may contain software viruses which could damage your system. We therefore recommend you virus-check all attachments before opening. A business of Thales UK Ltd. Registered Office: 2 Dashwood Lang Road, The Bourne Business Park, Addlestone, Weybridge, Surrey KT15 2NX Registered in England No. 868273 _______________________________________________ devs mailing list devs(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/devs Thales UK Ltd (Wells) DISCLAIMER: The information contained in this e-mail is confidential. It may also be legally privileged. It is intended only for the stated addressee(s) and access to it by any other person is unauthorised. If you are not an addressee, you must not disclose, copy, circulate or in any other way use or rely on the information contained in this e-mail. Such unauthorised use may be unlawful. We may monitor all e-mail communications through our networks. If you have received this e-mail in error, please inform us immediately on +44 (0) 1749 672081 and delete it and all copies from your system. We accept no responsibility for changes to any e-mail which occur after it has been sent. Attachments to this e-mail may contain software viruses which could damage your system. We therefore recommend you virus-check all attachments before opening. A business of Thales UK Ltd. Registered Office: 2 Dashwood Lang Road, The Bourne Business Park, Addlestone, Weybridge, Surrey KT15 2NX Registered in England No. 868273

1 0

Re: [xwiki-devs] [VOTE] Commit rights to Fabio on XEclipse
by goldring, richard 08 Oct '07

08 Oct '07

Hi All, Is it possible to implement flyout left/right hand column menus - so the menus only appear when you hover the cursor to the left or right of the wiki page? This would free up more viewing space on the wiki page. I found http://www.washington.edu/webinfo/case/flyout/ that talks about jscript implementation - but how could I integrate this with the menu panels to implement it within XWiki? I don't know much about jscript or CSS but maybe the web link here could help someone in the know to put this feature into XWiki or maybe point me in the right direction? Regards, Richard Thales UK Ltd (Wells) DISCLAIMER: The information contained in this e-mail is confidential. It may also be legally privileged. It is intended only for the stated addressee(s) and access to it by any other person is unauthorised. If you are not an addressee, you must not disclose, copy, circulate or in any other way use or rely on the information contained in this e-mail. Such unauthorised use may be unlawful. We may monitor all e-mail communications through our networks. If you have received this e-mail in error, please inform us immediately on +44 (0) 1749 672081 and delete it and all copies from your system. We accept no responsibility for changes to any e-mail which occur after it has been sent. Attachments to this e-mail may contain software viruses which could damage your system. We therefore recommend you virus-check all attachments before opening. A business of Thales UK Ltd. Registered Office: 2 Dashwood Lang Road, The Bourne Business Park, Addlestone, Weybridge, Surrey KT15 2NX Registered in England No. 868273

1 0

Re: [xwiki-devs] [xwiki-notifications] r5310 - xwiki-platform/core/trunk/xwiki-core/src/main/java/com/xpn/xwiki/store
by Vincent Massol 06 Oct '07

06 Oct '07

Hi Sergiu, Could we standardize on a single way for adding logs. For example I've consistently done it the following way: log.error(".... [" + sql + "]"); the reason for this: 1) quotes are common in strings 2) quotes need to be escaped in java and it's not convenient to write But basically it's just us deciding to standardize on a syntax. WDT? Thanks -Vincent On Oct 6, 2007, at 10:43 AM, sdumitriu (SVN) wrote: > Author: sdumitriu > Date: 2007-10-06 10:43:56 +0200 (Sat, 06 Oct 2007) > New Revision: 5310 > > Modified: > xwiki-platform/core/trunk/xwiki-core/src/main/java/com/xpn/xwiki/ > store/XWikiHibernateBaseStore.java > Log: > Replaced 2-line log with a 1-line one. > > > > Modified: xwiki-platform/core/trunk/xwiki-core/src/main/java/com/ > xpn/xwiki/store/XWikiHibernateBaseStore.java > =================================================================== > --- xwiki-platform/core/trunk/xwiki-core/src/main/java/com/xpn/ > xwiki/store/XWikiHibernateBaseStore.java 2007-10-05 21:03:11 UTC > (rev 5309) > +++ xwiki-platform/core/trunk/xwiki-core/src/main/java/com/xpn/ > xwiki/store/XWikiHibernateBaseStore.java 2007-10-06 08:43:56 UTC > (rev 5310) > @@ -360,8 +360,7 @@ > } > catch (Exception e) { > if ( log.isErrorEnabled() ) { > - log.error("While executing query: " + sql); > - log.error("Failed updating schema: " + e.getMessage > ()); > + log.error("Failed updating schema while executing > query \"" + sql + "\":" + e.getMessage()); > } > } > finally { > > _______________________________________________ > notifications mailing list > notifications(a)xwiki.org > http://lists.xwiki.org/mailman/listinfo/notifications

1 0

[xwiki-devs] Dashboards and panels
by Thomas Mortagne 06 Oct '07

06 Oct '07

Hi all, To add dashboards to XEM I made a general "widget" macro that is just a box containing informations. Speaking with Vincent, he said to me that generalize panels to be able to use theses in pages would be better. I'm always agree when there is "generalize" in a sentence :) Yet the problem is that panels did not print very well in pages and make things pretty with css and all that is not my main strength. So I'm wondering what is needed to improve panels for that. I'm sure every one have ideas for that so do not hesitate to suggest :) -- Thomas Mortagne

1 0

Re: [xwiki-devs] [xwiki-notifications] Build XWiki Platform Applications::Trunk #235 failed
by Vincent Massol 06 Oct '07

06 Oct '07

All these TC errors are not real errors. It's simply that We don't have any more disk space on the TC machine... -Vincent On Oct 6, 2007, at 12:32 PM, teamcity(a)xwiki.org wrote: > Build XWiki Platform Applications::Trunk #235 failed > Agent: Default agent > Build results: http://teamcity.xwiki.org/viewLog.html? > buildId=4131&buildTypeId=bt5 > > Changes included (1 change) > ==================================================== > Change 5315 by tmortagne (1 file): > Correct documents order in mixd wikis mode > > see more information about changed files: http://teamcity.xwiki.org/ > viewLog.html?tab=buildChangesDiv&buildId=4131&buildTypeId=bt5 > > > ===

1 0

[xwiki-devs] Meetup in Silicon Valley in October
by Vincent Massol 06 Oct '07

06 Oct '07

Hi XWiki friends, Ludovic and I will be attending the Google Summer of Code mentor summit at Google's MountainView headquarters in October so we thought it would a nice opportunity to meet up with XWiki users/developers and anyone interested in general. The dates are between the 7th of October and the 11th. Would some of you be interested in meeting up? Would you know where we could set this up? Does any of you have some spare room that you could lend for this event? Thanks a lot -Vincent

2 3