topic Re: Search users with lucene in Alfresco Archive

Search users with lucene

chicco0386 — Wed, 23 Mar 2011 16:18:41 GMT

Hi all,I must to search the user by first and last name and after assign to him a workflow, so assign to bpm:assignee variable the node that return me the lucene search, this lifecycle is correct?I've this piece of code:function getUsername(firstName, lastName) { logger.log("getUsername, entrato")

Re: Search users with lucene

amitabhandari1 — Mon, 04 Apr 2011 06:15:02 GMT

Hi chicco0386 ,

Can you check the same query using NodeBrowser ?

Thanks,

Re: Search users with lucene

chicco0386 — Tue, 12 Apr 2011 12:37:04 GMT

I try to execute it inside the node browser in the alfrescoUserStore and SpaceStore, but it doesn't work…
Can you suggest me something? For example a new query?

THANK YOU

Re: Search users with lucene

chicco0386 — Mon, 18 Apr 2011 10:47:31 GMT

For the moment I use this lucene query:

+@cm\:firstName:firstNam* +@cm\:lastName:lastName*‍

It works, but for example if I must to search "Valentina Rossi", so use this query:

+@cm\:firstName:valentin* +@cm\:lastName:ross*‍

it can be return the user "Valentino Rosso" (or others combinations) and this is not perfect.

This is the updated javascript function:

function getUsername(firstName, lastName) {
   logger.log("getUsername, entrato");
   var userName = null;
   var firstNameToSearch = firstName.substring(0,firstName.length-1).concat("*").toLowerCase();
   var lastNameToSearch = lastName.substring(0,lastName.length-1).concat("*").toLowerCase();
   var luceneQuery = "+@cm\\:firstName:" + firstNameToSearch + " +@cm\\:lastName:" + lastNameToSearch;
   logger.log("getUsername, eseguo la query ["+luceneQuery+"]");
   var users = search.luceneSearch(luceneQuery);
   if (users.length > 0) {
      var userName = users[0].properties["cm:userName"];
      logger.log("getUsername, utente " + firstName + "," + lastName + " = " + userName);
   } else {
      logger.log("getUsername, nessun utente " + firstName + "," + lastName + " trovato");
   }
   logger.log("getUsername, uscito");
   return userName;
}‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍