WhiteRider wrote:Yeah, you can't currently list the notes associated with a tournament, or any other item that can have notes (as far as I know, anyway - Kraada may be able to come up with a cunning way to access it as we learn more about the database, but I don't think so - the report will list tournaments, and since each tournament can have multiple notes that doesn't fit).
perhaps perhaps kraada can figure out how to clean this up below and suggest the optimal solution:
1) it's pretty easy in sql - it's just a simple join - though i'd have to bone up on my sql unfortunately.1
need to join tourney_holdem_summary to notes via the tourney_holdem_summary.tourney_no to notes.id_x fields.
once joined this lets you grab the right entries. Would be trivial for instance if I dumped the tables to MS access
2) Or, it's an easy function to write -in quasi code you would need a function that does basically this:
For each tourney_holdem_summary.id
- get notes.notes where
--tourney_holdem_summary.flag_note= true <---there is a note on that tny
--notes.id_x = tourney_holdem_summary.tourney_no <-----links tourney to note file
--notes.enum_typ="THS" <--------THS flags summary level, THH flags hand level