We all know GlideRecords are used to fetch the database data. There are several methods that we use on a regular basis. Some methods that can help us filter out the results are

1. addActiveQuery() - This method allow us to only select active records. If there's "active" field on the table, we can use this method directly.

2. addNullQuery(field_name) - This method allow us to only select records that have a null value in the field mentioned.

3. addNotNullQuery(field_name) - This method allow us to only select records that do not have a null value in the field mentioned.

But did you ever wonder how grs go about their business of identifying the right records that satisfy the conditions.