Thanks, that's helpful. I couldn't find what I wanted all in one table, so I looked at the source code for creating reports, and I found a mysql command for pulling data from multiple tables at once. I think I can do something with this.
>From rdreport.cpp: ...left join CART on `%s_SRT`.CART_NUMBER=CART.NUMBER... Greg Avedissian On 04/15/2016 11:56 AM, Mike Carroll wrote: > I don't have an answer, but the /docs folder on GitHub has text files that > describe the Rivendell tables. Maybe that'll give you a lead. > > https://github.com/ElvishArtisan/rivendell/tree/master/docs/tables > > Mike C > > On Fri, Apr 15, 2016 at 8:42 AM Gregory Avedissian <[email protected]> > wrote: > >> I know this has been asked before, but I'm hoping to get a different >> answer. Is it possible to modify the format of reports? I'd like something >> that's more or less a cross between Spin Count and Technical report. >> >> What we need is the total time for each cart played in the past year. I >> want to pull that data out each day and keep a running total. Right now, >> someone is printing the Technical Report and adding the times up with >> pencil and paper. >> >> I've been mucking around in the database with mysql commands and >> mysql-workbench, but I haven't found where that information is stored. >> Where do the reports get their data for what was played, start and end >> times? Is there a guide to the database that tells what information is in >> which columns or tables? >> >> >> Greg Avedissian >> _______________________________________________ >> Rivendell-dev mailing list >> [email protected] >> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev >> > > > > _______________________________________________ > Rivendell-dev mailing list > [email protected] > http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev > _______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
