Portfolio of Keith ElderRoster Search
by Keith Elder
Roster Search, My First .NET App
Today we have SIFT to be able to filter and search for team members. But from 2004 until SIFT replaced the roster search in 2015, it was the only way to find team member information.
Roster search was used by everyone the company. From bankers calling their team leader to client relations to route calls to the correct banker.
How did it work
In order to get to team member information we had to retrieve it from Active Directory. Remember, we didn't have Workday and a central storage area.
As I built the roster I created a common library to retrieve users from and search active directory. This was before I created Rock.Framework. It was called "Rock.QL.Common". Other wound up using this common library as well early on as we adopted .NET. We didn't have a package manager so the code kept getting copied in those days from application to application. Later, I took and modified this code and it became Rock.Framework.DirectoryServices.
This is the only picture of it I can find. It was an Asp.Net application using web pages.
Features
Searching By:
- First and Last Name
- Phone
- Extension
- Fax
- Title
- Team
- Communicator status
- etc.
How was Roster Search Accessed
It was embedded into Rockworld and on the home page.
Who does Dan Gilbert report to?
In the roster search you could walk up the org chart by clicking on each team member's leader. Until you got to Dan Gilbert. He reported to himself. Then one day after he had purchased the Cleveland Cavaliers he was giving Usher a tour of our office. When they walked by my desk Dan leaned into my cubicle and asked, "Can you make me report to Lebron James in the Roster Search?"
I thought for a moment and said yes, we can do it. Twenty minutes Dan started reporting to Lebron.
After his fallout with Lebron he called me one day to have him report to Homer Simpson.
Years later when the roster search was re-written to leverage the CSA database instead of active directory (but kept the same design), Dan started reporting to Daenerys Targaryen.