topic Re: script to seach in a specific space in Alfresco Archive

script to seach in a specific space

cperez — Wed, 02 Apr 2014 15:34:24 GMT

I'm makin a script to get all the objects in a specific space (called "Aprobados") where the created or last modified date is today. And I also want to get all metadata from the searchrd objects.Can anyone help me please?Let me explain you the process I need to execute1) Search for all the pdf docum

Re: script to seach in a specific space

cybermakoki — Thu, 03 Apr 2014 10:50:00 GMT

Hi cperez,

The best way to do this is to use lucene or xpath search, because it allows you to search recursively in the child nodes.

It should be something like this using lucene search:


  var docs = search.luceneSearch("PATH:'app:company_home/cm:Revisar/cm:Aprobados//.' AND  @cm\\:modified:[NOW TO MAX]");
‍‍‍

Here you have more information about range queries:

http://wiki.alfresco.com/wiki/Search#Range_Queries
http://forums.alfresco.com/forum/developer-discussions/web-scripts/lucene-search-date-range-created-modified-not-working
https://forums.alfresco.com/forum/developer-discussions/repository-services/attributes-lucene-date-range-10122007-1524

Re: script to seach in a specific space

cperez — Thu, 03 Apr 2014 11:27:54 GMT

Hi cybermakoki,

I got.
I changed the search and I use the luceneSearch like you said.
I use the dinamic path from a specific folder instead of a static path, the range date search to get all the documents today, and I also search only pdf documents.

This is the code that I use:


var sdate=today.getFullYear()+"\-"+(today.getMonth()+1)+"\-"+today.getDate() + "T00:00:00";
var tdate=today.getFullYear()+"\-"+(today.getMonth()+1)+"\-"+(today.getDate()+1) + "T00:00:00";
var spath="'+PATH:\""+aprobados.displayPath +"//*\" + ";
var scontent="@\\{http\\://www.alfresco.org/model/content/1.0\\}content.mimetype:application/pdf + ";
var qdate="@cm\\:modified:[" + sdate + " TO " + tdate +"]'";
var strq=spath+scontent+qdate;

// Do the search and save the vales
var nodes=search.luceneSearch(strq);
‍‍‍‍‍‍‍‍‍‍‍

thank you so much.

Re: script to seach in a specific space

cybermakoki — Thu, 03 Apr 2014 11:44:20 GMT

That's perfect!

I'm glad I helped you