DataSet as a Ticker in Xibo 1.5.2 doesn't work

Asked by vvlads

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.DataSetColumnID, datasetdata.RowNumber, datasetdata.`Value` FROM datasetdata INNER JOIN datasetcolumn ON datasetcolumn.DataSetColumnID = datasetdata.DataSetColumnID WHERE datasetcolumn.DataSetID = 1 ) datasetdatainner GROUP BY RowNumber ) datasetdata ) finalselect ORDER BY `1`] failed to execute. Unknown column '1' in 'order clause' in C:\Users\Public\Work\websites\signatact.com.root\xibo.signatact.com\lib\data\dataset.data.class.php on line 321

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:
Revision history for this message
Dan Garner (dangarner) said :
#1

Try using the column name in the order by clause on the data set view.

Can you help with this problem?

Provide an answer of your own, or ask vvlads for more information if necessary.

To post a message you must log in.