Thank you Robert! Now I have a complete playout report :)
mIRCea From: [email protected] [mailto:[email protected]] On Behalf Of Robert Orr Sent: 30 octombrie 2014 17:16 To: User discussion about the Rivendell Radio Automation System Subject: [RDD] Fwd: Custom Report (direct MySQL query) Here's a select statement: SELECT Production_SRT.EVENT_DATETIME, CART.ARTIST, CART.TITLE, Production_SRT.LENGTH, CART.COMPOSER, CART.LABEL, EXT_LENGTH FROM `Production_SRT` LEFT JOIN CART ON Production_SRT.CART_NUMBER = CART.NUMBER WHERE (Production_SRT.EVENT_DATETIME BETWEEN "2014-09-23 11:50:00" AND "2014-09-23 12:10:59") AND (CART.GROUP_NAME = "MUSIC"); On Tue, Oct 28, 2014 at 4:17 PM, Mircea Paun <[email protected] <mailto:[email protected]> > wrote: Hello, Somebody can help me with more customization mysql query ? I want to select by date (from .. to .. ) and I want to put one condition (event types) to have only music or traffic events in report. My actual query : --- mysql -u user -p pass Rivendell -B -e "select EVENT_DATETIME, ARTIST, TITLE, LENGTH, COMPOSER, PUBLISHER, LABEL, EXT_LENGTH from \`Production_SRT\` order by EVENT_DATETIME;" | sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g' > PLAYOUT_RIVE.csv --- Tanks! mIRCea _______________________________________________ Rivendell-dev mailing list [email protected] <mailto:[email protected]> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
_______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
