... 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 <http://www.spacetoon.com/> <x-msg://756/> ________________________________ ---------------------------------------------------------------- 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 <http://www.spacetoon.com/> <x-msg://756/> ________________________________ ---------------------------------------------------------------- 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]> ----------------------------------------------------------------
