Archibus SaaS / Foundations / Space and Moves / Space Console
Archibus SaaS / Space / Space Manager / Space Console
Space / Space Inventory / Space Manager / Space Console (non-transactional)
Space / Occupancy / Manager / Space Console (non-transactional)
Space Console: Use the Search Box for Quick Search and Query Statement Searches
The Space Console's search box supports both quick searches and query searches. To use these features, you first set the search fields and type of search as described in Using the Search Box.
Enter a quick search
You may know the exact floors or characteristic of floors (such as floor or building name, or room categories, divisions, departments on the floor) that you want to examine. In these cases, you can directly type a sequence of characters to search for floors containing rooms whose identifying fields and corresponding description fields match the value you enter in the box. You control the exact set of fields the Quick Search uses by setting them in the Select Search Fields form.
Suppose you have a Department named "Regional." Type REGIONAL to list all the floors on which a room with a REGIONAL department is located; that is, the Room records have a value that contains the character sequence "REGIONAL" in the Department Code or Department Name fields. You can then choose a floor from the resulting list.
Rather than typing the complete value, you can enter a few characters and press Enter. For example, suppose you are not sure of the exact name of a division but you know that it includes some form of the word "business." You can type "BUS" followed by Enter to receive a list of floors whose values have these characters.
Note the following about using the search box:
- The search is a case-insensitive and exact.
- You can use " " for multiple-word searches, such as "SOFTWARE ENGINEERING".
- The search checks values in the Rooms table for all the search fields: Site Code, Building Code, Floor Code, Division Code, Department Code, and Room Category Code as well as their corresponding description fields (Building Name, Site Name, Division Name, and so on).
- The search returns floors whose rooms contain the entered text as part of their value. For example, if you enter
LAByou will receive floors that have rooms whose Room Category is LAB as well as all the floors in the SRL building, since the Building Name value, "Singularity Research Laboratory" contains the sequence "LAB."
You can now choose a floor from the drop-down list. The system hides the Floors list (if shown) and displays the floor plan in the right area of the Space Console.
Procedure
-
In the Select Search Fields form, activate the fields on which you want to make your search. See Choose the type of search and search fields.
-
Set the search box type (located to the right of the search box) to Quick
-
In the search box, type the value you are searching for in accordance with the fields you set. For example, if you chose to search on Department Code and Name, enter the characters contained in the desired department.
-
Select a floor from the presented list. The Space Console highlights the floor plan and presents the appropriate records in the Details tabs, as described in Search Overview.
Search using query statements
If you are familiar with using logical operators and search string logic, you can use the search box's query statement features.
To simplify the typing of the query search, you can take advantage of a list of suggestions that show as a dropdown lists of possible expressions and field values.
Example
If you start typing “Dep", the search box presents a drop-down list of possible fields for the search box (based on the Select Search Fields form, described above). For example, if you pick Department=, you will see Department= in the search box so that you can enter the department value.
You can then type the value for this field, and the search box presents a list of possible floors.
If you want to make a more complex query. you can continue building your statement. For example, the following query presents a list of floors that have rooms assigned to the Accounting department and are categorized as offices.
Procedure
-
In the Select Search Fields form, activate the fields on which you want to make your search. See Choose the type of search and search fields.
-
Set the search box type (located to the right of the search box) to Query.
-
Use the drop-down features to build your query statement.
-
Select a floor from the presented list. The Space Console highlights the floor plan and presents the appropriate records in the Details tabs, as described in Search Overview.
Types
The following searches are supported:
| Type | Description | Syntax | Example |
|---|---|---|---|
| Exact |
An exact search for a specific field by typing a field, “=” and its value in order to find the floors that match the exact value for the specified field. Matching is case-insensitive and searches both Code and Name/Description fields (unless this is unchecked in “Select Search Field” form). The available fields are Site, Building, Floor, Division, Department, Category unless unchecked in Select Search Field form. |
Field = ”Value“
|
|
| Wildcard |
Search for a specific field by typing a field, “like” and its value in order to find the floors contains the value for the specified field. |
|
|
| Includes |
Search for a specific field by typing a field, “includes” and a list of values in order to find the floors contains any value for the specified field.
|
|
|
| Excludes |
Search for a specific field by typing a field, “excludes” and a list of values in order to find the floors do not contains any value for the specified field. |
Field excludes 【”value1”, ”value2”, “value3”,…】
|
|
| Mixed
|
Search using a combination of all above query searches using |
|