Siebel Hospitality Guide > Managing the Function Space Diary > Process of Managing the Function Space Diary >

Querying in the Function Space Diary

Through the Function Space query assistant, you can create queries that are based on booking as well as function space attributes. The query assistant is available in each diary view. When you run a query, the diary changes to display only the information determined by the query criteria. Dependency bookings are also indicated within the diary when possible.

The following specific tasks are described in this topic:

• Querying for Related Function Spaces
• Clearing Query Parameters from the Diary Views

Many additional query operations can be performed in the diary. Some of these operations are described in About Querying in the Function Space Diary. For more information on using the query assistant, see Siebel Fundamentals.

This task is a step in Process of Managing the Function Space Diary.

Querying for Related Function Spaces

You can run a query that displays not only the particular function space that meets your criteria but also any related function spaces. For example, consider a function space named Salon A, which includes Salon AB, Salon AC, and Salon ABC. If you run a query that returns Salon A, then you can choose to also show Salon AB, Salon AC, and Salon ABC.

To query for related function spaces

1. Navigate to the Function Space Diary screen.
2. In the Properties form, query for the property record.
3. Click the appropriate view tab from one of the following: Sales/Execution, Revenue Management, Total Availability, or Compact Diary.
4. From the selected view, enter the required start date, and then click Go.

   Alternatively, you can specify the start date within the query assistant.

5. On the view toolbar, click Query to display the query assistant.
6. Enter your criteria in the Function Spaces section, and then click Go.

   The function space most suitable for your requirements appears.

7. On the view toolbar, click the menu button, and select Enable Query for Related Spaces.

   The diary changes to display any function spaces that are related to the returned function space.

8. To disable queries for related function spaces, from the diary view, click Menu, and choose Disable Query for Related Spaces.

   If you have already run a query, then the diary changes to display only the original function space returned, hiding the related spaces from the view.

Clearing Query Parameters from the Diary Views

When you perform a query in the diary, the bookings and function spaces are filtered to show only those items that meet your query criteria. In other words, the diary shows only a subset of all available information. To display all possible bookings and function spaces for the selected date and property, you can remove query filtering from the views.

To clear the query parameters from the diary views

1. Click the Query button on the diary view toolbar.
2. In the Query Assistant dialog box, click the Clear button.

   All the query fields are cleared.

3. Click Go to perform a blank query.

   The diary views now show the unfiltered information.

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.