queryGuests( )

Creates a query to retrieve a list of guests.

The queryGuests() function 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() function.

You can refine the query by chaining GuestsQueryBuilder functions onto the query. GuestsQueryBuilder functions 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:

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

The functions 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 functions are supported for queryGuests(). You can only use one filter function 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()