You are viewing the PKP Support Forum | PKP Home Wiki

Order user list

Are you responsible for making OJS work -- installing, upgrading, migrating or troubleshooting? Do you think you've found a bug? Post in this forum.

Moderators: jmacgreg, btbell, michael, bdgregg, barbarah, asmecher

Forum rules
The Public Knowledge Project Support Forum is moving to http://forum.pkp.sfu.ca

This forum will be maintained permanently as an archived historical resource, but all new questions should be added to the new forum. Questions will no longer be monitored on this old forum after March 30, 2015.

Order user list

Postby magius » Wed Feb 15, 2006 10:33 am

Hi to all

There is a mode for order (sort) for user profile number?

Journal Management -> User -> All user

The list appear random (?)

I wish listing in "order of registration" from first to last (or last to first)

It's possible?
(again sorry for my english)

Posts: 21
Joined: Thu Nov 17, 2005 11:28 am

Postby asmecher » Wed Feb 15, 2006 11:12 am

Hi Magius,

The list is sorted by last name and first name. Currently, to change the sort order, you'll need to modify the code; see classes/security/RoleDAO.inc.php. There are two places where "ORDER BY u.last_name, u.first_name" appears in is file; change them both to "ORDER BY u.date_registered".

Alec Smecher
Open Journal Systems Team
Posts: 10015
Joined: Wed Aug 10, 2005 12:56 pm

Postby magius » Wed Feb 15, 2006 11:40 am

Thanks Alec

Now perfect order by registration date

(modify the code in line 185 and 245)

You write
"Currently, to change the sort order, you'll need to modify the code;"

and in future??? :)

Proposal for next rev.... add the "last login" information in "User -> All user (list)

Thanks, grazie
Posts: 21
Joined: Thu Nov 17, 2005 11:28 am

Re: Order user list

Postby mendesrocha » Fri Aug 23, 2013 7:43 pm


Editor asked to sort list by first name initial instead of last name. To do it I replaced 'last' for 'first' in lines 205, 270 and 535 on OJS 2.4.0 in

Code: Select all
Posts: 178
Joined: Mon Nov 05, 2007 11:10 am
Location: Brazil

Return to OJS Technical Support

Who is online

Users browsing this forum: Baidu [Spider], Bing [Bot], Exabot [Bot] and 3 guests