Guidewire Query API Test 2023-2024
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
