Hi,
i'm not sure if it's what you want.
the code below search every page which contains a class
"XWiki.CandidatClass" except the page "XWiki.CandidatClassTemplate"
and have a property status=$status.
#macro (showCandidat $status)
#set ($sql = ", BaseObject as obj, StringProperty as prop where
obj.name=doc.fullName and obj.className='XWiki.CandidatClass' and
obj.name<>'XWiki.CandidatClassTemplate' and obj.id=prop.id.id and
prop.id.name='status' and prop.value='$status' order by prop.value
desc")
#foreach ($item in $xwiki.searchDocuments($sql))
#set($bentrydoc = $xwiki.getDocument($item))
#set($bentryobj = $bentrydoc.getObject("XWiki.CandidatClass"))
1.1.1 [$bentrydoc.display("name","view",
$bentryobj)>$bentrydoc.FullName]
#end
#end
Is it what you mean?
Jérémi
On 4/20/06, Esbach, Brandon <Esbachb(a)tycoelectronics.com> wrote:
Hi all,
I was wondering, is it possible to use a single query to get document
details and specified linked objects using one query (specific fields of
those objects would be even better)?
For example,
A document is created using a class template.
Inside the document are used two other classes, which are used multiple
times.
One of those classes is used for critical information that needs to be shown
in the document listing.
Currently what I do is to return a query based on the class for documents,
then loop through those results for document names. Inside each loop I'm
performing a second loop for the class with critical information (shown in
the listing). This eventually results in some fairly heavy traffic (as you
could imagine), which I'd like to resolve.
Not sure if this description is clear enough, but any suggestions or idea's
would be welcome!
Brandon Esbach
Software Engineer
M/A-Com Eurotec Operations
LoughMahon Technology Park,
Skehard Road,
Blackrock,
Cork, Ireland
Tel +353 21 4808305
--
You receive this message as a subscriber of the xwiki-users(a)objectweb.org
mailing list.
To unsubscribe:
mailto:xwiki-users-unsubscribe@objectweb.org
For general help: mailto:sympa@objectweb.org?subject=help
ObjectWeb mailing lists service home page:
http://www.objectweb.org/wws
--
Blog:
http://www.jeremi.info
LinkedIn:
https://www.linkedin.com/profile?viewProfile=&key=1437724
Project Manager XWiki:
http://www.xwiki.org
skype: jeremi23 -- msn et gtalk : jeremi23(a)gmail.com