gliderecord-patterns

This skill should be used when the user asks to "query records", "GlideRecord", "database query", "get records", "update records", "insert record", "delete record", or any ServiceNow database operations.

Zur Installation springen

Repository: diegosouzapw/awesome-omni-skill
Letzte Quellaktivität: 2. März 2026 um 00:30
Erkannte Sprache von SKILL.md: Englisch
Sterne: 50
Forks: 19

Installationsoptionen

Standardmäßig ist der Prompt ausgewählt, der zuerst die Quelle prüft. Sie können zu einem direkten Befehl wechseln oder eine lokale Kopie herunterladen.

Mit Codex oder Claude installieren Kopieren Sie diesen Prompt, fügen Sie ihn in Codex, Claude oder einen anderen Assistant ein und lassen Sie die Skill-Seite prüfen und installieren.

Ein direkter Befehl überspringt den Prüf-Prompt. Prüfen Sie die Quelle, bevor Sie ihn ausführen.

npx skills add https://github.com/diegosouzapw/awesome-omni-skill --skill gliderecord-patterns

Der Befehl bleibt in einer Zeile. Scrollen Sie horizontal, um ihn vor dem Kopieren vollständig zu prüfen.

Sie bevorzugen eine lokale Kopie? Laden Sie die Dateien herunter, die SkillsMP derzeit vorliegen.

Quelldateien prüfen

Lesen Sie SKILL.md und alle von SkillsMP angezeigten Begleitdateien, bevor Sie sich für eine Installation entscheiden.

Datei-Explorer

2 Dateien

SKILL.md

Quellanweisungen · Schreibgeschützte Vorschau

Zurück zur Suche Zurück zur Installation

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()
}

Operator	Example	Description
`=`	`addQuery('active', true)`	Equals
`!=`	`addQuery('active', '!=', true)`	Not equals
`>`, `<`	`addQuery('priority', '<', '3')`	Greater/Less than
`>=`, `<=`	`addQuery('sys_created_on', '>=', gs.daysAgoStart(7))`	Greater/Less or equal
`CONTAINS`	`addQuery('short_description', 'CONTAINS', 'error')`	Contains string
`STARTSWITH`	`addQuery('number', 'STARTSWITH', 'INC')`	Starts with
`ENDSWITH`	`addQuery('email', 'ENDSWITH', '@company.com')`	Ends with
`IN`	`addQuery('state', 'IN', '1,2,3')`	In list
`NOT IN`	`addQuery('state', 'NOT IN', '6,7')`	Not in list
`ISEMPTY`	`addQuery('assigned_to', 'ISEMPTY', '')`	Field is empty
`ISNOTEMPTY`	`addQuery('assigned_to', 'ISNOTEMPTY', '')`	Field is not empty

name	gliderecord-patterns
description	This skill should be used when the user asks to "query records", "GlideRecord", "database query", "get records", "update records", "insert record", "delete record", or any ServiceNow database operations.
version	1.0.0
tools	["snow_query_table","snow_execute_script_with_output","snow_discover_table_fields"]

name	gliderecord-patterns
description	This skill should be used when the user asks to "query records", "GlideRecord", "database query", "get records", "update records", "insert record", "delete record", or any ServiceNow database operations.
version	1.0.0
tools	["snow_query_table","snow_execute_script_with_output","snow_discover_table_fields"]

gliderecord-patterns

Installationsoptionen

Quelldateien prüfen

GlideRecord Best Practices for ServiceNow

Basic Query Patterns

Get Single Record by sys_id

Get Single Record by Field

GlideRecord Best Practices for ServiceNow

Basic Query Patterns

Get Single Record by sys_id

Get Single Record by Field

Query Multiple Records

Encoded Queries (Faster)

Performance Tips

1. Always Use setLimit()

2. Use getValue() for Strings

3. Use getDisplayValue() for References

4. Avoid Queries in Loops

5. Use GlideAggregate for Counts

CRUD Operations

Insert

Update

Delete (Use with Caution!)

Bulk Update

Query Operators

Security Considerations

gliderecord-patterns

Quellinformationen

Installationsoptionen

Quelldateien prüfen

Mehr aus diesem Repository

Mehr aus diesem Repository

GlideRecord Best Practices for ServiceNow

Basic Query Patterns

Get Single Record by sys_id

Get Single Record by Field

GlideRecord Best Practices for ServiceNow

Basic Query Patterns

Get Single Record by sys_id

Get Single Record by Field

Query Multiple Records

Encoded Queries (Faster)

Performance Tips

1. Always Use setLimit()

2. Use getValue() for Strings

3. Use getDisplayValue() for References

4. Avoid Queries in Loops

5. Use GlideAggregate for Counts

CRUD Operations

Insert

Update

Delete (Use with Caution!)

Bulk Update

Query Operators

Security Considerations