Summary: In addition to the basic search options, block conditions are available to build more complex queries.
Clicking a link will scroll the page to the relevant section.
- Getting Started with Query Building
- Building Queries with Multiple Block Conditions
- Setting up Block Conditions for a Search
- Modifying a Block Condition
- Deleting a Block Condition
Getting Started with Query Building
- To build a query, use the Append Query button that is available from any of the search tabs (Projects, Structure, Assay).
- 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.
Using the Query Tab to Search
|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||
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.|||
|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.||
Note: For further details, go to http://en.wikipedia.org/wiki/Exclusive_or.
A-B: Everything in A that is not also in B.
B-A: Everything in B that is not also in A.
Setting up Block Conditions for a Search
- Define the basic search criteria from any of the search tabs (Projects, Structure, Assay).
- From the open search tab, click Append Query. The Query tab opens and displays the search conditions in a block.
- 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.
- 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.
- To change the order of blocks, click the Move Up and Move Down arrows.
- To further refine the search conditions, click the parenthesis to select one, two, or three parenthesis around each statement.
- 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.)
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 firstname.lastname@example.org.
Modifying a Block Condition
- Click Edit Query .
- Use the associated search tab that opens (Projects, Structure, or Assay) to modify the search criteria.
- Click Update Query to save the changes and return to the Query tab. The updated block will be displayed, showing the latest conditions.
- To revert back to the previous set of conditions for a block, click Cancel Update.
Deleting a Block Condition
- Click Delete Query .