Advanced Searching Filtering
When browsing many of the tables in ORCA, you are presented with the opportunity to filter/search the results presented using a global filter or using a more granulated advanced search. These can both be accessed as shown in the screenshot below.
If you type in a simple phrase into the global filter field, and click the filter button, you will be performing a search across most of the columns displayed (some columns are skipped if searching is problematic). This is a very general search and should be used just for quick access to a subset of data that can be easily filtered for. For more complex filtering on individual columns, you will need to use the advanced search options.
Advanced searching allows you to more finely tune your query. Advanced searches allow for individual values applied to each column. Advanced searches also provide a wider variety of fields types to search on. In addition to text based fields, you can also search by numeric ranges and other non-text based data.
By default, the advanced search fields act as an AND based boolean search. If you search, for example, for "STE11" in column 1, and then a numeric value of "1.95" in column 5, the result will be rows where column 1 contains STE11 AND column 5 contains 1.95. OR searching can be performed on individual fields. To search column 1 for both STE11 and KSS1, you can separate the terms with a vertical bar. For example: STE11|KSS1 in column 1 and 1.95 in column 5 would now return any row where column 5 is 1.95 and column 1 contains STE11 OR KSS1.
By default, all searches are exact match searches in both the global and advanced searches (unless using numeric ranges). So, for example, if you search for "STE11" you will receive rows containing exactly STE11 only. If you want to perform a wildcard search, you can do so by using the * character. So, if you search for STE* you'll now receive results containing STE1, STE2, STE3, STE4, etc.