Hello,
This is my first post here so I am hoping that this is the start of a beautiful relationship
This is kind of complex so I will attempt to explain my situation clearly.
What I am trying to do! Auto assign analysts to each call that come into the call center even if the analyst is not logged into the database. The calls, as they are assigned would be held for each analyst in the que. When they log in they will see the calls assigned specifically to them.
My Process is as follows:
I currently import two Excel spreadsheets into a temp table, append the data to the permanent table then delete the data in the temp table.
My thoughts on how to tackle this are:
I create a query that hold all the data and write an expression that evaluates the "Status" field (Open or Closed) and the "SecurityID" field and if the "Status" field is Open and the SecurityID is Null then assign the next Analyst in the list.
Any ideas on how I can tackle this issue?
Thank you,
Chris
This is my first post here so I am hoping that this is the start of a beautiful relationship
This is kind of complex so I will attempt to explain my situation clearly.
What I am trying to do! Auto assign analysts to each call that come into the call center even if the analyst is not logged into the database. The calls, as they are assigned would be held for each analyst in the que. When they log in they will see the calls assigned specifically to them.
My Process is as follows:
I currently import two Excel spreadsheets into a temp table, append the data to the permanent table then delete the data in the temp table.
My thoughts on how to tackle this are:
I create a query that hold all the data and write an expression that evaluates the "Status" field (Open or Closed) and the "SecurityID" field and if the "Status" field is Open and the SecurityID is Null then assign the next Analyst in the list.
Any ideas on how I can tackle this issue?
Thank you,
Chris
