Custom reports on vicidial

Discussions about development of VICIDIAL and astGUIclient

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Custom reports on vicidial

Postby prabinnair » Tue Sep 14, 2021 2:47 am

Can anybody suggest how to create a custom report on vicidial where i can pull the below mentioned.
agent name
Total login hrs
Total calls taken
Total Break time
dispo
dispo category
prabinnair
 
Posts: 8
Joined: Sat Aug 28, 2021 12:20 am

Re: Custom reports on vicidial

Postby carpenox » Tue Sep 14, 2021 8:17 am

why not use the agent or team performance detail reports?
Leap 15.3 | Version: 2.14-829a | BUILD: 210911-1958| SVN Version: 3520 | DB Schema Version: 1645 | Asterisk 16.20.0-vici
www.CyburDial.net -:- 844-PC-SATA-2 -:- My Blog: http://vicidial.blog -:- Whatsapp: +19549477572 -:- Skype: live:carpenox_3
carpenox
 
Posts: 1574
Joined: Wed Apr 08, 2020 2:02 am
Location: Coral Springs, FL

Re: Custom reports on vicidial

Postby prabinnair » Wed Sep 15, 2021 2:12 am

It Dose not contain the dispo category. I want dispo category in the report
prabinnair
 
Posts: 8
Joined: Sat Aug 28, 2021 12:20 am

Re: Custom reports on vicidial

Postby carpenox » Wed Sep 15, 2021 8:01 am

ah ok, then you would need to figure out the proper mysql query and put it on a php page you can link to custom reports
Leap 15.3 | Version: 2.14-829a | BUILD: 210911-1958| SVN Version: 3520 | DB Schema Version: 1645 | Asterisk 16.20.0-vici
www.CyburDial.net -:- 844-PC-SATA-2 -:- My Blog: http://vicidial.blog -:- Whatsapp: +19549477572 -:- Skype: live:carpenox_3
carpenox
 
Posts: 1574
Joined: Wed Apr 08, 2020 2:02 am
Location: Coral Springs, FL


Return to Development

Who is online

Users browsing this forum: No registered users and 5 guests