ssumgirl
Posts: 186
Score: 0
Joined: 11/24/2004
Status: offline
|
Hi all. For history and audit purposes, we have to save all of our advertisements for a year or so and we normally expire them and move them to one of a number of folders in the console (depending on the advert). Problem is sometimes our guys will forget to expire or expire incorrectly, and maybe move to the wrong folde - then when we discover something is pushing that we were not expecting its a bit of a panic to find the advertisement to shut it off. Does anyone have a query that will list only advertisements that are active now, and the folder they exit in in the console? I took a look at the v_advertisement table and some of that is obvious, but when it comes to figuring out how to link to the table or tables that determine console/folder location I was lost.
|
Printable Version
query to list only active advertisments and console loc... - 
New Messages
No New Messages
Hot Topic w/ New Messages
Hot Topic w/o New Messages
Locked w/ New Messages
Locked w/o New Messages
Post New Thread