WordPress.org

Forums

Resume Submissions & Job Postings
How to sort resumes on Resume Submission (4 posts)

  1. jeffbon
    Member
    Posted 2 years ago #

    How do you sort the resumes on the Resume Submission page by last name?

    http://wordpress.org/extend/plugins/resume-submissions-job-postings/

  2. kandrews
    Member
    Plugin Author

    Posted 2 years ago #

    Right now there sort is by publish date, then last name.
    So to have only last name, find this line in the file submissions in the includes folder:

    $infoQuery = $wpdb->get_results( 'SELECT * FROM ' . SUBTABLE . $queryFind . ' ORDER BY pubdate DESC, lname DESC, fname DESC LIMIT ' . $offSet . ', ' .$rowsPerPage );

    Replace with:

    $infoQuery = $wpdb->get_results( 'SELECT * FROM ' . SUBTABLE . $queryFind . ' ORDER BY lname DESC, fname DESC LIMIT ' . $offSet . ', ' .$rowsPerPage );

  3. jeffbon
    Member
    Posted 2 years ago #

    This works on the backend list but not on the resume-submissions web page.

  4. jeffbon
    Member
    Posted 2 years ago #

    I figured it out by editing display-resumes.php.

    Is there any way to display other fields in display-resumes.php?

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic