Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I'm not familiar with "SimpleLucene" but your code looks a lot more complex than it needs to be. </p> <p>A few things:</p> <p>Field names are case-sensitive, you store the job title as "jobtitle" but search for it using "JobTitle". They need to match. </p> <p>You mentioned that you want to search the DatePosted and Location fields but they are "NOT_ANALYZED" in the code you posted. Change it to "ANALYZED" if you want to search those fields.</p> <p>Try the whitespace analyzer if you want to keep terms like ".net" and "C#". Keep in mind that the whitespace analyzer does not use the lowercase filter, so a search for ".NET" wont match ".net". You may have to write your own analyzer.</p> <p>A1: All of the built in Analyzers (except keyword and whitespace) strip the period from a term, so it shouldn't matter if you search for: "net", ".net", ".net", ...net...", etc.. If this isn't the case, there's another problem. Post some code and maybe we can help.</p> <p>If you need to match terms like ".net" and "C#" you will probably have better luck with the Whitespace Analyzer. If that doesn't meet your needs you will probably have to write your own analyzer.</p> <p>A2: The Standard Analyzers automatically converts upper-case to lower case, so case is already ignored for you.</p> <p><a href="http://today.java.net/pub/a/today/2003/07/30/LuceneIntro.html" rel="nofollow">This page has good examples of what the various Analyzers do to a phrase.</a></p> <p>From the page above:</p> <p><strong>Analzying "The quick brown fox jumped over the lazy dogs"</strong></p> <pre><code>org.apache.lucene.analysis.WhitespaceAnalyzer: [The] [quick] [brown] [fox] [jumped] [over] [the] [lazy] [dogs] org.apache.lucene.analysis.SimpleAnalyzer: [the] [quick] [brown] [fox] [jumped] [over] [the] [lazy] [dogs] org.apache.lucene.analysis.StopAnalyzer: [quick] [brown] [fox] [jumped] [over] [lazy] [dogs] org.apache.lucene.analysis.standard.StandardAnalyzer: [quick] [brown] [fox] [jumped] [over] [lazy] [dogs] org.apache.lucene.analysis.snowball.SnowballAnalyzer: [quick] [brown] [fox] [jump] [over] [lazi] [dog] </code></pre> <p><strong>Analzying "XY&amp;Z Corporation - xyz@example.com"</strong></p> <pre><code> org.apache.lucene.analysis.WhitespaceAnalyzer: [XY&amp;Z] [Corporation] [-] [xyz@example.com] org.apache.lucene.analysis.SimpleAnalyzer: [xy] [z] [corporation] [xyz] [example] [com] org.apache.lucene.analysis.StopAnalyzer: [xy] [z] [corporation] [xyz] [example] [com] org.apache.lucene.analysis.standard.StandardAnalyzer: [xy&amp;z] [corporation] [xyz@example] [com] org.apache.lucene.analysis.snowball.SnowballAnalyzer: [xy&amp;z] [corpor] [xyz@exampl] [com] </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POLucene.net cant search ".net"
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USSharpBarb
    1. USSharpBarb
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POLucene.net cant search ".net"
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COPosted some updates. Please look. Also want to know if it is possible to search using lucence something like. NewYork, newYork, N ew York and result new york?
      singulars
      1. PO
      1. USF0rc0sigan
    2. CONo, a search for newyork, newYork, or "N ew york" will not return "new york"
      singulars
      1. PO
      1. USSharpBarb
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload