BTW, the A-Z is just to make the problem easier to explain. On Wed, Jan 23, 2019 at 5:26 PM Mike G <spi...@gmail.com> wrote:
> I don't really want them to start at A every day, and when they get to Z, > want them to be able to restart at A. I do record lastCallAttempt and > lastCallReach timestamps. > > I considered querying "where lastCallAttempt gt 30/60/90 days"...but with > call lists ranging from 100 to 50000 records, isn't dynamic enough.. > > > > On Wed, Jan 23, 2019 at 5:22 PM Billy Cravens <bdcrav...@gmail.com> wrote: > >> 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 <spi...@gmail.com> 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 houcfug-unsubscr...@googlegroups.com >>> 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 houcfug+unsubscr...@googlegroups.com. >>> 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 houcfug-unsubscr...@googlegroups.com >> 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 houcfug+unsubscr...@googlegroups.com. >> 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 houcfug-unsubscr...@googlegroups.com 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 houcfug+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
