that's correct for xpath but not for jcr sql query language which was used in the example.
Cheers, Federico On Mar 29, 2012, at 12:26 PM, Patric Dosch wrote: > … order by @title descending > > > I found this site very helpful as a comparison of xpath and sql is available. > http://docs.jboss.org/modeshape/latest/manuals/reference/html/jcr-query-and-search.html#jcr-xpath-ordering-specifiers > > Regards, Patric > > > Von: [email protected] > [mailto:[email protected]] Im Auftrag von Federico Grilli > Gesendet: Donnerstag, 29. März 2012 12:03 > An: Magnolia User-List > Betreff: Re: [magnolia-user] query qustion > > As an example, you might do something along these lines > > select * from mgnl:content where sectionText like '%myQueryText%' or title > like '%myQueryText%' order by title desc > > where sectionText and title would be the names of the nodes containing > relevant textual info you want to be searchable. > > > > On Mar 29, 2012, at 11:47 AM, obada jabban wrote: > > > Thank u very Much > I'm grateful to u > these queries give me very good assistance > but what about getting specified fields in content and ordering them in > special order > > > On Thu, Mar 29, 2012 at 11:46 AM, Federico Grilli > <[email protected]> wrote: > Hi, > > you might find this interesting > http://wiki.magnolia-cms.com/display/WIKI/JCR+Query+Cheat+Sheet. Also OM's > Criteria module could be of interest for you > http://www.openmindlab.com/lab/products/mgnlcriteria.html > > HTH, > > Federico > > > On Mar 29, 2012, at 10:38 AM, obada jabban wrote: > > Hello For All > Can anyone give me some hints about writing query ( with "from" and "where" > statement ) in magnolia to get specified kind of paragraphs from one page > or multi pages? > any blog or small tutorial will be appreciated > Thank u alote :) > > -- > Mohammad Obada Al Jabban > Senior Web Developer > Spacetoon Online > Damascus - Free zone > > spacetoon building > > Tel :0963-11-2126025 > > mob:0963-988-756003 > > email:[email protected] > > [email protected] > > http://www.spacetoon.com > > > > > > ---------------------------------------------------------------- > For list details, see http://www.magnolia-cms.com/community/mailing-lists.html > Alternatively, use our forums: http://forum.magnolia-cms.com/ > To unsubscribe, E-mail to: <[email protected]> > ---------------------------------------------------------------- > > > > ---------------------------------------------------------------- > For list details, see http://www.magnolia-cms.com/community/mailing-lists.html > Alternatively, use our forums: http://forum.magnolia-cms.com/ > To unsubscribe, E-mail to: <[email protected]> > ---------------------------------------------------------------- > > > > -- > Mohammad Obada Al Jabban > Senior Web Developer > Spacetoon Online > Damascus - Free zone > > spacetoon building > > Tel :0963-11-2126025 > > mob:0963-988-756003 > > email:[email protected] > > [email protected] > > http://www.spacetoon.com > > > > > > ---------------------------------------------------------------- > For list details, see http://www.magnolia-cms.com/community/mailing-lists.html > Alternatively, use our forums: http://forum.magnolia-cms.com/ > To unsubscribe, E-mail to: <[email protected]> > ---------------------------------------------------------------- > > > > ---------------------------------------------------------------- > For list details, see http://www.magnolia-cms.com/community/mailing-lists.html > Alternatively, use our forums: http://forum.magnolia-cms.com/ > To unsubscribe, E-mail to: <[email protected]> > ---------------------------------------------------------------- > > > ---------------------------------------------------------------- > For list details, see http://www.magnolia-cms.com/community/mailing-lists.html > Alternatively, use our forums: http://forum.magnolia-cms.com/ > To unsubscribe, E-mail to: <[email protected]> > ---------------------------------------------------------------- ---------------------------------------------------------------- For list details, see http://www.magnolia-cms.com/community/mailing-lists.html Alternatively, use our forums: http://forum.magnolia-cms.com/ To unsubscribe, E-mail to: <[email protected]> ----------------------------------------------------------------
