jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sachinthechauhan <sachinthechau...@gmail.com>
Subject Re: SQL2 (via jcr)
Date Wed, 05 Jun 2013 11:17:09 GMT
 querryStr="Select * from [product] as prd " +
		 		"inner join [attribute] as attr on ISCHILDNODE(attr,prd)" +
		 		" inner join [attribute] as attr1 on ISCHILDNODE(attr1,prd) " +
		 		"inner join [attribute] as attr2 on ISCHILDNODE(attr2,prd)" +
			 		"  where" +
			 		" prd.catalogPrdName='motor' and attr.AttributeName='height' and
attr.AttributeValue>=23" +
			 		"and  attr1.AttributeName='color' and  attr1.AttributeValue='white'" +
			 		"and  attr2.AttributeName='weight' and  attr2.AttributeValue>=217.0"

run this querry thats give result



--
View this message in context: http://jackrabbit.510166.n4.nabble.com/SQL2-via-davex-tp3730048p4658821.html
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.

Mime
View raw message