hi,
I have specific scenario,

we know this query works fine,

SELECT x FROM Magazine x, IN(x.articles) y WHERE y.authorName = 'John Doe'

Now i want to add some additional condition to it, something like
x.name = 'ABC', and that should appear before IN clause, something like

SELECT x FROM Magazine x, where x.name = "ABC" AND x IN(x.articles) y WHERE y.authorName = 'John Doe'

tried many scenarios but unable to find correct syntax

please help

I don't know how to help you as I don't understand exactly what you tried to do and what you would like to have, sorry. But it really looks like that you need Hibernate Search.