Filter for user full name

Filter for user full name

by Zeid Fanous -
Number of replies: 1

Hi Everyone smile, 


I am currently using Moodle 2.9 and Configurable reports. i created a custom SQL report that generates around 2000 records of users...is there a way to search through users full names instead of firstname or lastname using filters...?

In previous versions of the plugin i think it worked,no>?


Thanks

Average of ratings: -
In reply to Zeid Fanous

Re: Filter for user full name

by Melanie Dillmon -

Hi Zeid,

I was wondering if maybe you have found a solution to this by now. I am trying to add a filter to my sql report. I tried the Where operator (novice in SQL here), but rather than filtering, it sets all of the values in that column to the value I specify. Let me know if you have any insight!


Average of ratings: -