{"id":"https://openalex.org/W7223220019","doi":"https://doi.org/10.5445/ir/1000198291","title":"SQL reports - struggles and strategies - Creating self paced learning tools for SQL reports in Koha","display_name":"SQL reports - struggles and strategies - Creating self paced learning tools for SQL reports in Koha","publication_year":2026,"publication_date":"2026-10-22","ids":{"openalex":"https://openalex.org/W7223220019","doi":"https://doi.org/10.5445/ir/1000198291"},"language":"en","primary_location":{"id":"doi:10.5445/ir/1000198291","doi":"https://doi.org/10.5445/ir/1000198291","is_oa":true,"landing_page_url":"https://doi.org/10.5445/ir/1000198291","pdf_url":null,"source":{"id":"https://openalex.org/S7407052948","display_name":"KITopen","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I102335020","host_organization_name":"Karlsruhe Institute of Technology","host_organization_lineage":["https://openalex.org/I102335020"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Audiovisual"},"volume":null,"type":"other","is_traditional":false,"indexed_in":["datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://doi.org/10.5445/ir/1000198291","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5159283543","display_name":"KIT-Bibliothek","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"KIT-Bibliothek","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5159287751","display_name":"Holly Cooper","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Cooper, Holly","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T14496","display_name":"Educational Technology and E-Learning","score":0.2847000062465668,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T14496","display_name":"Educational Technology and E-Learning","score":0.2847000062465668,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T12171","display_name":"Open Education and E-Learning","score":0.12039999663829803,"subfield":{"id":"https://openalex.org/subfields/3304","display_name":"Education"},"field":{"id":"https://openalex.org/fields/33","display_name":"Social Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10712","display_name":"Library Science and Information Literacy","score":0.11729999631643295,"subfield":{"id":"https://openalex.org/subfields/3309","display_name":"Library and Information Sciences"},"field":{"id":"https://openalex.org/fields/33","display_name":"Social Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/koha","display_name":"Koha","score":0.7620000243186951},{"id":"https://openalex.org/keywords/self-paced-learning","display_name":"self-paced learning","score":0.9520000219345093},{"id":"https://openalex.org/keywords/library-staff-training","display_name":"library staff training","score":0.9369999766349792},{"id":"https://openalex.org/keywords/library-automation","display_name":"library automation","score":0.7609999775886536},{"id":"https://openalex.org/keywords/learning-resources","display_name":"learning resources","score":0.4300000071525574},{"id":"https://openalex.org/keywords/user-feedback","display_name":"user feedback","score":0.3490000069141388},{"id":"https://openalex.org/keywords/library-management-systems","display_name":"library management systems","score":0.3230000138282776}],"concepts":[{"id":"https://openalex.org/C4438859","wikidata":"https://www.wikidata.org/wiki/Q186117","display_name":"Timeline","level":2,"score":0.8237000107765198},{"id":"https://openalex.org/C2777601897","wikidata":"https://www.wikidata.org/wiki/Q3409113","display_name":"Presentation (obstetrics)","level":2,"score":0.7858999967575073},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7361999750137329},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6280999779701233},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.5335000157356262},{"id":"https://openalex.org/C2984286706","wikidata":"https://www.wikidata.org/wiki/Q400708","display_name":"Sql server","level":2,"score":0.5181999802589417},{"id":"https://openalex.org/C2780428219","wikidata":"https://www.wikidata.org/wiki/Q16952335","display_name":"Cover (algebra)","level":2,"score":0.4133000075817108},{"id":"https://openalex.org/C206345919","wikidata":"https://www.wikidata.org/wiki/Q20380951","display_name":"Resource (disambiguation)","level":2,"score":0.3276999890804291},{"id":"https://openalex.org/C114724005","wikidata":"https://www.wikidata.org/wiki/Q5001740","display_name":"Business Intelligence Markup Language","level":5,"score":0.3197999894618988},{"id":"https://openalex.org/C49774154","wikidata":"https://www.wikidata.org/wiki/Q131765","display_name":"Multimedia","level":1,"score":0.29899999499320984},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.29319998621940613},{"id":"https://openalex.org/C2985584371","wikidata":"https://www.wikidata.org/wiki/Q215121","display_name":"Data presentation","level":3,"score":0.2867000102996826},{"id":"https://openalex.org/C179531526","wikidata":"https://www.wikidata.org/wiki/Q595637","display_name":"Language Integrated Query","level":5,"score":0.2727999985218048},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.2712000012397766},{"id":"https://openalex.org/C18762648","wikidata":"https://www.wikidata.org/wiki/Q42213","display_name":"Work (physics)","level":2,"score":0.2639999985694885},{"id":"https://openalex.org/C144559511","wikidata":"https://www.wikidata.org/wiki/Q2986279","display_name":"Principal (computer security)","level":2,"score":0.2556000053882599}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.5445/ir/1000198291","doi":"https://doi.org/10.5445/ir/1000198291","is_oa":true,"landing_page_url":"https://doi.org/10.5445/ir/1000198291","pdf_url":null,"source":{"id":"https://openalex.org/S7407052948","display_name":"KITopen","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I102335020","host_organization_name":"Karlsruhe Institute of Technology","host_organization_lineage":["https://openalex.org/I102335020"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Audiovisual"}],"best_oa_location":{"id":"doi:10.5445/ir/1000198291","doi":"https://doi.org/10.5445/ir/1000198291","is_oa":true,"landing_page_url":"https://doi.org/10.5445/ir/1000198291","pdf_url":null,"source":{"id":"https://openalex.org/S7407052948","display_name":"KITopen","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I102335020","host_organization_name":"Karlsruhe Institute of Technology","host_organization_lineage":["https://openalex.org/I102335020"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Audiovisual"},"sustainable_development_goals":[{"score":0.7567999958992004,"id":"https://metadata.un.org/sdg/4","display_name":"Quality education"}],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W7071703273","https://openalex.org/W7132283577","https://openalex.org/W2343282127","https://openalex.org/W2534674944","https://openalex.org/W4401879167","https://openalex.org/W7171813245","https://openalex.org/W7024622816","https://openalex.org/W4238866355","https://openalex.org/W3119970207","https://openalex.org/W4243567395"],"abstract_inverted_index":{"This":[0,57],"presentation":[1,28,58],"will":[2,29,59],"describe":[3,44],"the":[4,31,35,38,45,50,63,67],"experience":[5],"of":[6,40,62,72],"creating":[7],"a":[8,70],"self":[9],"paced":[10],"learning":[11],"programme":[12],"intended":[13],"to":[14,19,48],"teach":[15],"library":[16],"staff":[17],"how":[18,73],"create":[20,49],"and":[21,52,69],"edit":[22],"SQL":[23],"reports":[24],"in":[25],"Koha.":[26],"The":[27],"cover":[30],"initial":[32],"inspiration":[33],"for":[34,54,66],"module,":[36],"defend":[37],"necessity":[39],"such":[41],"an":[42],"approach,":[43],"tools":[46],"used":[47],"resources":[51,64],"plans":[53],"future":[55],"expansion.":[56],"include":[60],"examples":[61],"created":[65],"module":[68],"timeline":[71],"they":[74],"have":[75],"changed":[76],"through":[77],"feedback":[78],"from":[79],"our":[80],"clients.":[81]},"counts_by_year":[],"updated_date":"2026-10-24T09:50:30.924529","created_date":"2026-10-23T00:00:00"}