November 2015 - xwiki-users@xwiki.org

[xwiki-users] More complete ShortURLs: static resources in root path
by Paul Libbrecht 06 Nov '15

06 Nov '15

Hello list, As I reported, shortURLs worked well (and my issue about error 404 is resolve by upgrading to 7.3-m2). But I need to go a tick further in my ShortURLs attempt: I want some files to be statically served. Typical cases include: - /favicon.ico - /robots.txt - the google or other witnesses (e.g. StartSSL) It seems that the URLRewrite suggestion is really good for the flexible page rewrite but it does not have the flexibility of Apache mod_rewrite so that it serves files or tests if files are existing (at least not with the urlrewrite.xml syntax). I tried to map manually servlet-names to Jetty's defaultServlet but that has not been enough yet. Filters are probably byting (or that DefaultServlet is something else, unfortunately, "static file" is not a predefined servlet type of the servlet's standard). Is there another procedure? I know I can make it in mod_rewrite but I've been trying to focus on making it all in XWiki and I am surely not alone expecting that. thanks Paul

1 0

[xwiki-users] Revert all pages to v1.0
by Nolan Vines 05 Nov '15

05 Nov '15

I have a fresh install of 7.3M1 and I've finished entering all of our documents, articles, et cetera. Is there a way to "zero out" the version history to 1.0 so a page that I've edited 10+ times while creating it starts off on v1.0 instead of v10.0?

3 2

Re: [xwiki-users] Need help to find a hql query
by Pascal BASTIEN 04 Nov '15

04 Nov '15

Yes thxs (gdelhumeau helped me on irc). => I update doc: http://extensions.xwiki.org/xwiki/bin/view/Extension/Query+Module I used wrong value like you found too :-) -------------------------------------------- En date de : Mar 3.11.15, Marius Dumitru Florea <mariusdumitru.florea(a)xwiki.com> a écrit : Objet: Re: [xwiki-users] Need help to find a hql query À: "Pascal BASTIEN" <pbasnews-xwiki(a)yahoo.fr> Date: Mardi 3 novembre 2015, 11h01 On Mon, Nov 2, 2015 at 5:15 PM, Pascal BASTIEN <pbasnews-xwiki(a)yahoo.fr> wrote: I didn't manage to use blog example on xwiki 7.0.1 (I replace 'XWiki.ArticleClass' by 'Blog.BlogPostClass' : we must fix doc if it is ok) The query example don't work (or maybe I don't know how to use it ;-) ) select distinct doc.fullName, doc.creationDate from XWikiDocument as doc, BaseObject as obj, DBStringListProperty as prop join prop.list list where obj.name=doc.fullName and obj.className='Blog.BlogPostClass' and obj.id=prop.id.id and prop.id.name='category' and list='${category}' order by doc.creationDate desc This works fine for me: select distinct doc.fullName, doc.creationDate from XWikiDocument as doc, BaseObject as obj, DBStringListProperty as prop join prop.list list where obj.name=doc.fullName and obj.className='Blog.BlogPostClass' and obj.id=prop.id.id and prop.id.name='category' and list='Blog.News' order by doc.creationDate desc You probably don't have the right value in $category. Hope this helps, Marius If I remove category parameter #set ($query ="select distinct doc.fullName, doc.creationDate from XWikiDocument as doc, BaseObject as obj, DBStringListProperty as prop join prop.list list where obj.name=doc.fullName and obj.className='Blog.BlogPostClass' order by doc.creationDate desc") the query return all doc with blog class -------------------------------------------- En date de : Lun 2.11.15, Marius Dumitru Florea <mariusdumitru.florea(a)xwiki.com> a écrit : Objet: Re: [xwiki-users] Need help to find a hql query À: "Pascal BASTIEN" <pbasnews-xwiki(a)yahoo.fr>, "XWiki Users" <users(a)xwiki.org> Date: Lundi 2 novembre 2015, 13h47 On Mon, Nov 2, 2015 at 1:00 PM, Pascal BASTIEN <pbasnews-xwiki(a)yahoo.fr> 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#HGett… 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#HQueryLan… . 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/xwi…, then I must use DBStringListProperty ? Any help will be welcome. Pascal B _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users

2 3

[xwiki-users] Fw : Re: Need help to find a hql query
by Pascal BASTIEN 04 Nov '15

04 Nov '15

> I read this example: > http://xwiki.markmail.org/message/e2mi4odgpucsd3cu > #set ($hql ="select distinct doc.fullName, otherprop.value, > doc.creationDate from XWikiDocument as doc, BaseObject as > obj, StringProperty otherprop, DBStringListProperty as prop > join prop.list list > where obj.name=doc.fullName and > obj.className='Blog.BlogPostClass' and obj.id=prop.id.id and > prop.id.name='category' and list='Blog.Autres' > and obj.id=otherprop.id.id and otherprop.id.name='title' > order by doc.creationDate desc") > > (must try with category property now) > Nope: I didn't managed to have multiselect category values with hql query :-( maybe I must uncheck database relationnel storage (and use this filter "list like '%Blog.Autres%'")? because like sergio said in http://xwiki.markmail.org/message/c6s5wofs24q62qjd?q=query+Property+DBStrin… <<values from the list, while Relational Storage makes it easier to integrate that property into other queries by storing each selected item in its own entry in the database (without it all the selected values are stored in one row, concatenated into a VARCHAR column), and to store >>

1 0

[xwiki-users] CORS header
by Anton Hughes 03 Nov '15

03 Nov '15

Hello I am looking to use XWiki to manage and provide documentation for my web based application (built in GWT). The idea is to use the XWiki rest api that can return clean HTML, for example http://platform.xwiki.org/xwiki/bin/view/Features/XWikiRESTfulAPI?xpage=pla… . However, to be able to consume this in my gwt application, as I get the following error: XMLHttpRequest cannot load http://localhost:8080/xwiki/bin/view/MyExamplePage?xpage=plain&outputSyntax…. No 'Access-Control-Allow-Origin' header is present on the requested resource. Origin 'http://localhost:8081' is therefore not allowed access. How do I add the cors header to the rest response from Xwiki? Thanks -- Anton Hughes

1 1

[xwiki-users] Admin password after installing
by Anton Hughes 03 Nov '15

03 Nov '15

Hi I am trying out Xwiki and would like to know how to login after installing. Is there an admin user already created when installing? If yes, what is the password? If not, how do I create an admin user? Thanks -- Anton Hughes

2 2

[xwiki-users] Need help to find a hql query
by Pascal BASTIEN 02 Nov '15

02 Nov '15

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#HGett… 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 Ididn't find some "PageProperty" in https://github.com/xwiki/xwiki-platform/blob/master/xwiki-platform-core/xwi…, then I must use DBStringListProperty ? Any help will be welcome. Pascal B

2 2