Custom Reports - Two Category Conditions?

Custom Reports - Two Category Conditions?

Shirley Gregorczyk -
回帖数：1
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
平均分： -
回复Shirley Gregorczyk

Re: Custom Reports - Two Category Conditions?

Paul Holden -
Core developers的头像 Moodle HQ的头像 Moodle Workplace team的头像 Particularly helpful Moodlers的头像 Peer reviewers的头像 Plugin developers的头像 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!
平均分：Useful (2)