On Mon, Nov 2, 2015 at 1:00 PM, Pascal BASTIEN <[email protected]> wrote:
Hello,
I have a xwiki doc class with some properties: 'Static List' type and 'Page' (multiselect) type. I try to write a query to retrieve document in one query shot but I encoutered problem with 'Page' type. This query working well based on http://platform.xwiki.org/xwiki/bin/view/DevGuide/velocityHqlExamples#HGetti...
select distinct doc.name, doc.creationDate from XWikiDocument as doc, BaseObject as obj, StringProperty prop where (doc.fullName=obj.name and obj.className='FormSMQ.ACClass' and doc.space='FormSMQ' and doc.hidden=false and prop.id.id=obj.id and prop.name='P1_Processus' and prop.value='M3') order by doc.creationDate desc
'P1_Processus' is a static list type
But this query doesn't work:
select distinct doc.name, doc.creationDate from XWikiDocument as doc, BaseObject as obj, StringProperty prop where (doc.fullName=obj.name and obj.className='FormSMQ.ACClass' and doc.space='FormSMQ' and doc.hidden=false and prop.id.id=obj.id and prop.name='MY_PAGE_TYPE_PROPERTY_NAME' and prop.value='MYVALUE') order by doc.creationDate desc
I suppose the 'P1_Processus' property has single selection, which means 'prop.value' is a string and thus you can write "prop.value='M3'". If the Page type property is multiple select then it's value is a list. You should check the "List all blog posts, published and not hidden (filter by multiple properties of an object)" example from http://extensions.xwiki.org/xwiki/bin/view/Extension/Query+Module#HQueryLang... . Look for : :category member of blog.category (in the XWQL version) DBStringListProperty as categoryProp join categoryProp.list list (in the HQL version) Hope this helps, Marius
Ididn't find some "PageProperty" in https://github.com/xwiki/xwiki-platform/blob/master/xwiki-platform-core/xwik..., then I must use DBStringListProperty ?
Any help will be welcome.
Pascal B _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users