Get rows from a queue table ?

M

mscertified

I have an application where agents type in trouble tickets that they get via
phone and email.
Now there is to be a web portal that inserts rows to a ticket queue table.
There will be a queue count displayed on the agent's screen along with a GET
button. When this button is clicked, the first item in the queue must be
populated on the screen and removed from the queue.
Since there are multiple ticket agents working simultaneously, how can I
code this to ensure that no two agents grab the same row or grab different
rows but remove the wrong one?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Setting up an outbound campaign 1
Multiple users 'pulling from queue table' 1
Outbound campaign 0
Pivot Table into Report 1
Total appointments per agent 2
Repeating a row other than the 1st row as the header row in a table from next page 1
PSI Calls Hang in Queue in ReadyForProcessing Job State 3

Top