Xibo

Delete display from panel

Asked by Bartek

Hi,

I was wondering recently, why there is no friendly way to delete old unused displays from panel. I've ~10 old displays in list, those were used only for testing when i've started to deploy Xibo. Those are unlicensed but still used in list sorting by name, id, etc.

Is there any important reason or it's becouse unimpelemted relations with stats and some other table to keep database consistent?
Maybe its quite simple to remove such old displays by some mysql tricks, like delete from stats where id=... etc?

Question information

Language:
English Edit question
Status:
Solved
For:
Xibo Edit question
Assignee:
No assignee Edit question
Solved by:
Dan Garner
Solved:
Last query:
Last reply:
Revision history for this message
Best Dan Garner (dangarner) said : 		#1

The primary key in the display tables is a foreign key in quite a few other tables which makes a display a tricky thing to delete. A display has:
 - A default layout
 - A historical schedule
 - Log entries
 - Statistics entries

And in 1.1 is also has:
 - User group security
 - A display group

The 1.1 series of code will have a delete button for displays which will delete a display in most circumstances! Perhaps we also need an option to retire a display.

If you did want to delete your displays directly from MySQL then this is certainly possible (tables with foreign keys: schedule_detail, log, stat) - but do so at your own risk :-)

Revision history for this message
Bartek (czajka) said : 		#2

Thanks Dan Garner, that solved my question.