ServiceNow Introduction to addJoinQuery() method with demo

Amit Gujarathi · ‎12-01-2022

Hi All,

I hope you are doing fine.

In this tutorial, we will be looking over one more interesting method in the ServiceNow magic world i.e. GlideRecord addJOinQuery() method.
So what exactly does this addJoinQuerymethod do?
From the name don’t confuse it with the actual database join, instead, it just adds the subquery so that the result set will be confined to the subquery which you have defined.
Let's look at the inputs and outputs of the method
- Input :
  - table — String — Table name
  - primary field — String —If other than sys_id, the primary field.
  - joinTableField — String — If other than sys_id, the field that joins the tables
- Output :
  - GlideQueryConditionRecords — where the relationships match.

Example :

var now_GR = new GlideRecord('problem'); 
now_GR.addJoinQuery('incident', 'opened_by', 'caller_id'); 
now_GR.query();

You can set the glide.invalid_query.returns_no_rows system property to true to have queries with invalid encoded queries return no records.

Agenda :

Introduction to addJoinQuery method
Understanding the problem statement
Understanding the Usecase for the same
Demo
Note: Always thoroughly test the addJoinQuery() method in the sub-prod instance before putting it to prod as the wrong structure may lead to a huge mess.

Please be sure to bookmark this article as well as mark it as Helpful if you thought it was helpful.

Regards,

Amit Gujarathi