Yogesh Chauhan's Blog

4 advanced ways to search Colleague

in Colleague on January 17, 2022

Similar Colleague UI Basics posts:

Accessing the user interface

The Context Area

The Search Area

There are multiple ways to perform the advanced search in Colleague in case you want to filter out some results from a large search.

Let’s look at those ways one by one:

Advanced Person Search Colleague

In the Search Area, click on the “Advanced” button, which is located at the far right.

Once you click on the “Advanced” button, you’ll see the following form with many search fields to filter from.

Advanced Person Search in Colleague

Soundex Search = ‘sound like’ search

Soundex Search is really helpful when you want to search person by their nickname. For e.g. if you don’t know if you’re searching for Jon, John, or, Jonathan, you can use Soundex Search to find it.

You can perform a Soundex Search by using the ‘/’ character.

If you search for “/ jon“, Colleague will show results for Jon, Jonathan, John, Johnathan, and even Juan.

Soundex Search Colleague

Keep in mind that Soundex search takes a bit additional time to return the results and sometimes it’ll return many results depending on your database.

In Colleague ‘Birth Date’ is not a searchable field when you use the Advanced Person Search form but there is a way to search a person’s record just using a birth date.

To search a person’s record just using a birth date, you need to have the database field name first.

The birth date in Colleague is stored in the ‘BIRTH.DATE’ field in the PERSON table.

To search Colleague for a person with a birth date “12/07/1941′, you need to add a semicolon as a prefix:


;birth.date = ‘12/07/1941’

Alternate Field Birthdate Search

It works for a 2-digit or 4-digit year.


I’d like to call it a quick advanced search.

If you have a few different fields about a person, you could combine those fields into one and create a combined search. This will help you narrow down the search results.

To create a combined search, you need to add a semicolon as a prefix to each search term and separate each search term with a space.

Just like this:


;birth.date = '01/01/70' ;last.name = 'Ellucian'

A Soundex Search can be combined with an Alternate Field Search like this:


;birth.date = '01/01/70' ;/ Ellucian

Credit: Colleague User Manual


Most Read

#1 Solution to the error “Visual Studio Code can’t be opened because Apple cannot check it for malicious software” #2 How to add Read More Read Less Button using JavaScript? #3 How to check if radio button is checked or not using JavaScript? #4 Solution to “TypeError: ‘x’ is not iterable” in Angular 9 #5 How to uninstall Cocoapods from the Mac OS? #6 PHP Login System using PDO Part 1: Create User Registration Page

Recently Posted

#Apr 8 JSON.stringify() in JavaScript #Apr 7 Middleware in NextJS #Jan 17 4 advanced ways to search Colleague #Jan 16 Colleague UI Basics: The Search Area #Jan 16 Colleague UI Basics: The Context Area #Jan 16 Colleague UI Basics: Accessing the user interface
You might also like these
How to load variables, functions, and mixins from another module in SCSS?SCSSUNION and UNION ALL in PostgresPostgresWhat are Conditional Tags in WordPress?WordPressThe fundamental difference between HAVING and WHERE clauses in PostgresPostgresAn Example of Cross-site Scripting (XSS) Attack in PHP and How to Avoid It?PHPWordPress: How to access first and random row values from a repeater field in ACF?WordPress