About Querying in the Function Space Diary

The query assistant is divided into two sections, Functions/Bookings and Function Spaces. You can enter query parameters into either or both of the sections. If you enter query parameters into both sections, then the results returned must meet the criteria specified in both sections.

When you enter criteria in any of the sections, you can use the Boolean operators AND or OR. If you use AND, then the bookings or function spaces returned must meet all specified criteria. If you use OR, then bookings or function spaces that meet any of the criteria are returned.

Booking and Function Queries

Users can create queries that filter bookings on the basis of the following criteria:

• General booking attributes (noise, detailing, and so on)

• Booking status (overbooked, optioned, shifted, and so on)

• Booking relationship type (affiliate, host, and so on)

• Booking activity (backup or active)

• Specific space or a category booking

• Quote-related attributes (business type, account, sales representative, and so on)

• Operational attributes (setup style, function type, meal time period, and so on)

Function Space Queries

In addition to querying for specific bookings, you can also query for function spaces that meet certain criteria. For example, you can query for only those function spaces that have Internet connections or that have a specific capacity.

Combination Booking and Function Space Queries

You can use the query assistant to display certain types of bookings for a specific subset of function spaces. For example, you can enter parameters in the booking section so that, for example, only backup bookings appear. You can then enter parameters in the function space section so that, for example, only function spaces with a physical area greater than 20 square meters are displayed.