topic Re: Searching a file in repository in Alfresco Archive

Searching a file in repository

itsard — Thu, 23 Jul 2009 10:58:29 GMT

Hi,Can u help me with this…I need to search a document in Alfresco repository.I pass the file name and need to get the reference to it.Below is the code am using.Query query1 =new Query(Constants.QUERY_LANG_LUCENE,"PATH:\"/app:company_home/cm:sample_folder/cm:"+ISO9075.encode(lStringFileName)+"\"");

Re: Searching a file in repository

openpj — Thu, 23 Jul 2009 17:22:18 GMT

In this way you are searching for a space or all the contents in a space, maybe you would like to execute this query:

Query query1 =new Query(Constants.QUERY_LANG_LUCENE,"PATH:\"/app:company_home/cm:sample_folder/*" AND @cm\\:name:"+ISO9075.encode(lStringFileName)+"\"");‍

Hope this helps.

Re: Searching a file in repository

itsard — Fri, 24 Jul 2009 09:55:29 GMT

Hi,
Thanks for your reply.
I tried your query, it gave me a compilation error.
Tried to get it working on node browser as below but dint find any record :

PATH:"/app:company_home/cm:sample_folder/*" AND @cm:\\name:hello.txt"‍

There is a hello.txt file in the webservice sample folder i.e. sample_folder and I am trying to search it to get the reference.
Can you kindly run your query in the node browser and chk if its working.
Kindly do let me know.
Thanks again.

Re: Searching a file in repository

luisg — Tue, 28 Jul 2009 13:20:02 GMT

try:

PATH:"/app:company_home/cm:sample_folder/*" AND @cm\:name:"hello.txt"

Re: Searching a file in repository

itsard — Fri, 07 Aug 2009 13:36:01 GMT

Hi,
How can i search a text in only some documents through webservice api.
My requirement is a content search that searches the input text only in some UUIDs or reference objects that I pass as input to the query.
Can someone help me with the query for it.

Re: Searching a file in repository

luisg — Fri, 07 Aug 2009 15:10:47 GMT

Ok…
You want to find a string inside a document identified by its reference? It's that what you want?
if so, suppose you want to find the string 'test' in a document with the reference 'ReferenceX' you should do:

ID:"ReferenceX" AND TEXT:"test"

Tried that in Alfresco Node Browser ans works!

Hope it helps

Luis

Re: Searching a file in repository

itsard — Sun, 09 Aug 2009 13:25:50 GMT

Thanks a lot for ur reply.
I will try this out. Instead of a single ID, I need to check it in more than one references.Whats the query for that?

I also had another question.
I am using the SOAP webservice api.
Can you kindly let me know is there a way to get the Version2Store node-uuid of my document when i check in the file.
My requirement is I need to save the version2Store node-uuid of the document when I check it in so that next time I can directly access it using the reference object from version2Store.

Re: Searching a file in repository

itsard — Tue, 11 Aug 2009 11:57:19 GMT

Hi,
I need to perform content search on documents inside a folder whose node-uuid I have.
I need to perform a hierarchical search, means searching the documents also inside all the children folders of the one whose node uuid i provide.


PARENT:"workspace://SpacesStore/cbb81351-4e7b-49cd-85c3-9dd423fdad2c"  TEXT:"bbb"
‍‍‍

This code finds the documents but only in that particular folder and not in the children.
Can anyone help me out with this?
Thanks.

Re: Searching a file in repository

luisg — Tue, 11 Aug 2009 15:46:51 GMT

Hey…

You have the uuid of the folder you want, but for this you just need the path for the folder.
Suppose you have a folder 'test' inside Company Home and you need to search for all the documents that contain the String 'message'… to do this you need to perform the query:


PATH:"/app:company_home/cm:test//*" AND TEXT:"message"
‍‍‍

I tried this with the following folder structure (all files have 'message' in its content):


Companhy Home
   file1
   file2
   file3
   subfolder1
      file4
      subfolder2
         file5
‍‍‍‍‍‍‍‍‍‍

Hope it helps

Luis

Re: Searching a file in repository

itsard — Wed, 12 Aug 2009 06:14:07 GMT

Thanks for the reply.
But I dont wish to make the path…as I am integrating alfresco with my system…and the same logical folder would be created in my system also.
I map the alfresco folder uuid in my system against the system folder id.
What I wish is I just provide the folder uuid in the query and it does the content search for all the docs in the below hierarchy.
Is there a way to do this?
Thanks again for ur reply.

Re: Searching a file in repository

cheffilet — Wed, 12 Aug 2009 06:17:04 GMT

What I wish is I just provide the folder uuid in the query and it does the content search for all the docs in the below hierarchy.

I think you´re looking for something like this:


query.setStatement("PARENT: \"" this.store.getScheme()+ "://"+ store.getAddress() + "/"+ uuid+ "\" AND "
 "TYPE:\\{http\\://www.alfresco.org/model/content/1.0\\}content "); 
‍‍‍‍

Re: Searching a file in repository

itsard — Wed, 12 Aug 2009 07:07:01 GMT

Hi,
I am trying this query but its not fetching me any record.
Can u give me the node browser query whose input is a uuid of a folder in spacesstore and a text to be searched.

I tried something like :
PARENT: "workspace://SpacesStore/cbb81351-4e7b-49cd-85c3-9dd423fdad2c" AND "TYPE:\{http\://www.alfresco.org/model/content/1.0\}content" TEXT:"bb"
I do have files with the content bb in the folders in the hierarchy below.
Thanks for your reply.

Re: Searching a file in repository

cheffilet — Wed, 12 Aug 2009 07:16:34 GMT

Can u give me the node browser query whose input is a uuid of a folder in spacesstore and a text to be searched.

PARENT: "workspace://SpacesStore/ec002e32-f392-4ea1-967e-7e6009d74c7f" AND TYPE:"{http://www.alfresco.org/model/content/1.0}content" AND TEXT:"bb"‍

Re: Searching a file in repository

itsard — Wed, 12 Aug 2009 09:11:01 GMT

Hi,


PARENT: "workspace://SpacesStore/2fc87f4b-a13f-4c3c-ad26-bbaced8c4819"  AND TEXT:"content*" AND TYPE:"{http://www.alfresco.org/model/content/1.0}content"
‍‍‍

This query does find the text in the folder specified by uuid. But it does not search in the hierarchy of folders under it.It just searches in one level.
"workspace://SpacesStore/2fc87f4b-a13f-4c3c-ad26-bbaced8c4819/*" and "workspace://SpacesStore/2fc87f4b-a13f-4c3c-ad26-bbaced8c4819//*"
also dont work.
Can you help me with that query?
Thanks.

Re: Searching a file in repository

cheffilet — Wed, 12 Aug 2009 09:22:54 GMT

I dont know wheter this is possible at all. Because you need an recursivly method for that to relolve all children that belongs to "one root node-uuid".

Re: Searching a file in repository

itsard — Wed, 12 Aug 2009 09:44:17 GMT

So can you kindly suggest me any other way to achieve the above requirement except using


PATH:"/app:company_home/cm:sample_folder/cm:Sample_Testing//*" AND TEXT:select*
‍‍‍

Because for this query I would need to get all the folders in the hierarchy to create the path first and that would become clumsy.
Isnt there any other way?
Thanks again.

Re: Searching a file in repository

cheffilet — Wed, 12 Aug 2009 10:12:01 GMT

Its a realy bad idea to build up a whole tree with one request. Instead of this, you should take use a more asynchronous-approach on retrieving partialy folders/documents.

But, if you need to get all folders under a specific path, use following path:


PATH:"//app:company_home//*" AND +TYPE:"{http://www.alfresco.org/model/content/1.0}folder"
‍‍‍

Re: Searching a file in repository

itsard — Wed, 02 Sep 2009 05:01:07 GMT

Hi,
Is there a way to find out a text inside the documents whose list i provide to the query.
For eg. if I have to search in 10 documents that are in different folder hierarchies and not under the same parent, how would I achieve it ?
Something like I pass the collection of those 10 documents and the text content to be searched and I get the output as those documents in which the text is found.
Kindly do let me know as this is a major issue for my system
Thanks & Regards,

Re: Searching a file in repository

itsard — Sat, 05 Sep 2009 06:42:40 GMT

Can anyone help me out with this??

Re: Searching a file in repository

shamabbas — Tue, 15 Sep 2009 09:07:59 GMT

Hi all,
I wrote java code using web services client to upload and download files into and from alfresco repository. Uploading successfully working and so download is. Download has a lil issue hopefully il resolve it soon.
BUT i wanted to ask that the path
http://localhost:8080/alfresco/service/sample/folder/Company%20Home where our uploaded file get stores if we want to retrieve them and

if move cursor to file it shows the following URL http://localhost:8080/alfresco/service/api/node/content/workspace/SpacesStore/d2edd2fa-b576-4a09-b469-7d3837965bf5/file555.txt hence by clicking we can download it.

Is there any method so i can access directly this URL "http://localhost:8080/alfresco/service/api/node/content/workspace/SpacesStore/" , index i know how to call il do so and then file name too but the URL is being used before these two things can i use it dynamically? Calling any function??? or ANYHOW????

Please help as soon as possible.. ill be very thankful to you guys!!!!

Sham