Databases Reference
In-Depth Information
Let's start with a practical example. As HighCloud is still in the process of deciding
which US cities to include in their network, analysts want to keep track of destination
cities based on the following criteria:
• Cities that have been destination to flights originated outside the US
• Only cities within the US
• Their global load factor needs to be 80% or more
Follow these steps to create this search expression:
1.
Locate the
Flight Information
multi box and click on the
Destination City
drop-down to open the list of values.
2.
Right-click anywhere on the list and select
Advanced Search
.
3.
In the
Search Expression
input box, enter the following expression:
=[Origin Country] <>'United States' and
[Destination Country] = 'United States' and
$(eLoadFactor) >= 0.8
4.
Click on
Go
to apply the selection and then click on
Close
to close the
Advanced Search
dialog.
When we open the
Destination City
drop-down list, we can see that a selection has
been made. These are the cities that have an occupancy of 80% or more for incoming
international flights. We can also see that, instead of a list of fixed values, our
advanced search expression is shown in the
Current Selections
box, seen here:
In our example, we used the
Advanced Search
dialog to enter
the search expression. If you already know what expression
you want to enter, it is also possible to just select the list box or
drop-down, press the
=
key and enter the expression directly.