Re: Mayor of Libraries

From: Dave Caroline <dave.thearchivist_at_nyob> Date: Fri, 27 Mar 2015 17:28:24 +0000 To: CODE4LIB_at_LISTSERV.ND.EDU

As long as there is an index on the fields then it is not taxing for
the database.

if displaying on and off shift then
select persons from the_database order by onsite,rank
(0 off shift, 1 on shift)

a status update is just setting that persons shift status

add limit 1 if you just want the top of the pile

Dave Caroline