java - GAE Search API Query with "Date = YYYY-MM-DD" returns no results -


i trying perform simple date query on google app engine using search api. trying achieve obtain list of documents have field equal date...

// prepare query string searchstring = "date = 2013-08-26"; query query = query.newbuilder().build(searchstring);  // date_search index indexspec indexspec = indexspec.newbuilder().setname("date_search").build(); index index = searchservicefactory.getsearchservice().getindex(indexspec);  // perform search results<scoreddocument> results = index.search(query);

when run above code, no results returned. however, if change query date >= 2013-08-26 && date < 2013-08-27 instead, expected results returned. seems though date equality logic isn't working.

this list of documents in index...

docid                                   orderid     date        event_key 3d4e5691-8fb9-42de-bf09-f2303236f091    84288787    2013-08-25  641.0 7e4700fe-dee1-4579-87c5-69b1b1929f39    84288787    2013-08-25  650.0 8c9ca43d-7673-4f12-9f0b-e3328cbdaa85    84288787    2013-08-26  659.0 04fa8025-e01b-42d3-9bf9-21c3d9618ca7    84288787    2013-08-26  668.0 41465d1f-6d8a-431f-b226-141c8d72c064    84288787    2013-08-26  676.0 1ba01a6b-0890-43b3-8225-0ed196b6ee80    84288787    2013-08-27  676.0 a8ef18b1-ffa5-4823-8442-852f7142cad1    84288786    2013-08-25  633.0

i expecting 3 documents returned date 2013-08-26. when running equality date = 2013-08-26 there no results, query date >= 2013-08-26 && date < 2013-08-27 returns expected 3 results.

the documents added index using following code...

// build date calendar calendar = calendar.getinstance(); date dateobject = calendar.gettime();  // create document builder builder = document.newbuilder(); builder.addfield(field.newbuilder().setname("event_key").setnumber(eventkey)); builder.addfield(field.newbuilder().setname("date").setdate(dateobject)); document document = builder.build();  // date_search index indexspec indexspec = indexspec.newbuilder().setname("date_search").build(); index index = searchservicefactory.getsearchservice().getindex(indexspec);  // store document index.put(document);

according search api documentation, date fields stored , query-able yyyy-mm-dd precision(the time information stripped out when storing , querying). additionally, query on date fields documentation shows date equality queries supported.

could please me understand issue is.

your use of search dates correct. there bugs in area, have been fixed in version 1.8.4.

a couple of points of clarification:

  1. dates stored @ millisecond resolution, they're indexed @ resolution of 1 day. so, purposes of searching , sorting have date, not time of day. when examine retrieved document, date fields have been restored millisecond precision.

  2. dates appear in query (in yyyy-mm-dd form) considered in utc time zone. implication of bit subtle:

    let's you're sitting in australia @ 2:00am on 2013/9/10, , decide insert document then-current time. on in greenwich it's not yet midnight; date still september 9. if search document date, find [date=2013/09/09] not [date=2013/09/10].

    similarly, if you're sitting in california @ 9:00pm 1 night, it's past midnight in utc ...

  3. there seems bug in dev server admin console. on full text search page, if display document content includes date, date rendered in local time zone instead of utc. , not include time component.


Comments

Post a Comment

Popular posts from this blog

html - How to style widget with post count different than without post count -

i have border below li elements in wordpress widget types appropriate. element inside set block gives them nice easy click full width. the problem, when choose option "show post count" when adding widget such categories or archives displays post count plain text after tag , because tag block pushes post number text line below. whether choose show post count or not show post count still gives exact same element identifyer example "widget_categories". how style post count not on next line still keep links non post count list items full width? here's example on sidebar www.bbmthemes.com/themes/modular/blog-standard/ in order solve problem need remove display:block; for ul.widgets ul a , add in it's place line-height: 33px; what going achieve have same visual effect. what going lose doing links going work on text , not on "box". the other way out of find post count coming , make changes this. example change text count i
Read more

How to remove text and logo OR add Overflow on Android ActionBar using AppCompat on API 8? -

have researched death , cannot find answer. i have actionbar using appcompat. supporting api v7 (api v8 do). actionbar works api v11. api < v11 has problem of removing icon (and feature) actionbar without supplying overflow. big picture have app logo, app title, , 3 icons squidging same actionbar on low end phone. trying make room! i happy 1 of 2 solutions. either: a method of getting overflow functionality can retrieved pull down. (preferred) method of removing icon , text actionbar below current xml api 11+: <resources> <!-- base application theme api 11+. theme replaces appbasetheme res/values/styles.xml on api 11+ devices. --> <style name="appbasetheme" parent="theme.appcompat.light.darkactionbar"> <item name="android:actionbarstyle">@style/liteactionbarstyle</item> <item name="actionbarstyle">@style/liteactionbarstyle</item> </st
Read more

javascript - storing input from prompt in array and displaying the array -

i want take the inputs user prompt, store input in array, , display it. want take 10 inputs user using for loop. have tried do-while shown below. var givennames = new array(); var pattern = /[\w\d]{1,}/ig; do{ var name = prompt("enter names. letters , digits accepted!\nentering empty field stops asking",""); if(name && name.match(pattern)){givennames.push(name);} } while(name != ""); function displaynames(){ if(givennames.length > 0){ document.getelementbyid("list").innerhtml = "<span style='color:navy;font- weight:bold;'>given names are:<\/span><br><br>" + givennames.join("<br><br>"); } else { document.getelementbyid("list").innerhtml = "<span style='color:navy;font-weight:bold;'>nothing has been given!<\/span>"; } } how replace for loop? var givennames = new array();
Read more