Contact Us Today! | vcare@wdmtech.com

WDMtech

Topic-icon SQL Query partly dissapears after opening

More
08 Feb 2017 14:06 #3799

Hello,
Have you not received the Email with new package? Now part of the query won't disappear, This issue has been corrected in this package.


Thanks
Daniel

Please Log in or Create an account to join the conversation.

  • Vladimir Kocic
  • Vladimir Kocic's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
08 Feb 2017 13:39 #3798

Mr. Daniel, I can assure you that below that query are the table structures, complete with their titles. I have pasted them in, and I saw them in the message when I sent the form.
However, I am sending you once more the structures:

CREATE TABLE dipendenti.calendar (
  id INT(11) NOT NULL AUTO_INCREMENT,
  datefield DATE NOT NULL,
  PRIMARY KEY (id)
)
ENGINE = INNODB
AUTO_INCREMENT = 14246
AVG_ROW_LENGTH = 28
CHARACTER SET latin1
COLLATE latin1_swedish_ci
ROW_FORMAT = DYNAMIC;

This is the view (used by the query) called statistica_assunti_n:
SELECT
  `calendar`.`datefield` AS `data_assunzioni`,
  IFNULL(COUNT(`datipersonali`.`con_inizio_contratto`), 0) AS `assunzioni`
FROM (`calendar`
  LEFT JOIN `datipersonali`
    ON ((CAST(`datipersonali`.`con_inizio_contratto` AS date) = `calendar`.`datefield`)))
WHERE (`calendar`.`datefield` <= CAST(NOW() AS date))
GROUP BY `calendar`.`datefield`

This is a view (used by the query) called statistica_licenziati_n:
SELECT
  `calendar`.`datefield` AS `data_licenziamenti`,
  IFNULL(COUNT(`datipersonali`.`con_licenziamento_data`), 0) AS `licenziamenti`
FROM (`calendar`
  LEFT JOIN `datipersonali`
    ON ((CAST(`datipersonali`.`con_licenziamento_data` AS date) = `calendar`.`datefield`)))
WHERE (`calendar`.`datefield` <= CAST(NOW() AS date))
GROUP BY `calendar`.`datefield`

Last Edit: 08 Feb 2017 13:40 by Vladimir Kocic.

Please Log in or Create an account to join the conversation.

More
08 Feb 2017 11:51 #3796

You have sent the query only, I asked you to sent the structure of all the tables used in Query.


Thanks
Daniel

Please Log in or Create an account to join the conversation.

  • Vladimir Kocic
  • Vladimir Kocic's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
08 Feb 2017 10:24 #3795

it is sent, thank you.

Please Log in or Create an account to join the conversation.

More
08 Feb 2017 09:20 #3792

Please send structure of all the tables used in the Query via Contact us form.


Thanks
Daniel

Please Log in or Create an account to join the conversation.

  • Vladimir Kocic
  • Vladimir Kocic's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
08 Feb 2017 07:58 #3789

Unfortunately, I can't because it is behind company LAN.
I can send you files that you need, if that helps.

Please Log in or Create an account to join the conversation.

More
08 Feb 2017 06:03 #3786

Hello,
Please share your backend & FTP login credentials via Contact us form, We'll look into it.


Thanks
Daniel

Please Log in or Create an account to join the conversation.

  • Vladimir Kocic
  • Vladimir Kocic's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
07 Feb 2017 16:06 #3782

As you can see, when I paste the query and save the chart, it is saved. But when I open it for editing, a portion of the query disappears, and I have to copy-paste it every time.



What do I do?

Attachments:

Please Log in or Create an account to join the conversation.