Query Builder

From WormBaseWiki
Revision as of 22:31, 12 November 2018 by Pnuin (talk | contribs)
Jump to navigationJump to search

WormMine QueryBuilder

You can setup your own queries by using the QueryBuilder. The builder is a powerful tool that allows the user to create queries that can span different classes in WormMine and overall different sources of information.

The easiest way to get acquainted with the QueryBuilder is to edit and modify a template (just click on the Edit Query button Querybuilder 1.png). The builder can be also accessed by clicking on the Select a Data Type to Begin a Query box from the QueryBuilder page, or by clicking the name of the class in the Data Model. By clicking on the class name, it will bring the builder interface shown below.

Querybuilder 2.png

There are two options to add items from the Model Browser side of the screen to the query:

  • Clicking on Show will transfer the item to the query and the result will have the items'information, meaning all elements with that item will be shown in the final table

Querybuilder 3.png

  • Clicking on Constrain will also transfer the item to query, but will ask for input regarding the constraint to be applied. If, for instance, Gene Name is selected, the dialog will ask for a match (=) or not (!=), or some other filter (boolean and wildcards accepted). The last piece of information is how the constrain join will be applied, where the filter will either HAVE or NOT a value. Take a look at the image below.