Databases
StackOverflow2013
Postsdbo
POAdvanced Search on Github?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POAdvanced Search on Github?
    primarykey
    data
    text
    <p>I would like to make an advanced search for repos under github for commits which match the conditions below:</p> <ul> <li>Language: Javascript</li> <li>Created: [2011-01-01 TO NOW]</li> <li>Pushed: [2012-05-01 TO NOW]</li> <li>Forks: [100 TO *]</li> <li>Size: [100 TO 1000] //(kb)</li> </ul> <p>I know that github uses Lucene to perform its searchs, but searching around I can't find any documentation on query syntax, and if I follow the guidelines of the apache Lucene documentation I often end up with an "Invalid query syntax" message.</p> <p>For my personal query I have already passed the language, size and forks queries with no problem, but I still have problem to find a good match to perform a query syntax based on dates.</p> <p><strong>Is it mandatory that I have to include the Timestamp in the date queries?<br> Could I make some computation for dates like NOW - 3MONTHS?<br> For example, how could I search repos that were created 4 MONTHS AGO TO NOW?</strong> </p> <p>EDIT:</p> <p>I talked to github support and they said to me that they use the Solr query syntax which allows the date range queries using calculations such as <code>NOW - 4MONTHS</code>, but for some reason it doesn't work ok for me or I just don't understand how these filters operate (created and pushed).</p> <p>Just to test it, I tried to find any Repos, with Javascript as the main language, both of this selected from the combo boxes and then try to search using the [created} filter and see what strange results I have.</p> <p>For the first search I try to find any javascript repo created between today and 12 months ago.</p> <p><strong>created:[NOW-12MONTHS/DAY TO NOW/DAY]</strong> </p> <p>That gives me a total of 233500 Repos and I have listed the "twitter/bootstrap" repo at the top.</p> <p>For the second search I tried to find any Javascript repo created between today and 24 months ago.</p> <p><strong>created:[NOW-24MONTHS/DAY TO NOW/DAY]</strong> </p> <p>Not only it gives me less repos than before, 11867 in total, but I don't have the "twitter/bootstrap" repo listed any more in the results page (which I think is wrong because my second search "contains" the first one). The first result has less watchers than "twitter/bootstrap" and if I order the results by watchers count it would be wrong to not have it at the top!</p> <p>I'm not saying that there is a bug on the site, but I just don't understand how it works for doing calculations with date ranges. Hope someone can help me clarify my issues.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USBridge
    1. USdenica
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POAdvanced Search on Github?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POAdvanced Search on Github?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POAdvanced Search on Github?
      1. USVonC
      1. VTFavorite
    1. This table or related slice is empty.
 

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