Any good resources for learning sql/xpath usage in Magnolia?

[Nicolas Brasseur]

Any good documentation out there ?

thanks in advance

N.



     

----------------------------------------------------------------
For list details see
http://www.magnolia-cms.com/home/community/mailing-lists.html
To unsubscribe, E-mail to: <user-list-unsubscribe@...>
----------------------------------------------------------------

[Will Scheidegger]

Well, you can find quite a bit of info in the JCR specs. Then I find  
this very useful:
http://people.apache.org/~mreutegg/jcr-query-translator/translator.html
And this sometimes helps too for the basics:
http://www.zvon.org/xxl/XPathTutorial/General/examples.html

-will

On 18.06.2009, at 18:05, Nicolas Brasseur wrote:

>
>
> Any good documentation out there ?
>
> thanks in advance
>
> N.
>
>
>
>
>
> ----------------------------------------------------------------
> For list details see
> http://www.magnolia-cms.com/home/community/mailing-lists.html
> To unsubscribe, E-mail to: <user-list-unsubscribe@...>
> ----------------------------------------------------------------
>

----------------------------------------------------------------
For list details see
http://www.magnolia-cms.com/home/community/mailing-lists.html
To unsubscribe, E-mail to: <user-list-unsubscribe@...>
----------------------------------------------------------------

[Nicolas Brasseur]

Thank you for the links,

I've tried some xpath queries and I have a question. According to various sources the following

Query query = MgnlContext.getQueryManager("website").createQuery("//todos/*", "xpath");
...

should return all the children of 'todos' nodes. When I iterate the result using this:

qls = result.getContent("mgnl:contentNode");
 
I receive the following result:

website:/hello-world/paragraphs/0/todos[mgnl:contentNode]
website:/hello-world/paragraphs/0/todos/0[mgnl:contentNode]
website:/hello-world/paragraphs/00/todos[mgnl:contentNode]
website:/hello-world/paragraphs/00/todos/0[mgnl:contentNode]
website:/hello-world/paragraphs/00/todos/00[mgnl:contentNode]

If I execute the same query using the JCR query tool in admin central with 'Result ItemType' nt:base i receive the following.

/hello-world/paragraphs/0/todos/MetaData
/hello-world/paragraphs/0/todos/0
/hello-world/paragraphs/00/todos/MetaData
/hello-world/paragraphs/00/todos/0
/hello-world/paragraphs/00/todos/00

Can you tell me what the MetaData nodes are ? Where they come from, how to avoid having them returned in my query ?
Rem: I can't see these 'MetaData' nodes in the JCR Browser in admin central.

thanks in advance

Nicolas





----- Original Message ----
From: Will Scheidegger <willscheidegger@...>
To: Magnolia User-List <user-list@...>
Sent: Thursday, June 18, 2009 6:16:33 PM
Subject: Re: [magnolia-user]  Any good resources for learning sql/xpath usage in Magnolia?


Well, you can find quite a bit of info in the JCR specs. Then I find  
this very useful:
http://people.apache.org/~mreutegg/jcr-query-translator/translator.html
And this sometimes helps too for the basics:
http://www.zvon.org/xxl/XPathTutorial/General/examples.html

-will

On 18.06.2009, at 18:05, Nicolas Brasseur wrote:

>
>
> Any good documentation out there ?
>
> thanks in advance
>
> N.
>
>
>
>
>
> ----------------------------------------------------------------
> For list details see
> http://www.magnolia-cms.com/home/community/mailing-lists.html
> To unsubscribe, E-mail to: <user-list-unsubscribe@...>
> ----------------------------------------------------------------
>

----------------------------------------------------------------
For list details see
http://www.magnolia-cms.com/home/community/mailing-lists.html
To unsubscribe, E-mail to: <user-list-unsubscribe@...>
----------------------------------------------------------------


     

----------------------------------------------------------------
For list details see
http://www.magnolia-cms.com/home/community/mailing-lists.html
To unsubscribe, E-mail to: <user-list-unsubscribe@...>
----------------------------------------------------------------