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]> ----------------------------------------------------------------
