Work Queue Design Question
Posted on 2011-10-02
Although this is more of a program design question, it's in Coldfusion so we'll be talking the same "language" so to speak.
I have a "work queue" shared by several administrators to review community data added to a "company" table (for example).
When admin1 selects revew task1, it should no longer be available to the other administrators.
OK. So I can update a flag on the work_queue table. If admin1 closes the browser and leaves for the day, do I keep that task still assigned to admin1 or put it back in the pool? I'm not sure how I would even know how to detect that unless admin1 indicated he/she was done with the review or releasing it back to the pool.
Am I on the right track? I have never worked with a queue type application.
Thanks in advance,