|
![](/web/20061206191649im_/http://ccinfoweb.ccohs.ca/images/blank.gif) |
Help - DSL/NDSL Field Searching |
![](/web/20061206191649im_/http://ccinfoweb.ccohs.ca/images/chempendium_lrg.gif) |
|
Each database/collection has an Advanced Search page which allows you to search in the specific fields for that database/collection. Using the Advanced Search page, you can:
- build your search step-by-step using the boxes at the top of the Advanced Search page,
or
- type your query statement, including all appropriate syntax, in the Query box.
To search in a specific field, click on the drop down button next to All Fields and select the desired field, e.g. IdentificationNumber. The most frequently searched fields are listed first. To find out the appropriate names of all fields, turn on the Field Help from the toolbar and click on the ? help symbol next to the field in any database record. You can now view the field name and its description.
Use the information below as a guide to executing detailed searches using the DSL/NDSL Advanced Search page:
Major Search Fields
Search Examples
Field Summary (Names To Be Used For Searching)
These are the frequently searched fields listed in the drop down list on the Advanced Search page.
Searching using: |
Finds information in these fields: |
AllFields |
All fields |
Name |
Substance Name
Masked Name (for confidential substances) |
IdentificationNumber |
CAS Registry Number
Confidential Number
Identification Number (includes Organism and Enzyme Identification Numbers) |
GazetteDate |
Gazette Date |
MolecularFormula |
Molecular Formula |
SubstanceType |
Substance Type |
Note: All fields have been indexed. Each field has a specific name which must be used for searching. Use the Field Summary to view the specific
"field names" to be used for searching. |
Tip: For a complete list of database fields, while viewing a database record, turn on the Field Help from the toolbar and click on the ? help symbol next to the field in any database record. You can now view the field name and its description, from the complete list of fields for the database. You can easily print this list, by clicking in the field help window, right-clicking and then selecting Print.
Tip: For searches from the Advanced Search page, multiple words are automatically treated as a phrase and find all forms of the words as a phrase.
Search Examples |
Finds all records |
Note: The best results are frequently found by searching using a CAS Registry Number. |
* <IN> GazetteDate |
with a Gazette Date field |
*2003 <IN> GazetteDate |
with --/--/2003 in Gazette Date
added or amended in the year 2003 |
sulfuric acid <IN> Name |
with the word sulfuric and acid in a Name field (either Substance or Masked name) |
"sulfuric acid" <IN> Name
|
with sulfuric acid in a Name field
|
7664-93-9
7664-93-9 <IN> IdentificationNumber |
both searches find sulfuric acid |
ATTC <IN> IdentificationNumber |
biotechnology products with an organism identification number |
* <IN> UVCB |
with a UVCB field |
Zn <IN> MolecularFormula |
with Zn in a molecular formula |
* <IN> CEPAReportingRequirements |
with a CEPA Reporting Requirements field |
Tip: Brackets have special meaning in searching, therefore, to search for chemical name containing brackets, e.g. Bis(chloromethyl) Ether, use Bis\(chloromethyl)\ Ether.
DSL/NDSL - Field Summary
You can search all the fields in the database. Each field has a specific name which must be used for searching. The table below summarizes the commonly used fields and gives the syntax of the field name to be used for searching:
Field Name |
Names To Be Used For Searching |
CAS Registry Number |
CASRegistryNumber |
Confidential Number |
IdentificationNumber |
Identification Number |
IdentificationNumber |
CAS Registry Number |
IdentificationNumber |
Substance Type |
SubstanceType |
Gazette Date |
GazetteDate |
Molecular Formula |
MolecularFormula |
Substance Name |
SubstanceName |
Masked Name |
MaskedName |
CEPA Reporting Requirements |
CEPAReportingRequirements |
Tip: For a complete list of database fields, while viewing a database record, turn on the Field Help from the toolbar and click on the ? help symbol next to the field in any database record. You can now view the field name and its description, from the complete list of fields for the database. You can easily print this list, by clicking in the field help window, right-clicking and then selecting Print.
|