queryGuests( )

Creates a query to retrieve a list of guests.

The queryGuests() method builds a query to retrieve a list of guests and returns a GuestsQueryBuilder object.

The returned object contains the query definition which is typically used to run the query using the find() method.

You can refine the query by chaining GuestsQueryBuilder methods onto the query. GuestsQueryBuilder methods enable you to sort, filter, and control the results that queryGuests.find() returns.

The query runs with the following GuestsQueryBuilder defaults that you can override:

• skipTo(0)
• limit(50)
• descending("_createdDate")

The methods that are chained to queryGuests() are applied in the order they are called. For example, if you apply ascending ('_createdDate') and then descending ('_updatedDate'), the results are sorted first by the created date and then, if there are multiple results with the same date, the items are sorted by the updated date.

The table below shows which GuestsQueryBuilder methods are supported for queryGuests(). You can only use one filter method for each property. Only the first filter will work if a property is used in more than one filter.

PROPERTY	SUPPORTED FILTERS & SORTING
_id	eq(),ne(),in(),exists()
eventId	eq(),ne(),in(),exists()
rsvpId	eq(),ne(),in(),exists()
orderNumber	eq(),ne(),in(),exists()
ticketNumber	eq(),ne(),in(),exists()
tickets	exists()
contactId	eq(),ne(),in(),exists()
guestDetails.checkedIn	eq(),ne(),exists()
attendanceStatus	eq(),ne(),in()
secondaryLanguageCode	eq(),ne(),in(),exists()
_createdDate	eq(),ne(),lt(),le(),gt(),ge(),in(),exists(),ascending(),descending()
_updatedDate	eq(),ne(),lt(),le(),gt(),ge(),in(),exists(),ascending(),descending()
attendanceStatusUpdatedDate	eq(),ne(),lt(),le(),gt(),ge(),in(),exists(),ascending(),descending()
memberId	eq(),ne(),in(),exists()
guestType	eq(),ne(),in()