With the following query :
#set ($sql = "select distinct max(prop.value) from LongProperty as prop where
prop.name='id'")
I get "2".
Thus I can get the last id. But how can I know that the "id" property belongs
to my Class 'CFPClass' ? If there were an other class with the id property,
perhaps I wouldn't have the same result ?
Can someone explain me how should I explain that I want "the last value of the
property id of my class CFPClass" ?
Thanks
--
Xavier MOGHRABI - Consortium ObjectWeb
Email: xavier.moghrabi at
objectweb.org
Phone: +33 4 76 61 52 35 - Skype ID: xavier.moghrabi.bureau
Le Mardi 18 Octobre 2005 18:55, Xavier MOGHRABI a écrit :
Hi,
I'd like to do a kind of SQL request with XWiki in order to get a data
store in an Object.
Here's my problem :
1 I've created a Class in XWiki in order to create a form for users. In
this class I've named one of a property ID that should allow me to distinct
objects.
2. I've created a template associated to this class that contain a single
Object of this class.
3. I've created a Form to allow users to fill the data. The problem I have
is that I have to give a unique name for the document created. Thus I
thought to use to ID property that I've created. So I wanted to do a SQL
Query to get the maximum id and by this way my new document name would be
Data.Doc"ID+1". The problem is that I don't know how to access the desired
property with XWiki. I've read the documentation about the data model :
http://www.xwiki.org/xwiki/bin/view/DevGuide/Database+Schema but I didn't
find the solution to my problem.
If I execute the following Query (my class is XWiki.CFPClass):
#set ($sql = "select distinct obj from XWikiDocument as doc, BaseObject as
obj where obj.name=doc.fullName and obj.className='XWiki.CFPClass' and
doc.name!='CFPClassTemplate'")
with this code :
#foreach ($item in $xwiki.search($sql))
$item <br />
#end
I get fine my objects :
CFP.Test 0 XWiki.CFPClass
CFP.Test1 0 XWiki.CFPClass
But I don't know how can I reach the property ? The property class seems to
be 'BaseProperty' but I don't know how can I add it with the query.
if I test a query like this :
select distinct prop.name from XWikiDocument as doc, BaseObject as obj,
BaseProperty as prop where obj.name=doc.fullName and
obj.className='XWiki.CFPClass' and doc.name!='CFPClassTemplate'
I get all the existing properties even the ones which aren't in the class
XWiki.CFPClass.
Any Idea ?