Best practice forum (Archived)

Site-wide / Custom report on User Notes

 
? ?
Site-wide / Custom report on User Notes
by ? ? - Tuesday, 6 March 2012, 5:57 PM
 

 Hi,

Is it possible to create a site-wide/custom report on a User Notes (site/course )?

I looked through the report builder with the source as User and there seems to be all other user values that can be added as a report column except for 'User Notes'.

It seems as though user notes are stored as part of their profile information, similarly to their position information.

thanks,

-Ira

Craig Eves
Re: Site-wide / Custom report on User Notes
by Craig Eves (Totara Support) - Tuesday, 6 March 2012, 6:36 PM
Group Totara

Hi Ira

Yes it is possible to add more fields to a report source - this needs to be done through coding though. The developers have done this on several other sources it's just a matter of prioritising.

The other alternative is to add a custom profile field and this will be immediately available to the report source. If you already a lot of data in the note field this wouldn't be a good option for you though.

Craig

Simon Coggins
Re: Site-wide / Custom report on User Notes
by Simon Coggins - Tuesday, 6 March 2012, 6:54 PM
Group Totara

Hi Ira,

This would require a new report source to be written - the other user profile information is typically stored in the user table and has one value for each user, whereas notes are stored in there own table because each user can have multiple notes.

Simon