Do not show Tickets in the schedule screen when they are either in th…

…e Trash or in the Clipboard. Fixes bug #12345.
plainblack · May 27, 2012 · 45d7c55 · 45d7c55
1 parent ee783e7
commit 45d7c55
Show file tree

Hide file tree

Showing 2 changed files with 2 additions and 0 deletions.
diff --git a/docs/changelog/7.x.x.txt b/docs/changelog/7.x.x.txt
@@ -15,6 +15,7 @@
  - fixed #12349: Friends invitation error
  - fixed #12353: Dataform List mode
  - fixed #12364: Site export loses session info
+ - fixed #12345: tickets in trash still show up
 
 7.10.24
  - fixed #12318: asset error causes asset manager to fail

diff --git a/lib/WebGUI/Asset/Wobject/EventManagementSystem.pm b/lib/WebGUI/Asset/Wobject/EventManagementSystem.pm
@@ -1792,6 +1792,7 @@ sub www_getScheduleDataJSON {
                  and EMSTicket.location in (  } . 
 		         join( ',', (map { $db->quote($_) } (@ticketLocations))) .
 			 q{ )
+                 and asset.state='published'
                  and assetData.revisionDate = (
                            select max(revisionDate)
                              from assetData