Attention!

These forums are not monitored. We provide the discussions forum as a place for users of free extensions to help each other and find answers, not as a place for our staff to deal with urgent support issues. Our staff very rarely responds to forum posts. Occasionally we will respond to forum posts but responses are not guaranteed.

If you have an active subscription for a commercial extension and wish to receive support please login to your Artetics.com account and submit a ticket. The ticketing system is the best way for you to get assistance in a timely manner.

Thank you!

  Monday, 22 February 2021
  1 Replies
  112 Visits
0
Votes
Undo
Hello,
I have just bought Art Data, and I try to create a Dynamic Table Visualization .
In the Data section,, I wrote a SQL query :

SELECT start_date AS 'Arrivée',last_name AS 'Nom',total,MONTH(start_date) AS 'Mois',adults AS 'Adultes'
FROM w4tfs_hotelreservation_confirmations
WHERE
reservation_status > "2" AND w4tfs_hotelreservation_confirmations.state_name > "2" AND MONTH(start_date) = MONTH(CURDATE())-1
ORDER BY start_date

When I click on "Preview", I get a blank screen...
Idem when I click on the menu which points to ArtData Visualization.

Thank you for your help.