Custom Report

Unanswered Question
Jul 10th, 2007

Hello,


I am attempting to make a custom report using Infomaker pulling calls out of the TCD table.


I want to give the user the ability to pull a report, but let them pick from a list of Call Disposition codes they would like to pull. i.e all calls between start/end date with a disposition code of 23 or 1


Does anyone know how I can create a list of codes so that the user can select which codes they would like to see? Kind of like when you pick a list of 'call types' for a call type report.


Thanks!

Barry

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.

Barry,


If you look at the database schema document and examine the Termination_Call_Detail table, you will see that the field:


* WrapupData

* Data entered by the agent during call wrap- up.

* varchar(40)

* NULL


is not a foreign key in any other table. I think it's a free form field and you can't get the call disposition codes from the database. If you created those as registry entries for CTIOS, I think that is the only place they exist. I could be wrong of course ... but I'm interested in wrap-up data too and your question is a good one.


Regards,

Geoff


Actions

This Discussion