How to set operations for queries in QueryBuilder

QueryBuilder is a GVERSE GeoGraphix module that allows you to design filters and conduct queries using data from the GeoGraphix database (WellBase, LeaseMap, and SeisBase). The interpreter can use this tool to retrieve data selectively by searching the database for wells, tracts, leases, and other items based on user-defined criteria. By filtering the database, you can avoid handling a huge number of wells or well-related data, leases, tracts, and so on, and instead focus on the data that satisfies certain criteria.

The Set Operations tool is one of the tools in QueryBuilder. Using intersection, union, and inversion of data, interpreters can design filters with this tool.

Intersection: Will create a new list of all wells that are included in all of the selected filters (two or more). This can be considered an “and” command applied to two or more filters and wells will be selected only if they meet the criteria of all the selected filters.

Union: Creates a new list of all Wells that are included in all of the selected filters (two or more). Union can be considered an “or” command applied to two or more filters and wells will be selected only if they meet the criteria of all the selected filters.

Inversion: Creates a new list of all the wells in a project or AOI that do not meet the criteria of the selected filter or filters.

Here is a step-by-step guide on how to set operations for queries in QueryBuilder and create filters base on those operations:

Activate a GVERSE GeoGraphix project and open QueryBuilder by clicking on its icon in the modules bar.

You can either create a new filter or use an existing one. To open an existing filter, click QueryBuilder and then Open Filter.

The WellBase filter list will appear. Select a filter and click Open.

The filter will appear on QueryBuilder.

To create a new filter, expand the data that you want to use for the filter.

Select and drag the data to the small boxes on the right.

Add all the data to be used for the filter and click Run. The results will appear.

To save the filter, click on QueryBuilder and then on Save Filter As. The WellBase Filters window will open where you can add a name and click Save.

To apply any set operations, go to tools and click Set Operations.

The Filter Set Operations window will open, displaying all the filters in the project and the three operations.

Selecting Inverse of one or more filters creates a new list of all the wells in a project or AOI that do not meet the criteria of the selected filter or filters. Select the filter(s) and click OK.

The filter will automatically apply and display all the wells with less than 10,000 ft (78 wells in total).

Selecting Intersection of two or more filters will create a new list of all wells that are included in all of the selected filters (two or more). This can be considered an “and” command applied to two or more filters, and wells will be selected only if they meet the criteria of all the selected filters. Select the two filters, add a name, and click OK.

All the Top Five Players wells deeper than 10,000 ft will appear on the well list.

Selecting Union of two or more filters can be considered an “or” command applied to two or more filters, and wells will be selected only if they meet the criteria of all the selected filters. Select the two filters, add a name, and click OK.