Re: [eclipselink-users] JPQL : Not able to use IN clause on only the val

[bhakti b <bhaktikeni@xxxxxxxxx>]

Hi Tom

Yes, I have tried the value keyword, but it still selects both key and value
combination and SQL Exception is thrown for "Too many values"

This is JPQL that I have tried :
		<named-query name="fetchAllowedPurposeCodes">
                <query>
                select distinct 
                a.allowedPurposeCodes from com.test.CreditPolicyTemplate 
                c JOIN FETCH c.allowedPurposeCodes a where
c.creditPolicyTemplateKey.creditPolicyTemplateId IN 
                (	select 
                        value(lnk)
                        from 
                        com.test.ProductGroup p JOIN 
                        p.groupCreditPolicyLinkage lnk 
                        where 
                        p.productGroupKey.productGroupCode in 
                        (:productGroup) 
                        ) 

                </query>
        </named-query>
		
Regards
Bhakti



--
View this message in context: http://eclipse.1072660.n5.nabble.com/JPQL-Not-able-to-use-IN-clause-on-only-the-values-of-an-element-collection-map-tp156050p156340.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.