//GlideRecord, addQuery(), orderBy(), setLimit(), getValue(), query(), next(), while(), get() gs.addInfoMessage("START"); var recLimit = 5; //List the numbers of the first 5 incident records. var myGR= new GlideRecord("incident"); //Table names are case sensitive. myGR.addQuery("active", true); //Only active records. myGR.orderByDesc("number"); //Sort by number. myGR.setLimit(recLimit); //Return only 5 records. myGR.query(); gs.addInfoMessage("Row Count: " + myGR.getRowCount()); var recsFound = myGR.hasNext(); if (recsFound) gs.addInfoMessage("Start Listing of first " + recLimit + " incident records."); while (myGR.next()) { gs.addInfoMessage(myGR.getValue("number")); //gs.addInfoMessage(myGR.number); //This works also. Alternate syntax. } if (recsFound) gs.addInfoMessage("Completed the Listing of the first " + recLimit + " incident records."); //Get a single record by its sys_id. var quickGR = new GlideRecord("incident"); if (quickGR.get("sys_id", "9d385017c611228701d22104cc95c371")){ gs.addInfoMessage(quickGR.getValue("number")); gs.addInfoMessage(quickGR.getValue("sys_id")); } gs.addInfoMessage("END");