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.4 | SVN Version: 3889 | DB Schema Version: 1721 | Asterisk 18.21.1 | PHP8
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WA: +19549477572
GC: https://join.skype.com/ujkQ7i5lV78O | DC: https://discord.gg/DVktk6smbh
carpenox
 
Posts: 2423
Joined: Wed Apr 08, 2020 2:02 am
Location: St Petersburg, 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.4 | SVN Version: 3889 | DB Schema Version: 1721 | Asterisk 18.21.1 | PHP8
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WA: +19549477572
GC: https://join.skype.com/ujkQ7i5lV78O | DC: https://discord.gg/DVktk6smbh
carpenox
 
Posts: 2423
Joined: Wed Apr 08, 2020 2:02 am
Location: St Petersburg, FL


Return to Development

Who is online

Users browsing this forum: No registered users and 27 guests