earth_america
user_standard Connexion
action_search_stroke
earth_america
Log on to rate and give feedback 1 2 3 4 5 Log on to rate
0
Comment faire pour

Comment faire pour


Produits : WebStation
Fonctionnalités : Fonctionnalité de base
Version produit : 2024, 7.0
03/12/2024

Exporting a Search to Excel

You can export a search result as an Excel file.

Afficher plus
action_close

Use Search to find and view objects in the EcoStruxure BMS database.

Different Searches

There are two different ways to search in WebStation:

  • The Search function searches for all object names and property names in the system.

  • A saved search is a predefined search that searches specific criteria in a specific part of the system. Saved searches are created in WorkStation and the search criteria cannot be changed in WebStation.

Search is case insensitive, which means that Search does not distinguish between uppercase and lowercase letters. A search for "Fan" results with hits for both "fan" and "Fan".

Wildcards

Use wildcards to substitute characters or combinations of characters in a search.

Search supports two main wildcards:

  • Asterisk (*) represents any combination of characters including white space.

  • Question mark (?) represents any single character.

For example, you want to find all objects and properties containing the word “Temperature”. You start the search with an asterisk so that the search includes all hits on objects like “Outside Air Temperature” where the asterisk represents the words before "Temperature", in this case “Outside Air”. You also have to end the search text with an asterisk to include objects like “Temperature Alarm” where the asterisk represents the word after "Temperature", in this case “Alarm”.

Local or Global Searches

You can search in your whole EcoStruxure BMS or only in a folder, device, or server:

  • To search your whole system, select the top server and then perform the search. You can also click the Search whole server button in the list.

  • To search a specific folder, select the folder and then perform the search.

Déclaration

When you perform a search, you cannot leave the Search box empty. To perform a search, you have to enter something in the Search box.

Export a search

You can export a search result as an Excel file.

Multi-edit in the search list view

You can multi-edit several objects in the search result list at the same time. This saves a lot of time compared to editing the objects one by one.

Pour plus d'informations, voir Multi-editing in Search .

Quick filter on numeric operators

Quick filter has an additional feature in WebStation. You cannot only filter on text. You can also filter on numeric operators.

The following operators are allowed:

  • <

  • >

  • <=

  • >=

  • =

For example:

  • ">80s" show objects that have a number property visible with a value over 80.

  • "<=80" shows objects with values that are exactly 80, or less.

  • "=80" shows objects that have numeric values visible that are exactly 80.

To export a search to Excel

  1. In WebStation, in the System tree , select the folder, server, or device you want to search in.

  2. Click the magnifier.

  3. In the Search box, type the text you want to search for.

  4. Press Enter .

  5. Í the toolbar, click the Export to Excel button

     
    action_zoom_plus_stroke
    .

  6. Save the Excel file.

Voir aussi

  • Search in WebStation
  • Searching in WebStation
  • Search Toolbar
  • Searching Using a Saved Search