DataSet as a Ticker in Xibo 1.5.2 doesn't work
Hello Guys,
I created a simplу dataset with 4 columns as follows:
1) Date;
2) Time;
3) Booked;
4) Available;
added data and added a ticker in the system for the dataset. The problem - in the browser it shows error in preview as follows:
PHP Notice: The query [SELECT `Date` FROM ( SELECT `Date`, `Time`, `Booked`, `Available` , RowNumber FROM ( SELECT MAX(CASE WHEN DataSetColumnID = 1 THEN `Value` ELSE null END) AS `Date`, MAX(CASE WHEN DataSetColumnID = 2 THEN `Value` ELSE null END) AS `Time`, MAX(CASE WHEN DataSetColumnID = 3 THEN `Value` ELSE null END) AS `Booked`, MAX(CASE WHEN DataSetColumnID = 4 THEN `Value` ELSE null END) AS `Available`, RowNumber FROM ( SELECT datasetcolumn.
Any idea how one can fix it?
Thank you, Vlad.
Question information
- Language:
- English Edit question
- Status:
- Answered
- For:
- Xibo Edit question
- Assignee:
- No assignee Edit question
- Last query:
- Last reply:
Can you help with this problem?
Provide an answer of your own, or ask vvlads for more information if necessary.