I set up a database with the remote database. All the data is transmitted correctly. The only problem is that I can not use the dates in the date field as filters because I can not translate them into the appropriate date format.
fields I want to use as a date filter are
start_datetime "22.02.2018 18:30:00"
end_datetime “23.02.2018 08:30:00”
My second problem is that when I set the Truncate Dataset option on the remote tab database connection advanced tab on a Daily basis, She is not refreshing.
If you want to examine the example I created, the name is nobet_remote. If I need to give a password, I can share the CMS password with you.
Thank you.
The truncate option is bugged in 1.8.7. There’s already a bug logged for that and it will be fixed in 1.8.8.
For your date formatting, you simply need to change the date format that you compare to those fields. You can get the current date and time expressed in that format easily.
I’ve never tried with Xibo, but a random hacky way to overcome date format would be to use a view on the database with the fields formatted the way you wanted them as a sort of translator. For end user reports or exports in other frameworks, I use views almost exclusively so that I can have anything formatted or calculated how I want without breaking other front or back-end applications.
Thank you very much for your response. I am not a very good
programmer, so I guess this topic is a bit difficult. There is always
an easier and more practical way.
When I use the str_to_data function and compare it with NOW (), the
result is 1 or 0. I guess I should work more on it. Thanks again
I’ve had a screen that’s been working for a week.
At one point, the ticker region began to give the error message “unexpected
error please contact support”.
I tried to show the same information with Dataset module again I got the
same error.
I deleted the dataset table and recreated the problem was not resolved.
I’m sending the layout export file together.
I would really appreciate if you can help.the line I’m using for the filter
looks like this ilce_id=127 and STR_TO_DATE(nobet_baslangic_tarihsaat, ‘%d.%m.%Y
%H:%i:%S’) <=CURTIME() and STR_TO_DATE(nobet_bitis_tarihsaat, ‘%d.%m.%Y
%H:%i:%S’)>=CURTIME()