Hi,
I created a sql report like :
http://docs.moodle.org/24/en/ad-hoc_contributed_reports?#Learner_report_by_Learner_with_grades.
I created filters to facilitate my search.
And I added these filters in the SQL report
So the filters c1 and c2 works very well but I don't know what filter can i use for the c3.
That's the result of the report :
If one of you can help me, i will be very gratefull.
Thanks
Anthony
anybody can help me ? please.
Have you tried %%FILTER_USERS:u.lastname%% ?
thank you for you answer but it doesn't works
When I search a user, I always have "no record found"
When you first posted, was the problem that the filter did absolutely nothing? Or has it always returned "No record found?"
Can you post your SQL query so I can take a closer look at it?
It's always returns "No record found" but there is.
I attached the sql query
It appears that "FILTER_USERS" doesn't work for the drop-down user field search. I changed "%%FILTER_USERS:" in lines 55 and 57 of configurable_reports/components/filters/fuserfield/plugin.class.php to "%%FILTER_USERSDD:"
Then in my SQL statement, I wrote:
%%FILTER_USERSDD:u.lastname%%
That fixed it for me.
Hi kimber,
Thank you very much for your answer.
As you, i read the answer from peter. With your instructions you gave in the thread, i solved my problem.
I'm very grateful for your help
Cheers,
Anthony
