Hello,
I have been struggling to create the proper SQL statement to create a valid URL.
I have tried several variations and reached out to the Moodle community.
The statement below results in a plain text with [site www], course fullname
CONCAT('%%WWWROOT%%/course/view.php%%c%%id=',c.fullname) AS "Link",
Can someone please provide me with the proper SQL statement for a course URL?
Kind Regards

Hello Shirley,
There may be a more succinct way but the following should work. You must create one column 'X' and then a second column with a title like 'X_link_url'. When the report is run it will combine both into one column.
Here is an example that will print the course title and the hyperlink will take you to the course:

SELECT
c.fullname as course_name,
CONCAT('%%WWWROOT%%/course/view.php',CHAR(63),'id=',c.id) as course_name_link_url
FROM prefix_course c

Hope this helps.

Hello Remmington,
Thank you!!!!
While this solution is written in the Notes section of the plugin, my attempts did not correctly write the statement. I over thought the instruction.
Kind Regards,
Shirley

Hi,
I don’t know anything about SQL but desperately need a report that collect data about both course completion and information from two feedback activities.
Can someone help me out?
/Niklas

Hi,
When I've tried a complex query for just 1000 row, plugins works perfectly, but when I increased to 30K, I just got blank row.
But when I tried a simple query (only 3 field), got 30K perfectly.
What should I do ?

Regards,

When you are getting a blank page, try turning on Debugging to see an error message.

I guess that if the query is too big, then the server will run out of memeory. (But, that is just a guess.)

I'm seeking further documentation on the Ad-Hoc Queries plugin for Moodle. Specifically, it seems to allow for some non-standard SQL functions such as %%FILTER_USER%%, and I've heard rumors one can use statements like "u.id=:userid" to prompt for run-time entry of parameters. Where can I find those capabilities and their syntax documented? The Moodle Docs entry for this plugin doesn't include any of those details, nor does it provides link to them that I can find.

I think %%FILTER_USER%% is a feature of https://moodle.org/plugins/block_configurable_reports, not this plugin.

"u.id=:userid" works for this report. There is a "More documentation on this plugin" link above. Also, when you are editing a query, there is a lot of information on the screen about what you can do.

Hi Tim, is this plugin compatible with 4.1, 4.2 and 4.3?
Will it be?
Best,
Fabian

Hi Tim,
Thank you for building this plugin. It really is a great tool and it's easy to use. In an attempt to contribute what little I can to the ongoing development of this project - I found a little update to one of the reports I can share.

As written on https://docs.moodle.org/403/en/ad-hoc_contributed_reports - There is outdated table name reference in the report "User activity completions with dates"
Moodle used to have a module called 'assignment' which has since been replaced by 'assign'. Once that table reference is renamed everything else works fine

Apologies if if this isnt the appropriate place to share this, but I couldnt find anywhere else to put this. I hope this helps keep the project fresh, and once again thanks for your effort here. Cheers!

Thanks for thinking of contributing back. docs.moodle.org is a wiki. You can edit it yourself

Hi Tim,

Could you please advise if this plugin will be compatible with 4.1, 4.2 and 4.3?

Best,
Hoda

Hi Tim,
Sorry to bother, but I see the plugin it compatible only up to Moodle 4.0. Is it compatible with Moodle 4.3?

The latest code in github works with 4.3. (I am working to publish the latest code here too, but there are only so many hours in each day.)

Thank you Tim!