Hello,
I am implementing Kitchen display for my store where I need to display last 8 tickets with items, void and other details. What would be the SQL query to retrieve this data?
My idea is running a python web server on a back office computer where MS SQL Server is running. Web Server will process incoming request, execute SQL query to retrieve recent 8 tickets details and return data in a formated HTML page.
Client (Raspberry Pi) will be accessing web page and refresh every 1 minute.
Thanks,
DQ
