Search - Advanced Query Techniques

Last Updated: Apr 09, 2016 02:53PM PDT

Summary: In addition to the basic search options, block conditions are available to build more complex queries.

Covered Topics

Clicking a link will scroll the page to the relevant section.

Getting Started with Query Building

  1. To build a query, use the Append Query button that is available from any of the search tabs (Projects, Structure, Assay).

 scloud_append_query_overview.png

  1. The Query tab opens, displaying the search criteria. Use the Query tab to conduct more complicated searches (explained in the table below). This tab is only available after a query is appended with search criteria.

 scloud_query_tab_overview.png

Using the Query Tab to Search

To Do this
Open the Query tab and view the current search criteria From any of the search tabs (Projects, Structure, Assay), click Append Query. The Query tab opens and displays the current search criteria.
Run a search from the Query tab Click Submit Search. The results of the query are displayed in the Results tab.
Save a set of query conditions for future search
  1. Click Save Query. The Save Query dialog opens.
  2. Enter text in the Name and (optional) Comment fields.
  3. Click Save to save the new query.

 scloud_save_query_dialog.png

Note: The newly saved query can be accessed from the Query Management page (described below).

Clear query conditions From the query tab, click New Query. The Query tab closes and the Project tab becomes the active tab visible in the program window.

Building Queries with Multiple Block Conditions

For more flexibility in defining search criteria, conditions can be set up as blocks that are separated by conditional operators (And, Or, Xor, Minus). These operators are based on Boolean logic illustrated in the following table.

Definitions of Conditional Operators

Operator Description (what it does) Example
And Narrows the search to include whatever is in A, B, and C combined. scloud_conditional_and.png 
Or Expands the search by broadening the set to include any combinations of A, B, and C (like "Either Or").  
Xor Also called "Exclusive", it defines the search as everything EXCEPT what A and B have in common.

scloud_conditional_xor.png

Note: For further details, go to http://en.wikipedia.org/wiki/Exclusive_or.

Minus

A-B: Everything in A that is not also in B.

B-A: Everything in B that is not also in A.

scloud_conditional_minus_a-b.png

Setting up Block Conditions for a Search

  1. Define the basic search criteria from any of the search tabs (Projects, Structure, Assay).
  2. From the open search tab, click Append Query. The Query tab opens and displays the search conditions in a block.
  3. Repeat the above steps for each set of conditions to include in the advanced query. Each time Append Query is used with a new set of search conditions, a new block is displayed in the Query tab. The first block is identified as "A", the second as "B", and so forth.
  4. For each block, select a conditional operator (And, Or, Xor, Minus) based on the intended results. The query is spelled out in the top-left using the letter designations "A", "B", etc. This is useful to ensure the correct statement is selected for each block.

scloud_append_query_example1.png

Tips:

  • To change the order of blocks, click the Move Up and Move Down arrows.

scloud_append_query_arrows.png

  • To further refine the search conditions, click the parenthesis to select one, two, or three parenthesis around each statement.  

 scloud_append_query_parenthesis.png

  • When clicking the parenthesis on line A, it appears before the entire statement. When clicking the parenthesis on line B, it appears in front of B in the statement. The ability to add extra parenthesis is especially useful with long query statements (much like an algebraic problem.)

 scloud_append_query_parenthesis2.png

A particular set of search conditions might yield different results, depending on how conditions are grouped together – in a traditional search or in a single block, or if each condition is listed in a separate block. A query can be set up differently in each instance and the search will be conducted differently. For further information, contact ScienceCloud Technical Support at biovia.support@3ds.com.

Modifying a Block Condition

  1. Click Edit Query  scloud_append_query_edit_icon.png.
  2. Use the associated search tab that opens (Projects, Structure, or Assay) to modify the search criteria.
  3. Click Update Query to save the changes and return to the Query tab. The updated block will be displayed, showing the latest conditions.
  4. To revert back to the previous set of conditions for a block, click Cancel Update.

Deleting a Block Condition

  • Click Delete Query  scloud_append_query_delete_icon.png.
Related
Basic Searching:

Searching (Basic Techniques)  |  Searching (Projects and Libraries)  |  Searching (Chemistry Data)  |  Searching (Biological Data)

Querying:

Searching (Query Management)

Search Results:

Search Results (Navigating)  |  Search Results (Viewing Compound Details)  |  Search Results (Exporting)


http://assets1.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete