Hacker News Reader

Comment by thaumaturgy | Hacker News Reader

Looks like items marked [dead] in HN will show up as zombie search results -- i.e., they get returned in the search results for the items collection but the discussion field is null.

For example: filter[fields][type]=comment&filter[fields][username]=pg

...the second result there has a null discussion field. Getting the submission title &etc. would be nice.

View on HN

The 'discussion' attribute contains info about the discussion that the comment belongs to. In this case the parent discussion is [dead] so the value of 'discussion' is null. Unfortunately, we don't have access to submission titles for [dead] submissions.

Is there a way to exclude values from search results in the ThriftDB API? i.e., say I want to,

    [filter][domain]=nytimes.com&[filter][username]!=ausername

...is there a way to do that? I tried the "exclude" operator after [username] and get an "internal server error" every time.

&filter[fields][domain]=nytimes.com&filter[queries][]=-username:ausername

Great! Thanks.

Argh. And also, is there any way to query ThriftDB for HN date ranges?

You can use strings to represent relative times:

&filter[fields][create_ts]=[NOW-5HOURS%20TO%20NOW]

or exact timestamps:

&filter[fields][create_ts]=[2011-06-01T05:00:00.00Z%20TO%202011-06-02T07:00:00.00Z]

or both:

&filter[fields][create_ts]=[2011-06-01T05:00:00.00Z%20TO%20NOW]

Sweet! That's perfect. Thank you.

Reply on news.ycombinator.com