|
|
 |
|
|
Applies to All Products:
Advanced Queries |
|
|
|
One of the strengths of the MIDAS architecture is the ability to do an exhaustive search or query of a log file. The advanced query features allows log files to be search for user specified conditions. The conditions may be AND’d & OR’d according to your specifications. Conditions may be placed on Analog or Binary (True/False) values.
The basic steps are:
- Load a Log File
- Enter the query screen
- Set the search conditions
- Start the search
During the query you may:
- Continue the search to the next hit
- Go back and forth between the located records
- Stop the Search
- Restart the Search
|
|
|
|
For the query function to be active, a log file must be loaded. Use the Replay Toolbar to load a log file as you usually do.
|
|
|
|
|
|
Enter the Query Screen |
|
|
|
|
|
Enter the Query Screen by clicking the binoculars located in the top left hand corner of the replay toolbar.
|
|
|
|
The query screen now appears. It has it’s own tool bar, drop down boxes for analog and binary values, time contraint pickers, and a search string area on the bottom of the screen.
Note:during the time this screen is active, log file replays are disabled.
|
|
|
|
|
|
The toolbar has most of the functions disabled. As they become available to you, they will be enabled.
|
|
|
|
|
|
Creating a Simple Query |
|
|
|
After entering the screen, the application is immediately available for your input. The input is done by selecting a values and putting conditions on it. There are two types of values, Analog and Binary. An analog value is something that has a numerical values attatched, e.g. “number of tons”, “how many degrees”, etc. A Binary value can only be true or false, e.g. “is the dipper trip activated”, “is Propel Brake Released”.
|
|
|
|
We start our query by selecting an analog value. We do this by going to the Analog Value Drop Down Box and ,in this case, selecting Machine Kilowatts.
|
|
|
|
|
|
After selecting a value the condition screen pops up. This allows you to select different types of conditions to put on your value:
- Dont’ Care (means ignore)
- “=” Equal to
- “<” Less than
- “>” Greater than
- “Between” Between two Values
In this case we select between and enter values of 2000 and 3000 KW.
There are several built in aids to help you make a correct selection. On the top of the condition window, the minimum and maximum values that can be display are shown.
There is also a hint button that will give a brief explanation of what the value is.
|
|
|
|
|
|
Near the bottom of the screen is a text area that shows the logic equation for your query.
|
|
|
|
|
|
If everything is as you want it, hit the accept button.
|
|
|
|
|
|
Running the Query |
|
|
|
|
|
Exit the Query Screen by using the “To Main Screen” Button from the main query Toolbar. As an alternative, you may use the “Start Search Button” which will go to the main screen and automatically start the Search.
|
|
|
|
|
Our controls will now be the run query toolbar located on the rightmost side of the replay toolbar.
|
|
|
|
|
|
|
|
The double arrows will start or continue a search from it’s present position. If it’s a new search, it always starts from the beginning of the the file
|
|
|
|
|
|
|
This one stops an active search, note: that the search is still in memory.
|
|
|
|
|
|
|
This button will restart the search at the beginning of the file.
|
|
|
|
|
|
|
A very nice feature of the search is that all hits are kept in memory. If you would like to go back to previous results, use this button.
|
|
|
|
|
|
|
After you have used the above button, use this one to reverse directions on the saved search results.
|
|
|
|
|
Adding Multiple Conditions |
|
|
|
The KW example was fairly simple with quite a few hits on a 495B Shovel. Now we’ll look at a more challenging example, we’ll find instances of Propel Counter rotation. This means that we want to know when left and right propel are going different directions.
This is made a little more challenging by the fact that the propel drives are shared with hoist and crowd. So let’s have a look.
|
|
|
|
The program has now inserted another logical AND in the search equation.
|
|
|
|
|
|
But Counter Rotation can occur in either direction, so we need to set another set of conditions, so we use the button and add one.
|
|
|
|
|
|
|
This will then add a logical OR to our search equation.
|
|
|
|
|
Now, add another set of conditions for the opposite direction. First Hoist...
|
|
|
|
Yields the final logic equation shown below. The parenthesis and the logic terms show how the query will be processed.
|
|
|
|
It takes a few minutes to set up a more complicated query like the Counter Rotation example. One you are happy with the results, you can save the search so it can be used on other files.
|
|
|
|
|
|
From the search screen, hit the “Save Current Search” button. Note: you must have selected some search criteria or the button will be disabled.
|
|
|
|
|
A file dialogue pops up. Just give it a name and it will be saved with an extension of “.SCH”.
|
|
|
|
Loading a Saved Search |
|
|
|
|
|
To load a saved search, hit the query screen toolbar button and select the saved search from the file dialogue screen.
|
|
|
