I tried the solution mentioned above and It works very well for me. BUT I had to modify a little bit the code, this is the correct code:
$mods = get_fast_modinfo($this->_customdata['report']->courseid)->get_cms();
$modnames = get_module_types_names();
$modnamesplural = get_module_types_names(true);
$modnamesused = get_fast_modinfo($this->_customdata['report']->courseid)->get_used_module_names();
Hi,
I'll try to apply the fix and release a new version next week.
Juan
Thanks Juan,
I have it working with the fix I created - was that the right way to fix configurable reports?
My date filter is not doing anything to the data I can change to any date and it - can you look at my custom sql I created and tell me why the dates are not limiting my output?
result have all same date of 7-20-2016 no matter what I change my search date to like above which should be past 8/25 to 9/26
New at SQL and this is my best after many hours trialing solutions. Thanks.
ok, solved part of date issue as I pulled it from prefix_course instead of the logstore
I also see I need to join all 3 tables and I'm closer here but still not quite right as I get more users than were there.
Group by limits your data - grouping by date selected one user from each date, grouping by user selected one date for each user but using a comma lets me group specifically by the day for each user then order by is meant for sorting. I hope this helps someone
SELECT U.firstname, U.lastname, L.userid, L.courseid, L.action,
FROM_UNIXTIME( L.timecreated, '%m-%d-%Y' ) as DATE,
FROM_UNIXTIME( L.timecreated, '%r' ) as TIME
FROM prefix_logstore_standard_log as L
LEFT JOIN prefix_course as C ON L.courseid = C.id left JOIN prefix_user as U on L.userid = U.id
WHERE L.action LIKE '%Launched%'
AND L.courseid = %%COURSEID%%
%%FILTER_STARTTIME:L.timecreated:>%% %%FILTER_ENDTIME:L.timecreated:<%%
group by L.userid, FROM_UNIXTIME( L.timecreated, '%m-%d-%Y' )
order by FROM_UNIXTIME( L.timecreated, '%m-%d-%Y' ), U.firstname
Thanks Juan.
I think we'll all be very grateful if you fix and release a new versión.
Congrats for your great plugin.
Regards
HI Juan,
do you know if configurable reports can handle things like Declare SET Define as it throws errors for me when I try to use them. Any way around that?
I need to use it because I have one table that has the needed information but for some reason registers the course as course 0 when they click it in another course (blackboard collaborate for attendance) yet in the column other in prefix_logstore_standard_log I see the course number easily but I can't seem to query it out various ways as the %%course%% for some reason does not work using my sql below: (the ## I tried various ways without success when the course in my example is 108 so using AND L.other LIKE '%108%' works great but I'm trying to replace 108 with a variable or query instead to pull it out)
Thanks, Jamie
## DECLARE @CID
##SELECT @CID = D.id from prefix_course as D WHERE D.id = %%COURSEID%%
SELECT U.firstname as First, U.lastname as Last,L.userid, L.courseid,L.component,
FROM_UNIXTIME( L.timecreated, '%m-%d-%Y' ) as DATE,
FROM_UNIXTIME( L.timecreated, '%r' ) as TIME
FROM prefix_logstore_standard_log as L
LEFT JOIN prefix_course as C ON L.courseid = C.id left
JOIN prefix_user as U on L.userid = U.id
WHERE L.other like '%loadmeeting%'
AND L.component like '%mod_elluminate%'
## AND L.other LIKE @CID
## AND D.id = %%COURSEID%%
## WHERE L.courseid = %%COURSEID%%
##AND L.other LIKE '%108%'
## AND L.other LIKE Select %%COURSEID%%
## AND L.courseid = %%COURSEID%%
%%FILTER_STARTTIME:L.timecreated:>%%
%%FILTER_ENDTIME:L.timecreated:<%%
