when retired media ..

If your retiring media then all that does is set a flag in the database on that media record that marks it as retired. Nothing is actually deleted.

It's not possible for us to guess why your own query doesn't work if you don't tell us what query your running and how you're deleting three media.

Alex

This email carries a disclaimer, a copy of which may be read at http://learning.longhill.org.uk/disclaimer

I saw the problem .. my query was an easy like this

select media.name,min(stat.start),max(stat.start),count(media.mediaID) from stat
left join media on media.mediaID = stat.mediaID
left join layout on layout.layoutID = stat.layoutID

where stat.type = 'Media'
and stat.layoutId = 7
and media.name like '%TS%'

and stat.start >= '2553-03-15 00:00:00'
and stat.start <='2553-03-16 00:00:00'

Group By media.mediaID
Order By stat.start,media.mediaID

I used this last month it 's OK , but for this month is not .. I delete media from library menu and what i saw are some media when i click delete will show "delete this media" some media show "retire this media" ..

what 's a different ???

It depends on whether the media iss still in use in a layout.

Alex

kthamma <email address hidden> wrote:

Question #106253 on Xibo changed:
https://answers.launchpad.net/xibo/+question/106253

    Status: Answered => Open

kthamma is still having a problem:
I saw the problem .. my query was an easy like this

select media.name,min(stat.start),max(stat.start),count(media.mediaID)
from stat
left join media on media.mediaID = stat.mediaID
left join layout on layout.layoutID = stat.layoutID

where stat.type = 'Media'
and stat.layoutId = 7
and media.name like '%TS%'

and stat.start >= '2553-03-15 00:00:00'
and stat.start <='2553-03-16 00:00:00'

Group By media.mediaID
Order By stat.start,media.mediaID

I used this last month it 's OK , but for this month is not .. I delete
media from library menu and what i saw are some media when i click delete
will show "delete this media" some media show "retire this media" ..

what 's a different ???

--
You received this question notification because you are a member of Xibo
Developers, which is an answer contact for Xibo.

This email carries a disclaimer, a copy of which may be read at http://learning.longhill.org.uk/disclaimer

Deleting the media will remove all references and you will no longer be able
to view stats for that media record - you can only delete media that is not
in use on a layout (as Alex said).

Retiring the media will leave the media in the library but hide it from view
- you will still be able to view stats for that retired media records.