Before you begin building your query

Before you start creating your query, let's go through these tips. Keep this section in mind, you will probably come back to it from time to time.

• Prepare or plan the query definition in a structured format (line-by-line) before creating it in Oracle Healthcare Translational Research.
• When you want to search for a criterion, but can't exactly remember the name or the code, just click Search without selecting any conditions, or adding a keyword. The entire list of codes and names appears.
• Every criterion you want to add in your query can be included as an inclusion or exclusion. When you select either option, it applies to all of the elements in that criterion.
• By default, most dialog boxes for choosing criteria use the Equals operator and list the first 100 types only. If there are more than 100 types for one criterion that you want to include in your query, you can search for them using other operators such as Starts with, Contains, and so on.