Telah Dianugerahkan

Kayako Report Generation - Kayako Query Language (KQL)

We have recently purchased the Kayako ticketing system to assist with our new call centre. We require someone able to develop customised reports written using KQL which is similar to SQL syntax. To be eligible, we will require someone who has used KQL previously and is very familiar with it to ensure an efficient service is provided.

I have attached an example of the final report that we are wanting. We will no doubt require further reports in the future. For now, if you could look at the attachment and provide a price on how much it would cost to produce the required code for the attached report. You will note some of the fields are already populated. We require the code to populate the empty fields.

An example of how KQL code is laid out has been pasted below.

SELECT 'Ticket Audit [url removed, login to view]', 'Ticket Audit [url removed, login to view]' FROM 'Ticket Audit Logs' WHERE 'Ticket Audit [url removed, login to view]' = 'Staff' AND 'Ticket Audit [url removed, login to view] Date' > mktime(0,0,0,03,26,2012) AND 'Ticket Audit [url removed, login to view] Date' < mktime (23,59,59,03,30,2012) MULTIGROUP BY 'Ticket Audit [url removed, login to view] Date':Week, 'Ticket Audit [url removed, login to view] Date':DayName, 'Ticket Audit [url removed, login to view] Name' ORDER BY 'Ticket Audit [url removed, login to view] Date' ASC

Kemahiran: Pengaturcaraan C, SQL

Lihat lebih lanjut: kayako kql, kayako query language, kql query, kql, kayako sql, kayako query language kql, mktime kayako, report kayako, kayako call report, kayako report example, kayako sql query reports, kql query language, kayako sql query, kql query creation date, kql example, kayako ticketing system kql, kql kayako, syntax programming, report programming, programming language syntax, note creator, new programming language, sql programming language, generation programming language, programming syntax

Tentang Majikan:
( 1 ulasan ) Seven Hills, Australia

ID Projek: #1542614

4 pekerja bebas membida secara purata $413 untuk pekerjaan ini

manohartvs

Hi There, I've provided the details of my bid in a Private message. Kindly have a look. Thanks MAV_IT

$300 AUD dalam 4 hari
(2 Ulasan)
2.5
topmost82

Hi, I can create all the possible KQL report queries for you to execute in Kayako Fusion/Resolve/Engage. Please read the private message for more details.

$350 AUD dalam 2 hari
(0 Ulasan)
0.0
tbldevelopment

We have a team of developers who specialize in C Programming and SQL. We can solve your project within the 2 weeks deadline.

$600 AUD dalam 14 hari
(0 Ulasan)
0.0
piyush417

Hi, I am familiar with SQL and Kayako Query Language and can create all possible report queries.

$400 AUD dalam 2 hari
(0 Ulasan)
0.0