Rocscience International Conference 2025 is going to take place in Sydney, Australia Read more

Search Results

Create a Query Expression

The first step in creating a query, is to create an Expression. As you can see at the top right of the Filter Data dialog, an Expression consists of Data, Operator and Operand.

Expression Dialog

For example, the following are valid Expressions:

TYPE == joint

SPACING < 1.5

Set != 2

Data

The Data drop-down list will always contain:

  • The names of the columns of the current file, in order of appearance in the spreadsheet, followed by

NOTE: The user CANNOT type in the Data box, an item must be selected from the list. This prevents errors due to incorrect typing.

Expression Dialog

Operator

The Operator drop-down list will always contain the following operators:

  • == (equals)
  • != (not equals)
  • < (less than)
  • <= (less than or equals)
  • > (greater than)
  • >= (greater than or equals)
  • Includes (find data containing a given substring)

Note that the behaviour of the < , <= , > and >= Operators depends on the nature of the Operand. If the Operand is numeric, then the comparison will be numeric. If the Operand is a text string, then a string comparison will be performed.

NOTE: The user CANNOT type in the Operator box, an operator must be selected from the list. This prevents errors due to incorrect typing.

Expression Dialog

Operand

The Operand drop-down list will contain a sorted list of the data in the Data column you have selected (i.e., the Data box at the left of the Expression). Note that the sorting of the Operand list is based on a string comparison, therefore numeric Data will not necessarily be listed in numeric order (i.e., the numbers 2, 3, 200 would be listed in the order 2, 200, 3).

The Operand drop-down serves two purposes:

  1. It shows the user the contents of a selected Data column.
  2. It allows the user to select from the list with the mouse.

However, unlike the Data and Operator boxes, the user CAN TYPE in the Operand box. This allows the user to type in specific numeric values, or to type in substrings to be searched for by the Includes Operator, for example.

Expression

Rocscience logo, click here to return to the homepage Portal Account Portal Account Log In Log Out Home Shopping Cart icon Click here to search our site Click here to close Learning Tech Support Documentation Info Chevron Delete Back to Top View More" Previous Next PDF File Calendar Location Language Fees Video Click here to visit Rocscience's LinkedIn page Click here to visit Rocscience's YouTube page Click here to visit Rocscience's X page Click here to visit Rocscience's Facebook page Click here to visit Rocscience's Instagram page Click here to visit Rocscience's Reddit page Bookmark Network Scroll down for more Checkmark Download Print Back to top Single User Multiple Users RSLog RocFall3 CPillar Dips EX3 RocFall RocPlane RocSlope3 RocSupport RocTopple RS2 RS3 RSData RSPile Settle3 Slide2 Slide3 SWedge UnWedge RocTunnel3 RocSlope2 BlastMetrix ShapeMetriX Fragmenter Commercial License Education License Trial License Shop safe & secure Money-back guarantee