topic Re: Find users with Lucene query using QName in Alfresco Archive

Find users with Lucene query using QName

abarisone — Tue, 23 Aug 2011 13:49:19 GMT

Hi all,I'm trying to get the list of all users belonging to a certain group using a Lucene query.Placing it into Alfresco Node Browser as:TYPE:"cmerson" AND @cm\:userName:"*" AND QNAME:"sys:system/sys:authorities/cm:GROUP_USR_0000011046/*"‍I correctly obtain all the users for that group.But when t

Re: Find users with Lucene query using QName

andy — Wed, 24 Aug 2011 09:15:44 GMT

Hi

I am not sure why you have your issue:

But the clause

@cm\:userName:"*" has no point as the property is mandatory for the type.

and you are abusing QNAME.
It happens to be implemented as PATH:"//<QNAME>" - you would be better using PATH as you are not just using a qname - then you cna avoid the "//" at the start.

Andy

Re: Find users with Lucene query using QName

andy — Wed, 24 Aug 2011 09:17:06 GMT

Hi

Are you using the same query language?
What is the full exception?

Andy

Re: Find users with Lucene query using QName

abarisone — Wed, 24 Aug 2011 13:13:03 GMT

Hi,
the strange thing is that trying with both QName and Path it works on the node browser.
But it doesn't with alfresco debugger.
Moreover the message I provided is the only message I obtain from alfresco debugger.
What am I doing wrong?
Which is the correct way to write the lucene query?
Thanks.

Re: Find users with Lucene query using QName

scouil — Tue, 06 Sep 2011 15:10:07 GMT

Hi,

I'm sorry I have no idea what's wrong with the syntax so I may not be useful at all but…
Is there a good reason why you're not using:

people.getMembers(people.getGroup("GROUP_USR_0000011046"));‍

instead of a lucene query?

Re: Find users with Lucene query using QName

abarisone — Wed, 07 Sep 2011 14:47:37 GMT

Thank you for your reply.
The main reason I would like to use a Lucene query is to have a "one-shot" response.
Moreover this approach would be more flexible, especially when comes out the need of changing the query criteria.
I can't yet figure out why the search works well with the Alfresco node browser but not in debugger/code….