Koha-US / Learn - Reports

Resources: https://will1410.github.io/presentations/very.very.basic.sql.html

Chat logs:
02:01:20 Jason: George's resources: https://bit.ly/2XUzZu3
02:12:55 Jason Vasche (RRPL): sorry if you mentioned this and I missed it... w3schools offers tutorials for SQL and MySQL. Which one would be more appropriate for Koha?
02:15:34 Daniel Gaghan (PPLD): MYSQL
02:23:13 Bruce Metcalf: Between is inclusive by definition?
02:24:05 Wally DesChamps: I noticed some lines are indented...is there a specific amount of space that is required?
02:24:36 Bruce Metcalf: can time stamps be truncated to 8 digits?
02:28:08 Daniel Gaghan (PPLD): Sounds like the stuff of nightmares
02:28:16 Rebecca Coert: Yay for Tabs!
02:28:51 Christopher Brannon: George, is it possible to add comments to SQL?
02:28:59 Daniel Gaghan (PPLD): Probably getting ahead of myself but do you know of any Koha database schemes that conflict when joined?
02:29:20 Christopher Brannon: Comments are always good
02:32:24 Wally DesChamps: Can a constraint use "contains" "x"
02:33:16 Christopher Brannon: parentheses are helpful when using OR in combination with other conditions
02:36:31 Christopher Brannon: Wally, using LIKE "%x%" would be an appropriate way to do something like what you are asking, rather than contains.
02:44:24 Victoria: Is it possible to create a report where some item field is not blank? (For ex. Non-public note is not blank)
02:47:42 Victoria: yes, thank you so much!
02:53:01 Jason Vasche (RRPL): is the default JOIN value LEFT JOIN?
02:53:56 Jason Vasche (RRPL): to clarify... looking at the helpful diagrams, what would plain JOIN represent?
02:54:16 Jason Vasche (RRPL): thanks
02:55:36 Bruce Metcalf: Yes, very basic, but exactly what I need to get started. Thanks!
02:55:53 Wally DesChamps: This was perfect!!!
02:55:57 Jason Vasche (RRPL): thank you very much
02:55:58 Rebecca Coert: It was basic, but I still learned a lot! Wish I had this workshop a year ago :)
02:56:04 Ashley Johnson: Very helpful for a newbie!
02:56:07 Victoria: Thank you!
02:56:09 Sheila Taylor: Thank you!
02:56:32 Victor Zuniga: Great presentation. Joins tend to be a key component when pulling data from multiple tables. Thanks!

Slides: https://docs.google.com/presentation/d/1SDpTD9DuL4sgxA8lMDJ3BzUGl2TTjtENq3acMUby8-A/edit?usp=sharing

Chat logs: https://drive.google.com/a/koha-us.org/file/d/1Ux_NeHun80rX5VzTNfmo4NRUeiPJ4qA4/view?usp=sharing

For more information about this feature, https://bywatersolutions.com/education/creating-graphs-in-the-reporting-module

How to add a report to your Koha system from the Koha Community Wiki page.

How to create a report in Koha to allows library to select all branches in their SQL