Space Console: Use the Search Box for Query Statement Searches
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 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 .
Important Note:
-
When you log into the Smart Client and launch the Internal Browser, this is a light version of Web Central and the Query Search is not available for use.
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 drop-down 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.
Once you receive your results, click on a floor in the list.
Alternately, if you type Enter, the search results lists all the floors and you can select a floor from there.
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 .
Search 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
|
|