[Developers] sort by count

[Arthur van Hoff]

Hi Jack,

I don't think that it is currently possible to sort by the count. It
would be great if you could (I've asked for it before). This is one of
the cases where you have to get all results, and do the sort in your
app.

By the way, there are 1323 results for your query, so you should not use
limit:1000. Increasing the limit does work, but you run the risk of a
timeout. Instead you should probably use a cursor to collect all the
results in multiple requests.

Have fun,

    Arthur van Hoff

> -----Original Message-----
> From: developers-bounces at freebase.com [mailto:developers-
> bounces at freebase.com] On Behalf Of Jack Alves
> Sent: Sunday, August 10, 2008 5:28 PM
> To: developers at freebase.com
> Subject: [Developers] sort by count
> 
> Is there a way to sort by count? I tried using return even though it
> is not legal to sort by directive,
> 
> "sort" : "film.return"
> 
> I am only interested in the top 10 counts. I would query all then
> copy
> to a spreadsheet for counting but the query returns more than 1000
> results. I am able to get a result if I specify an
> initial_release_date greater than 1940.
> 
> Here's my query,
> 
> 
> 
> 
> [
>   {
>     "film" : [
>       {
>         "film" : [
>           {
>             "awards_won" : [
>               {
>                 "award" : [
>                   {
>                     "name" : null,
>                     "name~=" : "*academy award*"
>                   }
>                 ]
>               }
>             ],
>             "name" : null,
>             "type" : "/award/award_winning_work"
>           }
>         ],
>         "return" : "count",
>         "type" : "/film/performance"
>       }
>     ],
>     "name" : null, "limit":1000,
>     "type" : "/film/actor"
>   }
> ]
> _______________________________________________
> Developers mailing list
> Developers at freebase.com
> http://lists.freebase.com/mailman/listinfo/developers