This description may change but I put Terms Tagged - Rolled Up as working title - could be Terms Tagged - Compiled or something like that. The important thing for now is to put in the output. This report is one that your author believes could end up being helpful. This is based on user-requested ad-hoc reports generated using direct database connection to the read-only MySQL database instance.
There are two other versions of this report that may end up being the preferred one. I am placing my gut instinct on this one though to start.
Clearly this is using an outer join (left outer) because I wanted to return sessions and courses that do not necessarily have any terms directly associated with them at their level. session_x_term - session level or course_x_term - course level.
Output fields described ...
- Course title
- Course terms - this refers to terms contained and referenced by the ID in
course_x_term - if none, show course anyway just leave course terms blank and display session info
- Session title
- Session terms - like courses terms, if blank leave blank - if values > 1 item, roll them up into one field - I used
GROUP_CONCAT in SQL.
- URL link to course and session
I used CONCAT to combine Vocabulary with Term in the output - and I just realized i had some duplicates in Ground School - I usually end up having to clean this up a bit more and I would do so in this case since I just noticed the issue. Ground School has two course terms so it probably ran through the session terms group concat logic twice as a result - I often have to clean this up manually.
This description may change but I put
Terms Tagged - Rolled Upas working title - could beTerms Tagged - Compiledor something like that. The important thing for now is to put in the output. This report is one that your author believes could end up being helpful. This is based on user-requested ad-hoc reports generated using direct database connection to the read-only MySQL database instance.There are two other versions of this report that may end up being the preferred one. I am placing my gut instinct on this one though to start.
Clearly this is using an outer join (left outer) because I wanted to return sessions and courses that do not necessarily have any terms directly associated with them at their level.
session_x_term- session level orcourse_x_term- course level.Output fields described ...
course_x_term- if none, show course anyway just leave course terms blank and display session infoGROUP_CONCATin SQL.I used
CONCATto combine Vocabulary with Term in the output - and I just realized i had some duplicates in Ground School - I usually end up having to clean this up a bit more and I would do so in this case since I just noticed the issue. Ground School has two course terms so it probably ran through the session terms group concat logic twice as a result - I often have to clean this up manually.