0

Returning YQL query in correct publish date order, seems to order on last index currently.

Hi All,

I'm currently trying to get some results to come back to me in date order.

This is almost working perfectly.

select title,abstract,url,date from search.web(0) where query="search term" and sites="www.independent.co.uk" | sort (field='date') | reverse()

The problem is that the dates that are brought back are not the actual dates that the articles were published on, rather they seem to be the dates that they were last indexed on.

I have had more success with change it from search.web to search.news , however now it only brings back results for the last week or two.

Using the yahoo news search brings back results up to 2 months ago, so this is an improvement.

http://uk.news.search.yahoo.com/

is there a way to get the same results as I can here, or ideally just get the first query to work based on the same date system as the news search?

Thanks for any help,

Chris B

by
1 Reply
  • QUOTE (rhythm.optician @ Jan 28 2010, 08:23 AM) <{POST_SNAPBACK}>
    Hi All,

    I'm currently trying to get some results to come back to me in date order.

    This is almost working perfectly.

    select title,abstract,url,date from search.web(0) where query="search term" and sites="www.independent.co.uk" | sort (field='date') | reverse()

    The problem is that the dates that are brought back are not the actual dates that the articles were published on, rather they seem to be the dates that they were last indexed on.

    I have had more success with change it from search.web to search.news , however now it only brings back results for the last week or two.

    Using the yahoo news search brings back results up to 2 months ago, so this is an improvement.

    http://uk.news.search.yahoo.com/

    is there a way to get the same results as I can here, or ideally just get the first query to work based on the same date system as the news search?

    Thanks for any help,

    Chris B


    In your case, it might be easier to write an open data table around the RSS feed that comes from uk.news.search.yahoo.com since search.news only gives back 2 weeks worth of data.

    I'd write an open data around the following URI

    http://uk.news.search.yahoo.com/search/new...tart=1&b=11

    -- Nagesh
    0

Recent Posts

in YQL