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 <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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
> umentswhereobjects27propertiesequalssomevalue
>
> JV.
>
> 2007/10/9, goldring, richard <[EMAIL PROTECTED]>:
> > 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 <[EMAIL PROTECTED]>:
> > > 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 <[EMAIL PROTECTED]>:
> > > > 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 <[EMAIL PROTECTED]>:
> > > > > 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
> > > > > [EMAIL PROTECTED]
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > 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
> > > > > [email protected]
> > > > > http://lists.xwiki.org/mailman/listinfo/devs
> > > > >
> > > >
> > > _______________________________________________
> > > devs mailing list
> > > [email protected]
> > > 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
> > > [email protected]
> > > http://lists.xwiki.org/mailman/listinfo/devs
> > >
> > _______________________________________________
> > devs mailing list
> > [email protected]
> > 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
> > [email protected]
> > http://lists.xwiki.org/mailman/listinfo/devs
> >
> _______________________________________________
> devs mailing list
> [email protected]
> 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
> [email protected]
> http://lists.xwiki.org/mailman/listinfo/devs
>
--
http://wikibc.blogspot.com/
_______________________________________________
devs mailing list
[email protected]
http://lists.xwiki.org/mailman/listinfo/devs
