Bookshelf Home | Contents | Index | PDF | ![]() ![]() |
Siebel Hospitality Guide > Managing the Function Space Diary > Process of Managing the Function Space Diary > Querying in the Function Space DiaryThrough 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: 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 SpacesYou 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
Clearing Query Parameters from the Diary ViewsWhen 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
About Querying in the Function Space DiaryThe 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 QueriesUsers can create queries that filter bookings on the basis of the following criteria:
Function Space QueriesIn 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 QueriesYou 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. |
![]() |
![]() ![]() |
Siebel Hospitality Guide | Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |