Faculty – All Teaching Faculty

Status: 

Priority: 

Test URL(s):

References:

Request(s):

Status: Closed; Priority: N/A

Fixed

  1. Select staff by letter does not work
  2. Staff members listing not in right order
  3. Remove the “Inner Menu” section
  4. Add “First name” to the sorting criteria
    Sort by Last name + First name in Ascending order
  5. Remove the remaining Inner Menu Title

Page layout: Check out the links below

Build the dropdown list from the Menu list “Faculty / Practitioner List” defined in WordPress Menu section

Pull data from the following database table:
fbu_faculty:
display = ‘Y’
language LIKE ‘%en%’

Sort by Last name + First name in Ascending order

To fix

"All Teaching Faculty" page DOES NOT require an "Inner Menu"
Remove the "Inner Menu" section

Fixed:

  1. Remove the “Inner Menu” section
  2. Add “First name” to the sorting criteria, make it
    Sort the list by “Last name” + “First name”
Remove the "Inner Menu" Title

Fixed:
Menu Title is part of the “Inner Menu”, it should be removed as well

12 thoughts on “Faculty – All Teaching Faculty”

    • Fixed, now you will select any letter it will consider last name letter

      An SQL query is like that

      SELECT * FROM fbu_faculty WHERE 1 AND `lastname` LIKE ‘D%’ AND display = ‘Y’ AND language LIKE ‘%en%’ ORDER BY lastname ASC

      please check the query and let me know if any issue or query

      Also, I have noticed some members show two times because they have a two-time entry in the database https://nimb.ws/jvznNg

Leave a Comment