I have a very simple SQL report as follows:
SELECT c.shortname, c.category, cc.id, cc.name
FROM prefix_course AS c
JOIN prefix_course_categories AS cc ON cc.id = c.category
WHERE
c.visible = 1
%%FILTER_CATEGORIES:cc.id%%
The report works, but when I view the report, the pull-down menu does not show all the category names. All categories with cc.id > 99 do not show. I've looked through the code, but I can't find any reason for this limit. Does anyone know what might be causing this, and how to work around it? I filed CONTRIB-4322 but there has been no response yet.
This is a problem for us because we use categories to group courses by term, and now I have to manually create new versions of all our reports every term, because the current term category is beyond the category id cutoff.