Bug 38660

Summary: Add pointers to reports documentation for LIMIT functions
Product: Koha Reporter: hebah
Component: DocumentationAssignee: Bugs List <koha-bugs>
Status: Needs documenting --- QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low CC: aude.charillon, philip.orr
Version: Main   
Hardware: All   
OS: All   
GIT URL: Change sponsored?: ---
Patch complexity: --- Documentation contact:
Documentation submission: Text to go in the release notes:
Version(s) released in:
Circulation function:

Description hebah 2024-12-09 22:19:11 UTC
The Koha manual has some great report documentation, but clarifying that using LIMIT with a batch of results will default results to that many displayed AND send that batch through to batch modification would be a great pointer for librarians interested in unlocking report potential but put off by the idea of having to expand their results past the initial 20 each time. 

The fix in bug 36534 makes this a bit clearer by indicating the number of results to be acted on, but it would be nice to have that suggested somewhere in the documentation so that a librarian new to report writing can find it, especially since many report writers come to SQL as librarians first, not always with a database background beyond what they pick up on the job for report creation.

A logical place for this might be within the SQL Report writing tips section. One place might be in the section for #send-report-output-to-batch-modification-tools. Or earlier in the section, under Runtime parameters as a note/example. Open to further suggestion.
Comment 1 Aude Charillon 2024-12-10 13:30:02 UTC
That would be a great tip to have in the Manual - thank you for logging it :)