Search/Find/Lookup for Places, Meters, or Counters
EnergyCAP provides a search/find/lookup option to assist users in browsing the Facility tree and quickly locating a particular Place, Meter or Counter.
This functionality is particularly useful for larger organizations and/or situations where the EnergyCAP user is not well-acquainted with the Facility tree hierarchy.
There are two methods for searching the Facility tree:
- Quick Search enables searching for Meters, meter serial #, Place and Address
- Find function enables more robust searching for Places, Counters and Meters using search operators.
Meter Quick Search (binoculars)
- From the Facility Manager (Setup > Facilities), click on the Binoculars icon to open the Meter Selection window.
- In the Meter Selection window, begin to enter the Meter Code in the field provided. As you type, the list box below will be automatically pouplated with a list of matches.
NOTES:
Show Inactive checkbox will include inactive meters in search.
Advanced Search checkbox will also include meter serial #, Place and Address
For larger organizations, additional SQL operators % and _ can be used as wildcards. Use [] to define a text string or set: [a-f], [abcdef]. use [^] to define a "not like" letter, text string or series (i.e., del[^ete]. - When the desired Meter Code appears in the list of Matches, click on it to select it. Then click OK to locate the meter in the Facility tree.
- The Facility tree will expand to the point where the selected Meter appears, and the meter PowerView will be displayed.
Find function
A more robust search can be made for Places, Counters and Meters using the Find function. With Find, multiple parameters may be included in the search.
- From the Facility Manager (Setup > Facilities), either click on the Find Meter button (located in the top-right corner), OR use the Edit > Find… menu to open the Search window.
- In the Search for: drop-down list, select the Places, Meters, or Counters option.
- In the Parameter: drop-down list, select the option that corresponds to known data. The Parameter list will vary, based on what is being searched for.
- Select an Operator from the drop-down list. Operator options include: Equals, Not Equals, Less Than, Greater Than, Less Than Equal, Greater Than Equal, Like, and Not Like.
! Use wildcards when using the Like and Not Like operators. Wildcards of ‘*’ and ‘?’ are available. An asterisk represents any string of characters and a question mark represents any single character. For example, using the LIKE operator, a Search value of 1* would locate all addresses beginning with 1. A Search value of ?2* would locate all addresses with a second character of 2. A Search value of *1?? would locate all addresses including a 1 with at exactly two characters following it. A Search value of *5* would locate all addresses that included the number 5. ! - Enter the Value that you desire to use in your search, incorporating any desired wildcard characters.
- Click the ‘+’ button to add this filter to the Filters list box.
! You must enter at least one filter to activate the Search button! - After the Search button has been activated, it is possible to create additional filters If desired. To so so, repeat steps 2-5 as follows:
- Click
to search using the previous filter and this filter. - Click
to search using the previous filter or this filter.
- Click
- To remove a specific filter, select it and then use the ‘-‘ button to remove it.
- To remove all filters, use the Clear button.
- After creating all filters, click Search. The search results are shown in the Results text box.
! “No data found” will be displayed in the Results field if EnergyCAP Enterprise cannot locate any matching data!
If the Meter find/search does not return a Result for a meter that you know is there, refer to Meter Search Fails to Find a Meter, below. - Double-click on the appropriate item in the Results field to open the Properties window for the found item. Or select the appropriate item in the Results field and click the Locate button from the Search window to find the item in the Facility tree. The Search window will automatically close and EnergyCAP Enterprise will expand the Facility tree to the point where the selected item appears.
- If desired, exit Find by clicking the Close button.
Meter Search Fails to Find a Meter
Issue:
The meter find/search does not find a meter that I know is there.
Solution:
The meter find/search will fail if there is no deviceProperty record for the meter. The deviceProperty record appears on the 'Specific' tab of meter properties and it includes, among other things, the serial number.
Under normal circumstances it's impossible for a meter to lack a deviceProperty record, but in some unusual cases in which meters were created automatically from multiple FASER datasets or possibly other automated processes, the deviceProperty record(s) may be missing.
The following SQL script will create deviceProperty records for any meters that may not have one:
