Kathryn,
To do 2), remove a field, you can either put a pound sign # in front of the lines to comment them or, or you can simply delete them. Each column of the report is separated by a comma in the SELECT statement. So put a # in front of the start of the column logic you wish to remove.
If you want to add other fields related to users, then you need to know the names of those fields, which are: u.firstname, u.lastname, u.email, u.institution. The names of the user fields here are the very same ones used in other places such as the user upload field. They are standard names.
You can add those in any place you want between the word SELECT and the keyword FROM - those are define the columns in the order you want. Just make sure there is a comma between each one.
So,
u.username, u.firstname, u.lastname, u.email, u.company, u.institution
is the same as
u.lastname, u.firstname, u.institution, u.company, u.email, u.username
but the order is different. You can order them any way you wish, include or exclude the ones you wish. You will find many examples of these over in the Ad-hoc reports page.
Good luck & watch your commas...
Randy
To do 2), remove a field, you can either put a pound sign # in front of the lines to comment them or, or you can simply delete them. Each column of the report is separated by a comma in the SELECT statement. So put a # in front of the start of the column logic you wish to remove.
If you want to add other fields related to users, then you need to know the names of those fields, which are: u.firstname, u.lastname, u.email, u.institution. The names of the user fields here are the very same ones used in other places such as the user upload field. They are standard names.
You can add those in any place you want between the word SELECT and the keyword FROM - those are define the columns in the order you want. Just make sure there is a comma between each one.
So,
u.username, u.firstname, u.lastname, u.email, u.company, u.institution
is the same as
u.lastname, u.firstname, u.institution, u.company, u.email, u.username
but the order is different. You can order them any way you wish, include or exclude the ones you wish. You will find many examples of these over in the Ad-hoc reports page.
Good luck & watch your commas...
Randy