Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 05/09/2017 BIG Autumn SALE

    Use AUTUMN17 coupon code to buy our WordPress or Joomla! extensions with 25% discount. Hurry up! The offer is valid till 11 September.

  • 14/04/2017 Happy Easter

    Wish a Happy Easter and give 30% discount for all our WordPress and Joomla! extensions. Use EASTER17 coupon code. The offer is valid till 17 April.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

[SOLVED] Help, stuck on a basic SQL query
(1 viewing) (1) Guest
Go to bottomPage: 12
TOPIC: [SOLVED] Help, stuck on a basic SQL query
#58433
[SOLVED] Help, stuck on a basic SQL query 1 Year, 1 Month ago Karma: 0
Hello.
Can you please point me to some documentation on how to use this plugin?
I bought it to use it almost exclusively for MySQL, and I can't seem to get any heads or tails on how to use it.
This is what I get as a graph:
https://s11.postimg.org/cuh266tdb/Capture.jpg[/img]

I used this query with another free plugin (plotalot) and it worked the way it was supposed to:
Code:

SELECT  
CONCAT(year(calendar.datefield),'-', LPAD(month(calendar.datefield), 2, '0')) AS ymonth,
  IFNULL(count(con_inizio_contratto),0) AS assunti,
  year(calendar.datefield) AS anno,
        month(calendar.datefield) AS mese,
       
        IFNULL(count(con_licenziamento_data),0) AS licenziati
FROM datipersonali RIGHT JOIN calendar ON (DATE(datipersonali.con_inizio_contratto) = calendar.datefield)
WHERE (calendar.datefield BETWEEN 
  (SELECT MIN(DATE(datipersonali.con_inizio_contratto)) FROM datipersonali) 
  AND 
  (SELECT MAX(DATE(datipersonali.con_inizio_contratto)) FROM datipersonali))
GROUP BY year(calendar.datefield), month(calendar.datefield), ymonth



This is what I am supposed to get:
https://s21.postimg.org/8w0uk5tsj/Capture2.jpg[/img]

Please help me!
Last Edit: 2016/09/08 04:10 By vladimir84.
The administrator has disabled public write access.
 
#58434
Re:Help, stuck on a basic SQL query 1 Year, 1 Month ago Karma: 667
Hello,

Set "Choose source type -> SQL -> Revert data" parameter to "Yes".

Regards,
ARI Soft
The administrator has disabled public write access.
 
#58435
Re:Help, stuck on a basic SQL query 1 Year, 1 Month ago Karma: 0
Thank you for the quick reply. Unfortunately, now it gives me this:

It doesn't hide the year and month column (in spite of the fact it was selected as hidden here:), and I have to have them in the query in order to sort the data.

Please tell me how to fix it.
The administrator has disabled public write access.
 
#58436
Re:Help, stuck on a basic SQL query 1 Year, 1 Month ago Karma: 667
Could you provide a link to a page with the chart?

Regards,
ARI Soft
The administrator has disabled public write access.
 
#58437
Re:Help, stuck on a basic SQL query 1 Year, 1 Month ago Karma: 0
unfortunately no, it is inside the LAN. But I did save the whole webpage, and I am attaching it here:
File Attachment:
File Name: Desktop-34e43c7118541f4995ce42d1656fd416.zip
File Size: 518439
The administrator has disabled public write access.
 
#58438
Re:Help, stuck on a basic SQL query 1 Year, 1 Month ago Karma: 0
Last Edit: 2016/09/08 08:57 By vladimir84.
The administrator has disabled public write access.
 
Go to topPage: 12