[Babase] revised ranker ready for testing

kfenn kfenn at princeton.edu
Fri May 9 08:54:51 EDT 2008


Jun Yang wrote:
> Ranker draws the names using queries stored inside the RNKTYPES table.
> (Changing these query definitions will conveniently change the ranker
> behavior.) For example, the query currently being used for ADM (adult
> males) is:
>
> SELECT DISTINCT(biograph.sname) from biograph, members, rankdates
> where biograph.sname = members.sname AND members.date >= %s AND
> members.date<= %f AND members.grp= %g AND biograph.sex='M' and
> rankdates.sname=biograph.sname and rankdates.ranked <= %f
>
> In the above %s and %f refer to the ranking start/end dates,
> respectively. It seems do to exactly what you want (please confirm); I
> just need to remove the ranker check that %s and %f be the first and
> last days of the same month.
>
>   
Thanks, that answers my question (MEMBERS is created from the CENSUS 
table so we are including all known individuals). Yes, please remove the 
restriction that forces the ranking period to be limited to the first 
and last days of the same month and I'll give it another try.

Tabby

> --- Jun Y.
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase
>   

-- 
Tabby Fenn
Research Assistant

Dept of Ecology and Evolutionary Biology
401 Guyot Hall
Princeton University
Princeton, NJ  08544

609 258-6898 (Ph)
609 258-2712 (Fx)



More information about the Babase mailing list