Are you familiar with the component Fabrik for Joomla?
This is what I need to accomplish:
There are three tables in the moodle site that i am connecting to via
In fabrik I can join tables and produce views, do sorting, filtering rules etc.
In the mdl_user_info_field table are these three items:
Newsletter (If they choose to be sent newsletter)
State (The State from Signup)
In the mdl_user_info_data table the user id has a record for each-
So User Id 1 Bob would have 3 records in the mdl_info_data table.
I can display them in a table view seperate by joining and filtering the data.
bob newsletter signup.
But the client wants to display as follows: Name, City, State, Signup
Date, Occupation, Newsletter.
Also one other thing time is stored as epoch and needs to be converted to readable format.