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 PHP Login System using PDO Part 1: Create User Registration Page #6 How to uninstall Cocoapods from the Mac OS?

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
CurrencyPipe in Angular 9 with ExamplesAngularHow to Install PHP Laravel on MacOS Catalina?PHPHow get_template_part helps write reusable code in WordPress?WordPressHow to remove trailing characters from a string using JavaScript?JavaScriptHow to disable scrolling on html body on menu click using JavaScript?JavaScriptPHP __construct() functionPHP