Hello,

I create an issue based on this github issue : https://github.com/jleyva/moodle-block_configurablereports/issues/172

I found two different use cases to avoid getting categories whose id is made up of another id (example with id 1 : id 10, id 11, id 111) :

• if the selected category is a top parent category : the sql clause should filter on '/id/%' OR '/id' (if the top parent category is a leaf of the category tree)
• if the selected category is a sub category : the sql clause should filter on '%/id/%' OR '%/id' (if the sub category is a leaf of the category tree)

I will submit a pull request with this tested solution as soon as possible.