0
Undo
Votes
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.
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.