Scripting Module 7

Question 1

What is the strategy for creating a new GlideRecord Query

Answer 1

Create a GlideRecord objec
Build the query conditions
Execute the query
Process returned records

Question 2

What does get() do?

Answer 2

Use to query for a single record

Question 3

What methods are used to confirm records returned?

Answer 3

getRowCount()
GlideAggregate()

Question 4

How do you build an encoded query?

Answer 4

Open the list for the table of interest
Build the query using the condition builder
Run the query to ensrue correct results
Right click the breadcrumbs and select copy query

Question 5

What is an alternative to GlideRecord

Answer 5

GlideQuery

Question 6

What are the main functions of GlideQuery

Answer 6

glideQuery.insert()
glideQuery.select() and glideQuery.selectOne()
glideQuery.update()
glideQuery.deleteMultiple(

Question 7

How does GlideQuery read data?

Answer 7

Stream class
Optional class

Question 8

What are common methods of the Stream Class

Answer 8

map
flatMap
forEach
reduce
some/any

Question 9

What are common methods of the Optional class?

Answer 9

get
map
isEmpty
isPresent
ifPresent
orElse