Hi,

I am using a query like :

select doc, docQuery, queryType.queryTypeDesc, user from Document doc, DocumentQuery docQuery, QueryType queryType, Iusers user where doc.documentID = docQuery.documentID AND queryType.queryTypeID = docQuery.queryTypeID AND user.userId IN (doc.indexer, docQuery.jiraIssueBy, docQuery.updatedBy, docQuery.validatedBy) AND docQuery.documentQueryID = :variable0

using the createQuery method .

now for the user part in the result, the query is fetching only the first user from the list of userids matching in the IN clause.

s it not possible to get list of user objects using the above query, alongwith document object, documentquery object and query description in the result.