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.

    {primary} 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.

    {primary} 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.

    {primary} 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