topic Re: search xml using lucene ,is that possible? in Alfresco Archive

search xml using lucene ,is that possible?

mmrs — Tue, 24 Feb 2009 09:21:03 GMT

Hi allI got some xml files placed on some where like "Company Home > MyProject> Projects > Proposed > Submitted Project".The "Submitted Project" folder contains xml files that represent data and forms of that projectand i want to search these xml files but i need the result as pairs of(

Re: search xml using lucene ,is that possible?

mmrs — Tue, 24 Feb 2009 23:35:06 GMT

… till now i came up with this:

String xmlTag="<"+searchIn+">"+searchFor;
        SearchParameters sp=new SearchParameters();
        sp.addStore( new StoreRef(StoreRef.PROTOCOL_WORKSPACE,"SpacesStore"));
        sp.setLanguage(SearchService.LANGUAGE_LUCENE);
        sp.setQuery("PATH:\"" + "/app:company_home/cm:MyProject/cm:Projects/cm:Proposed/cm:SubmittedProject" + "//*\" AND TYPE:\"" +
                    ContentModel.TYPE_CONTENT + "\" AND TEXT:\"" + xmlTag + "\"");
ResultSet resultSet = getSearchService().query(sp);‍‍‍‍‍‍‍

where searchIn: the xml Element
searchFor: it's value (number)

but the problem is that lucene looks for string here not int here;
if element "pipeWidth" has the value:08 in the xml file ,and the search parameter were:
searchIn="pipeWidth"
searchIn=8 , then resultSet will be null :cry:

how can i fix this
please some one highlight this post

regards
mmrs

Re: search xml using lucene ,is that possible?

pmonks — Wed, 25 Feb 2009 03:10:26 GMT

The XML Metadata Extractor can be used for this - it extracts element and/or attribute values from XML files and stores them in metadata properties (which can be indexed into the search engine).

There's a page on the wiki that documents how to configure XML Metadata Extraction.

Cheers,
Peter

Re: search xml using lucene ,is that possible?

mmrs — Wed, 25 Feb 2009 11:29:48 GMT

thank you for ur respose

i will look for that page and try the XML Metadata Extractor

Re: search xml using lucene ,is that possible?

camillo — Wed, 15 Apr 2009 14:28:34 GMT

I have the same problem!
Did you solve it?