Guidewire Query API Exam Questions
with Correct Answers
Property Reference - Answer-When writing queries create a property reference only to
persistent fields in the database
For example: EntityType#Property
Best practice for using contains() - Answer-add an initial predicate that uses an index
Benefits: This enables the database to filter out most of the rows and then execute the
contains on a sub-set
Which entity column attribute must typically be set to true when compareIgnoreCase() is
used? - Answer-supportsLinguisticSearch
What can you do to improve the performance of a query that uses contains()? - Answer-
Add an initial predicate that uses an index
Addressing dot notation performance issues - Answer-use ArrayLodaer class
for example
myArrayParent.arrays("MyArrayChildReference")
Checking for existence of an entity - Answer-Just check for the existence of an entity if
the number of results are not important , verify the results of a targeted query are not
empty
What methods for queries should be avoided for checking entities? - Answer-1. Avoid
hasMatch()
2. Avoid countWhere()
3. Avoid select().Count
instead use targeted query and then checking if the results are empty
gRoot - Answer-used for normal entity queries issued by the Guidewire Query API
qRoot - Answer-used for row query
Key load query - Answer-is a query that retrieves the IDs for potential bean loads
vbRoot - Answer-view bean query type that populate a list view
with Correct Answers
Property Reference - Answer-When writing queries create a property reference only to
persistent fields in the database
For example: EntityType#Property
Best practice for using contains() - Answer-add an initial predicate that uses an index
Benefits: This enables the database to filter out most of the rows and then execute the
contains on a sub-set
Which entity column attribute must typically be set to true when compareIgnoreCase() is
used? - Answer-supportsLinguisticSearch
What can you do to improve the performance of a query that uses contains()? - Answer-
Add an initial predicate that uses an index
Addressing dot notation performance issues - Answer-use ArrayLodaer class
for example
myArrayParent.arrays("MyArrayChildReference")
Checking for existence of an entity - Answer-Just check for the existence of an entity if
the number of results are not important , verify the results of a targeted query are not
empty
What methods for queries should be avoided for checking entities? - Answer-1. Avoid
hasMatch()
2. Avoid countWhere()
3. Avoid select().Count
instead use targeted query and then checking if the results are empty
gRoot - Answer-used for normal entity queries issued by the Guidewire Query API
qRoot - Answer-used for row query
Key load query - Answer-is a query that retrieves the IDs for potential bean loads
vbRoot - Answer-view bean query type that populate a list view
