Re: [xwiki-devs] Ref: Displaying lists of wiki pages given a set of criteria

9 Oct 2007

      Guillaume,

I'll make time and see what I can do.

Regards,

Richard

-----Original Message-----
From: devs-bounces@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@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@xwiki.org <mailto:devs-bounces@xwiki.org>  [mailto:
devs-bounces@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@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@xwiki.org  <mailto:devs-bounces@xwiki.org> [mailto:
devs-bounces@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@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@xwiki.org <mailto:devs-bounces@xwiki.org>  [mailto:
devs-bounces@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@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@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@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@xwiki.org <mailto:devs@xwiki.org> 
http://lists.xwiki.org/mailman/listinfo/devs
<http://lists.xwiki.org/mailman/listinfo/devs>
_______________________________________________
devs mailing list
devs@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@xwiki.org <mailto:devs@xwiki.org> 
http://lists.xwiki.org/mailman/listinfo/devs
<http://lists.xwiki.org/mailman/listinfo/devs>
_______________________________________________
devs mailing list
devs@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@xwiki.org <mailto:devs@xwiki.org> 
http://lists.xwiki.org/mailman/listinfo/devs
<http://lists.xwiki.org/mailman/listinfo/devs>
_______________________________________________
devs mailing list
devs@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@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

goldring, richard

tags

participants (1)