topic Re: Lucene Query by Mimetype in Alfresco Archive

Lucene Query by Mimetype

faiyth — Tue, 02 Oct 2007 16:08:42 GMT

I've been spending the last few days trying to figure out how to limit the results of my query to only jpgs and gifs in my folder and for some reason it just isn't working. Either I get absolutely nothing at all or I get every record.Here's the queries I've tried and their results:LucQuery = "text:\

Re: Lucene Query by Mimetype

kevinr — Thu, 04 Oct 2007 12:53:29 GMT

Which version of Alfresco are you using? I noticed you are using "phrase" search syntax i.e. in quotes. Have you tried this:

LucQuery = "name:*jpg";

Thanks,

Kevin

Re: Lucene Query by Mimetype

andy — Tue, 16 Oct 2007 15:11:51 GMT

Hi

Only properties of type d:content (eg cm:content) support queries for cm\:content.mimetype. What type is cm:abstract?

Andy

Re: Lucene Query by Mimetype

en64026 — Mon, 15 Sep 2008 14:09:17 GMT

Hi friends,

I used the below query to get the files based on their MIME types. I dint get any error but i can not get the result also.

There are files in the .pdf format but it is not displayed as results.

Kindly help me out in this issue.

var whitepapers = search.luceneSearch("PATH:\"/company_home.//*\"" + "@cm\abstract:mimetype:" + "application/pdf");

Thanks in advance

Regards,
Elavarasan N.

Re: Lucene Query by Mimetype

mikeh — Fri, 03 Oct 2008 16:49:21 GMT

Please see corrected search format on the wiki: http://wiki.alfresco.com/wiki/Search#Finding_nodes_by_content_mimetype

Thanks,
Mike

Re: Lucene Query by Mimetype

en64026 — Mon, 06 Oct 2008 14:21:12 GMT

Thanks Mike.

I have used the following code to get the contents by the mime type.

var whitepapers = search.luceneSearch("+PATH:\"/company_home.//*\"+@\"{http\://www.alfresco.org/model/content/1.0\}content.mimetype:text/plain'+'\"");

No error came. But output also dint come.

Kindly correct the code and let us know the correct syntax.

Thanks.

Regards,
Elavarasan N.

Re: Lucene Query by Mimetype

mikeh — Mon, 06 Oct 2008 14:56:53 GMT

You need to escape the "\" character that forms part of the query because this is contained within a JavaScript string. I've single-quoted the string to make things easier… you also need to be careful about spaces and note that it's "app:company_home"

search.luceneSearch('+PATH:"/app:company_home//*" +@\\{http\\://www.alfresco.org/model/content/1.0\\}content.mimetype:text/plain');‍

Mike

Re: Lucene Query by Mimetype

en64026 — Tue, 07 Oct 2008 07:32:51 GMT

Hi

Thank you very much mike………..

Its working fine now……….

Such a useful tip for me………….

Thank you once again mike.

Regards,
Elavarasan N.

Re: Lucene Query by Mimetype

en64026 — Thu, 09 Oct 2008 06:06:11 GMT

HI all,

Could anyone tell me how to display the content of the file using freemarket template.

While i using the key.content, the content have been displayed in the encrypted format like the below one.

+ _rels/.relsPK - !ky� �� theme/theme/themeManager.xmlPK - !�� P � theme/theme/theme1.xmlPK - ! ѐ�� '� theme/theme/_rels/themeManager.xml.relsPK ] � �� 8 � @ � �� 0 �( � � �B � S � � � � ? � � �.�(]� �@� � X @�� Unknown�� G � �* � � Times New Roman5 � �Symbol3.� �* � � Arial7.� � �{ @�CalibriA � Cambria @(� )�1Table �� WordDocument �� SummaryInformation( �� DocumentSummaryInformation8 �� CompObj ��y�� F'Microsoft Office Word 97-2003 Document MSWordDoc Word.Document.8�9�q

kindly tell me to avoid this problem.

Thank you.

Regards,
Elavarasan N.

Re: Lucene Query by Mimetype

mikeh — Thu, 09 Oct 2008 07:14:55 GMT

First of all, please open a new topic for completely unrelated questions - thanks.

As to your problem - your trying to do the equivalent of opening a Word document in Notepad. Try it - you'll get the same "random" characters. Because this is being displayed inline in a web browser, you must use text or html as the output.

Mike

Re: Lucene Query by Mimetype

en64026 — Thu, 09 Oct 2008 07:35:49 GMT

Thank you for your guidance……….. I will open a newtopic.

Kindly tell me how to display the output in text ot html format.

Thanks & Regards,
Elavarasan N.