Executing Queries

After you define a query, execute a search by using the buttons located at the bottom of the Query window:

Button

Action

Clear

set the search criteria in the Query window to default (null) values

Show All

reset the settings and execute the query so that all records are present

Search

execute the search based on the currently specified criteria

During query execution, the progress is shown in the bottom right corner of the interface.

Before IJC 16.3.7.0 Clear Query cleared the query definitions, but the Structure Editor (Marvin, ChemDraw) "remembered" the last drawn molecule for convenience of drawing similar molecule in the next query definition. This behaviour was changed for simplicity and now Clear Query not only clears the query definitions, but also the Structure Editor.

Cancelling queries

A slow running query can be cancelled images/download/attachments/1805161/StopQuery24.png . A progress dialog will appear if the query takes a significant amount of time to execute and the query execution can be stopped by clicking on the 'images/download/attachments/1805161/StopQuery24.png ' button.

The ability to stop a query is dependent on the type of query and the stage of execution it has got to - stopping will not always be successful.

images/download/attachments/1805161/StopQuery.png

See the Performance tips tips and tricks page for suggestions about how to speed up slow searches.

Re-executing previous queries

Previous queries can be restored to the query panel using the Recent queries... drop down menu. This sets the query parameters and allows you to re-execute the query or to edit the query before executing it.

The Lists and Queries window also provides a mechanism to re-execute previous queries

images/download/attachments/1805161/recent-queries.png

Restricting searches to a list

By default, a query is applied across the entire database. However, you can narrow the search so that it is applied to a list. As a result, you are able to perform queries within results attained from previous queries. Use the Domain drop-down in the Query window for this purpose. Below, the Domain drop-down shows that the next query will be restricted to a particular list:
images/download/attachments/1805161/query-domain.png