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
Select Log File
Query Screen
Running a Query Multiple Conditions
(Advanced Queries)

Select a Log File

Set Search Conditions Create a Simple Query
Saving a Search Loading a Search
Select a File

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.

Select a file2
Back to Topic Top of Page

Enter the Query Screen

Querry Button

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.

Full Querry Screen

The toolbar has most of the functions disabled.  As they become available to you, they will be enabled.

Querry Toolbar 1
Back to Topic Top of Page

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.

Select Analog Value 1

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.

Setting Analog Conditions
Analog Values Range
Analog Values Hints

Near the bottom of the screen is a text area that shows the logic equation for your query.

Logic Equation for KW only

If everything is as you want it, hit the accept button.

Accept Analog Values
Back to Topic Top of Page

Running the Query

To Main Screen Button
Start Search Button

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.

Run Search Toolbar
Continue Search Button

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

Stop Active Search Button

This one stops an active search, note: that the search is still in memory.

Restart Search Button

This button will restart the search at the beginning of the file.

Search Go Back Button

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.

Search Go Forward Button

After you have used the above button, use this one to reverse directions on the saved search results.

We hit

Continue Search Button

to get started

and we get our first hit at 12:00:04

We hit

Continue Search Button

again, and our

next hit is at 12:00:45

We hit

Continue Search Button

again, and our

next hit at 12:00:50

kw query 2 kw query 3
KW query 1
Back to Topic
Top of Page

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.

Querry Button

First, go back to the Search Condition Screen.

Clear All Condition Button

Now, let’s clear all conditions to get rid of the old search.

Select Hoist Speed

Make the condition greater than 100 RPM

Hoist Speed Select 2
Hoist Speed Select 1

Visually confirm the right setting

Hoist Speed Select 3

Now set a condition for Crowd speed of less than -100 RPM. Be careful of polarities

Note than a logical AND was inserted in the search string between the hoist and crowd conditions.

Crowd Speed Select 2
Crowd Speed Select 1

Because crowd and hoist are shared drives, we must set another condition to make sure we are in Propel. Here we choose “Propel Brake is Released”.

Propel Brake Select 1

We choose the condition “is released”

Propel Brake Select 2

The program has now inserted another logical AND in the search equation.

Propel Brake Select 4
All a new condition set button

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.

Propel Brake Select 5

This will then add a logical OR to our search equation.

Now, add another set of conditions for the opposite direction. First Hoist...

Then Crowd...

Crowd Speed Select 3
Hoist Speed Select 4

Propel Brake must be included again...

Propel Brake Select 3

Yields the final logic equation shown below. The parenthesis and the logic terms show how the query will be processed.

Final Logic Equation

Does it work?

Counter Rotation find1

And here’s the other direction.

Counter Rotation find2
Back to Topic Top of Page

Saving Your Search

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.

Button Save Search

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”.

Save Search Dialogue
Back to Topic Top of Page

Loading a Saved Search

Button Load Search

To load a saved search, hit the query screen toolbar button and select the saved search from the file dialogue screen.

Load Search Dialogue
Back to Topic
Top of Page

[Home] [Thermal Analysis] [Report Detail] [New for Shovels] [Trucks] [Developers Comments] [Communications] [Draglines] [Advanced Queries]