Array assistance - Phone information reporting

[nosajld]

Greetings -

I'm running various reports on our phone system (ShoreTel) through CR XI. We are needing to know when a user transfers a call out to another internal number or external number. Currently ShoreTel only marks a Transfer when you RECEIVE the transfer. They DO NOT mark a status for when you SEND a transfer.

Here is what I have to work with:

Each call record has a PRIKEY of CallTableID.

Here is a small sample of what I have for clarity...

PartyID ConnectReason TableCallID
2298 Called 1,145,395.00 (received an outside call)
19999999999 Originate 1,145,395.00 (This is the incoming external call)
2267 Transfer 1,145,395.00 (2267 receives a transfered call)


Through assistance here I have been able to isolate the data I need (PartyID from Called line). Now I need assistance in comparing the PartyID to an array of extensions (same length, same data type) and summing all the calls from each {?extension}. I'm not quite sure how to set this up but I'm thinking something like this:

Current formula to display PartyID from Called line: (this currently displays the correct information I need)

if {connect.ConnectReason} = 9 and
{connect_1.ConnectReason} = 17 and
{connect_1.PartyIDName} <> "VM Login"
then {connect_1.PartyID}
else "0";

I assume that I need to assign the "then {connect_1.PartyID}" to a global array x. Once this is finished collecting all of the data into the array (3000+ numbers max) I need to then compare it to the list of extensions.

Something like this?

for each x
if x = {?extension}
then 1
else 0

Thank you for any assistance you can provide.

Jason

 

[lbass]

You should have stayed in the original thread, which provides the context for this. Where are these extensions appearing in your sample data? Turkbear made a reasonable suggestion that should have addressed your needs in the original post.

-LB

 

[nosajld]

my appologies for the "double post". Caffeeine is to blame today.

Turkbear did indead assist and I've made strides in getting the data collected and now need to compare them to the user prompted {?extensions} data.

I'm still not quite sure the best way to compare the data. Am I on the correct path with the array comparisons? the array might be something like extensions[2298,2071,2777,3034] and I need to compare each to tghe values found when searching on the formula I have pulling the original PartyID.

Last week alone had over 6000 transfers. Every transfer PartyID will have to compared to the Extension array which is typically 3-15 different extensions. So you can see why if an entire month or quarter is pulled and 30,000 transfer records compared with 15 extensions can take a lot of resources. I'm just looking for the best way to do the comparison with what I currently have.

Thank you for any assistance you can lend as the knowledge on this forum is a great resource for all users beginners to advanced.

Jason