RE: starting back at A the next day – you could flag worked numbers in the database as “reviewed” or “completed” and that’s how you know where to start them off on their next session when they log in – that way if they are say working ZIP code 12345 and 50 new entries get added in the interim, those will show up as needing review, regardless of their alphabetical order.
I think an intersecting table containing the user ID and the ticket or record ID and the status ID would be best as far as normalization goes, but that’s just off the top of my head. From: [email protected] <[email protected]> On Behalf Of Mike G Sent: 23 January, 2019 4:48 PM To: [email protected] Subject: [houcfug] Need some discussion 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]<mailto:[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]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. Disclaimer The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful. This email has been scanned for viruses and malware, and may have been automatically archived by Mimecast Ltd, an innovator in Software as a Service (SaaS) for business. Providing a safer and more useful place for your human generated data. Specializing in; Security, archiving and compliance. To find out more visit the Mimecast website. -- -- 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.
