4 messages in com.googlegroups.google-base-data-apiRe: How to query expired items| Subject: | Re: How to query expired items |
|---|---|
| From: | Steveo (adwo...@studio-40.com) |
| Date: | 07/26/2007 01:47:03 AM |
| List: | com.googlegroups.google-base-data-api |
Cool,
The orderby parameter seemed a little unpredictable, especially when I tried to use it with the sortorder parameter. I've switched to keeping a local record of when the item was last updated and using that to refresh an items getting close to 30 days.
Thanks for your help, trying to query the date fields on Google had me going in circles for hours. Steveo
On Jul 25, 4:03 pm, Jeff S <j....@google.com> wrote:
Hi Trong and Studio-40,
At the moment, you cannot query based on attributes that have type date. However, there is one parameter in which the updated time can be used: you can use orderby=modification_time as a query argument to get the most recently modified items first.
If you are trying to keep track of your items to update before they expire, it might be good to keep a list of id's somewhere so that you can track upcoming expirations. I think this is probably your best bet, since the API doesn't currently support searches by date.
Happy coding,
Jeff
On Jul 25, 7:12 am, Studio-40 <adwo...@studio-40.com> wrote:
I'm trying to figure this out too.
I've been using queries like items?bq=[expiration date : 2007-06-01..2007-08-23] items?bq=[expiration (daterange): 2007-07-10..2007-07-27]
But not quite managed to get anything that works.
Trong wrote:
I need to query expired items to update expiration date of those items. Is it possible to query expired items or query items whose updated date is 2007-06-18 etc. Anyone has some idea?
Thanks,
Trong