var gr = new GlideRecord('incident');
if (gr.get('sys_id_here')) {
  gs.info('Found: ' + gr.getValue('number'));
}

var gr = new GlideRecord('sys_user');
if (gr.get('user_name', 'admin')) {
  gs.info('Found user: ' + gr.getValue('name'));
}

var gr = new GlideRecord('incident');
gr.addQuery('active', true);
gr.addQuery('priority', '1');
gr.orderByDesc('sys_created_on');
gr.setLimit(100);
gr.query();

while (gr.next()) {
  gs.info(gr.getValue('number'));
}

var gr = new GlideRecord('incident');
// Encoded query from list view URL or Query Builder
gr.addEncodedQuery('active=true^priority=1^assigned_toISEMPTY');
gr.query();

while (gr.next()) {
  // Process records
}

// When you only need X records
var gr = new GlideRecord('incident');
gr.addQuery('active', true);
gr.setLimit(10);  // Don't fetch more than needed
gr.query();

// CORRECT - Returns string value
var number = gr.getValue('number');

// ALSO WORKS but returns GlideElement
var element = gr.number;
var numberStr = gr.number.toString();

// Get the display value of a reference field
var assignedToName = gr.getDisplayValue('assigned_to');

// Get the sys_id of a reference field
var assignedToId = gr.getValue('assigned_to');

// BAD - Query inside loop
for (var i = 0; i < userIds.length; i++) {
  var gr = new GlideRecord('sys_user');
  gr.get(userIds[i]);  // N queries!
}

// GOOD - Single query with IN clause
var gr = new GlideRecord('sys_user');
gr.addQuery('sys_id', 'IN', userIds.join(','));
gr.query();
while (gr.next()) {
  // Process all users at once
}

// BAD - Counting with GlideRecord
var count = 0;
var gr = new GlideRecord('incident');
gr.addQuery('active', true);
gr.query();
while (gr.next()) {
  count++;
}

// GOOD - Use GlideAggregate
var ga = new GlideAggregate('incident');
ga.addQuery('active', true);
ga.addAggregate('COUNT');
ga.query();
if (ga.next()) {
  var count = ga.getAggregate('COUNT');
}

var gr = new GlideRecord('incident');
gr.initialize();
gr.setValue('short_description', 'New incident');
gr.setValue('caller_id', gs.getUserID());
gr.setValue('priority', '3');
var sysId = gr.insert();

var gr = new GlideRecord('incident');
if (gr.get('sys_id_here')) {
  gr.setValue('state', '6');  // Resolved
  gr.setValue('close_notes', 'Issue fixed');
  gr.update();
}

var gr = new GlideRecord('incident');
if (gr.get('sys_id_here')) {
  gr.deleteRecord();
}

var gr = new GlideRecord('incident');
gr.addQuery('state', '6');  // Resolved
gr.addQuery('resolved_at', '<', gs.daysAgoStart(30));
gr.query();

while (gr.next()) {
  gr.setValue('state', '7');  // Closed
  gr.update();
}