We do a lot of work with queues and dates and workflows. The best pattern I've found is to have an attached events table. That's how you exclude (or if you want to be able to circle back around after you've gone through the list, group by record and sort by min(call_date) or something like that). I wouldn't sort by just name; I'd sort by the date the record was added and then name.
Billy Cravens On Wed, Jan 23, 2019 at 4:48 PM Mike G <[email protected]> wrote: > Working solo is tough sometimes, no sounding board for ideas; hoping y'all > can help... > > I am working on an app for a call center and my brain is out of ideas. > > I am trying to figure out how to make and maintain a queue for calling. > > So, I have a caller who has a territory, say zipcode 12345. > Query the database for all of 12345 sort alphabetically and in the morning > give them record 1. Timestamp it. > > They make it to the middle of B.. > > Tomorrow I don't want them starting at A again..now what? > Further, when I import new contacts, I don't want them to have to wait > until they hit Z and start over to see them. > > So, ideas on how to build a queue? I am all idea'd out...or over thinking > it... > > TIA > > M > > -- > -- > You received this message because you are subscribed to the "Houston > ColdFusion Users' Group" discussion list. > To unsubscribe, send email to [email protected] > For more options, visit http://groups.google.com/group/houcfug?hl=en > > --- > You received this message because you are subscribed to the Google Groups > "Houston ColdFusion Users' Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- -- You received this message because you are subscribed to the "Houston ColdFusion Users' Group" discussion list. To unsubscribe, send email to [email protected] For more options, visit http://groups.google.com/group/houcfug?hl=en --- You received this message because you are subscribed to the Google Groups "Houston ColdFusion Users' Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
