Hi Smitha,
Please find the example :
/ Look for Problem records
var gr = new GlideRecord('problem');
// That have associated Incident records
var grSQ = gr.addJoinQuery('incident');
// Where the Problem records are "active=false"
gr.addQuery('active', 'false');
// And the Incident records are "active=true"
grSQ.addCondition('active', 'true');
// Query
gr.query();
// Iterate and print results
while (gr.next()) {
gs.print(gr.getValue('number'));
}
Thanks
Prakash
