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: 12
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?
Alma Linux 9.3 | Version: 2.14-905a | SVN Version: 3800 | DB Schema Version: 1706 | Asterisk 18.18.1
www.dialer.one -:- 1-833-DIALER-1 -:- My Blog: https://dialer.one/table-of-contents -:- WhatsApp: +19549477572 -:- Skype: live:carpenox_3
carpenox
 
Posts: 2213
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: 12
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
Alma Linux 9.3 | Version: 2.14-905a | SVN Version: 3800 | DB Schema Version: 1706 | Asterisk 18.18.1
www.dialer.one -:- 1-833-DIALER-1 -:- My Blog: https://dialer.one/table-of-contents -:- WhatsApp: +19549477572 -:- Skype: live:carpenox_3
carpenox
 
Posts: 2213
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