Re: Searching Multiple Node Types

2008-04-18 Thread Marcel Reutegger
Hi Michael, as an alternative you can also restrict the type of a node with an expression on jcr:primaryType. select * from nt:base where jcr:primaryType = 'mynt:content' please note that the above query does not respect the node type hierarchy. that is, it is not equivalent to: select * f

Re: Searching Multiple Node Types

2008-04-15 Thread Julian Reschke
Michael MacFadden wrote: Thanks for the tip I will try it. As a side note, I wouldn't mind using an XPath either. Doesn't make much difference to me. Do you happen to know what this would look like in xpath? Thanks. ...

Re: Searching Multiple Node Types

2008-04-15 Thread Michael MacFadden
Thanks for the tip I will try it. As a side note, I wouldn't mind using an XPath either. Doesn't make much difference to me. Do you happen to know what this would look like in xpath? Thanks. Fabián Mandelbaum wrote: I don't use SQL queries at all (I prefer XPath) with JackRabbit, but did y

Re: Searching Multiple Node Types

2008-04-15 Thread Fabián Mandelbaum
I don't use SQL queries at all (I prefer XPath) with JackRabbit, but did you try something like the following: "SELECT * FROM mynt:content, mynt:attachments WHERE CONTAINS(* , '" + queryString.toLowerCase().trim() + "') order by jcr:score DESC" That is, select from both 'tables'. I don't know if

Searching Multiple Node Types

2008-04-15 Thread Michael MacFadden
Hi, I have a question regarding searching. In my repository, I have two different node types. One for regular typed in content and one for attachments. Each of these node types has a node type definition loaded and they each have different properties. What I want to do is allow the user t