Custom Reports - Two Category Conditions?

Custom Reports - Two Category Conditions?

by Shirley Gregorczyk -
Number of replies: 1
Picture of Particularly helpful Moodlers
Hello,
In SQL we can create statement for two conditions, "WHERE ccat.id = x and ccat.id = z".
Is this possible with the Custom Reports?
Or will it only accept one value for a condition?
Kind Regards
Average of ratings: -
In reply to Shirley Gregorczyk

Re: Custom Reports - Two Category Conditions?

by Paul Holden -
Picture of Core developers Picture of Moodle HQ Picture of Moodle Workplace team Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers Picture of Testers
Hi Shirley,

Currently the best you could do is using the existing categories condition with the "Include subcategories" option checked (of course, this assumes prior organisation of categories to match how you want to report on them):

Custom report condition

We have a similar request in the tracker at MDL-77305 (option for better boolean conditions of conditions) - perhaps add a comment there if it helps to add context - thanks!
Average of ratings:Useful (2)