We continue to see intermittent issues when we migrate a site from one server environment to another - where the configurable report instances make it over, but when you click on the SQL tab, there is nothing there.
When we look at the Moodle database table for configurable reports, we can see the sql logic is there - and we can manually send it through an HTML converter to get the logic out and then put it back into the SQL tab, but that sure is a lot of work.
Doesn't seem to be isolated to a particular Moodle version. I would say Moodle 3.2 or greater.
Do you have any thoughts as to why this would happen?
Thanks in advance.