From: Klaus G. <kla...@ro...> - 2011-11-08 23:31:47
|
Hi there ! The .xconf is in the same location as my XML file - per the admin UI - the collection was highlighted and "reindexed" in the java client and I finally got a result but dont have the foggiest how to create queries that do the below from my prior email..if you want me to try a better .xconf please send along ! Leading wildcards are a must too... thanks so much in advance, baby steps here but this is way better than compiling clucene from source which I dont know how to do ! * Storing uploaded content to: collection.xconf/db/testdata/collection.xconf ________________________________ From: Joe Wicentowski <jo...@gm...> To: Klaus Gruen <kla...@ro...> Cc: Dannes Wessels <da...@ex...>; "exi...@li..." <exi...@li...> Sent: Tuesday, November 8, 2011 3:26 PM Subject: Re: [Exist-open] Existdb windows 7 nightmares - can someone compile exist V 1.5 into a binary? Hi Klaus, Sounds like progress - you've gotten your data into the database. Now we're down to index configurations and indexing. Where did you store your collection.xconf and the XML document containing your data? Please provide the complete database paths. Joe On Tue, Nov 8, 2011 at 6:19 PM, Klaus Gruen <kla...@ro...> wrote: > Thanks ! So close. At the bottom of this reply is my collection.xconf. The > XML it references looks like: > <records> > <customerID>8000166737</customerID > > <name>Cisco Systems</name> > </records> > This returns results: //records and also: //customerID > This doesnt work - any ideas why ? > //records[ft:query(name, 'Cisco Systems')] > //name[ft:query(., 'Cisco Systems')] > Questions - > 1 - What is the search syntax for issuing this leading wildcard search - I > know I need to add the <options><leading_wildcard> but > a -what is the xQuery syntax for this and what about case sensititity? > *cisco*systems* > b - How do I return just the the customerID column only for those > records that match ? > 2 - What is the XQuery syntax for this ? > a - select records where customerID field IN (8000166739, 80121266737) > b - select name where customerID field IN (8000166739, 80121266737) > Search Result - the actual rows that contain this keyword: > 8000166737 Cisco Systems Incorporated > > > > > <collection xmlns="http://exist-db.org/collection-config/1.0"> > <index xmlns:atom="http://www.w3.org/2005/Atom" > xmlns:html="http://www.w3.org/1999/xhtml" > xmlns:wiki="http://exist-db.org/xquery/wiki"> > <!-- Disable the standard full text index --> > <fulltext default="none" attributes="no"/> > <!-- Lucene index is configured below --> > <lucene> > <analyzer class="org.apache.lucene.analysis.standard.StandardAnalyzer"/> > <analyzer id="ws" class="org.apache.lucene.analysis.WhitespaceAnalyzer"/> > <text qname="records" analyzer="ws"/> > <text qname="customerID" analyzer="ws"/> > <text qname="name"> > </text> > <text match="//name/*"/> > <!-- "inline" and "ignore" can be specified globally or per-index as shown > above --> > </lucene> > </index> > </collection> |