D.15.9. Querying for Dossier

The system can retrieve:

either all Dossiers by using the Get all Dossiers query or
selected Dossiers using the Find Dossier or Find Dossier by subject query.

Get all Dossiers

To retrieve all Dossiers:

Go Home to the Task panel if you are not already there.
Under Dossier , click View. Click the Query button; a query window opens.
Select Dossier from the Select query result type drop-down list.
Select Get all dossiers from the Select query drop-down list.
Click the Search button. All Dossiers will be displayed in the Query result pane (under the title bar Navigation) in alphabetical order.

Find Dossier

To search for one or more Dossier(s) present in your IUCLID installation:

Go Home to the Task panel if you are not already there.
Under Dossier , click View. Click the Query button; a query window opens.
Select Dossier from the Select query result type drop-down list.
Select Find dossiers from the Select query drop-down list.
Enter at least one search criteria into one of the fields listed in the Query specific fields area (see the screenshot below).
Click the Search button, and the results of your query will be displayed in the Query result pane (under the title bar Navigation), otherwise the following message appears:
Specify a more general query to get to the expected result, or select another query (for more information, see the following subchapters).

Find Dossier by subject

A Dossier can be queried via several pre-defined queries:

by Classification and labeling (see chapter D.15.9.1 Find Dossier by C&L).
by Additive (see chapter D.15.9.2 Find Dossier by Additive).
by Constituent (see chapter D.15.9.3 Find Dossier by Constituent).
by Impurity (see chapter D.15.9.4 Find Dossier by Impurity).
by Joint submission (see chapter D.15.9.5 Find Dossier by Joint submission).
by Legal entity (see chapter D.15.9.6 Find Dossier by Legal entity).
by Mixture (see chapter D.15.9.7 Find Dossier by Mixture).
by Reference substance (see chapter D.15.9.8 Find Dossier by Reference substance).
by Legal entity site (see chapter D.15.9.9 Find dossier by Legal entity site).
by related Substance (see chapter D.15.9.10 Find Dossier by Substance).

D.15.9.1. Find Dossiers by Classification and Labelling

To retrieve Dossiers based on the classification and labelling of the submission Substance or Mixture:

Go Home to the Task panel if you are not already there.
Under Dossier click View. Click the Query button; a query window opens.
Select Dossier from the Select query result type drop-down list.
Select Find dossiers by C&L from the Select query drop-down list.
Enter at least one search criteria into one of the fields listed in the Query specific fields area (see the screenshot below).
Note
The Not classified checkbox has three possible status. Click directly on the checkbox to choose the status you want to define as search criteria:

D.15.9.2. Find Dossiers by Additive

To retrieve Dossiers based on the additives of submission Substance or Mixture:

Go Home to the Task panel if you are not already there.
Under Dossier click View . Click the Query button; a query window opens.
Select Dossier from the Select query result type drop-down list.
Select Find dossiers by additive from the Select query drop-down list.
Enter at least one search criteria into one of the fields listed in the Query specific fields area (see the screenshot below).

D.15.9.3. Find Dossiers by Constituent

To retrieve Dossiers based on the constituents of the submission Substance or components of the submission Mixture:

Go Home to the Task panel if you are not already there.
Under Dossier click View. Click the Query button; a query window opens.
Select Dossier from the Select query result type drop-down list.
Select Find dossiers by constituent from the Select query drop-down list.
Enter at least one search criteria into one of the fields listed in the Query specific fields area (see the screenshot below).

D.15.9.4. Find Dossiers by Impurity

To retrieve Dossiers based on the impurities of the submission Substance or Mixture:

Go Home to the Task panel if you are not already there.
Under Dossier click View. Click the Query button; a query window opens.
Select Dossier from Select query result type drop-down list.
Select Find dossiers by impurity from Select query drop-down list.
Enter at least one search criteria into one of the fields listed in the Query specific fields area (see the screenshot below).

D.15.9.5. Find Dossiers by Joint submission

To retrieve Joint Submission Dossiers:

Go Home to the Task panel if you are not already there.
Under Dossier click View. Click the Query button; a query window opens.
Select Dossier from the Select query result type drop-down list.
Select Find dossiers by joint submission from the Select query drop-down list.
Enter at least one search criteria into one of the fields listed in the Query specific fields area (see the screenshot below).

D.15.9.6. Find Dossiers by Legal entity

To retrieve Dossiers, based on the Legal entity owner of the submission Substance or Mixture:

Go Home to the Task panel if you are not already there.
Under Dossier click View. Click the Query button; a query window opens.
Select Dossier from the Select query result type drop-down list.
Select Find dossiers by legal entity from the Select query drop-down list.
Enter at least one search criteria into one of the fields listed in the Query specific fields area (see the screenshot below).

D.15.9.7. Find Dossiers by Mixture

To retrieve Dossiers based on related Mixture datasets:

Go Home to the Task panel if you are not already there.
Under Dossier click View. Click the Query button; a query window opens.
Select Dossier from the Select query result type drop-down list.
Select Find dossiers by mixture from the Select query drop-down list.
Enter at least one search criteria into one of the fields listed in the Query specific fields area (see the screenshot below).

D.15.9.8. Find Dossiers by Reference substance

To retrieve Dossiers based on Reference substance:

Go Home to the Task panel if you are not already there.
Under Dossier click View. Click the Query button; a query window opens.
Select Dossier from the Select query result type drop-down list.
Select Find dossiers by reference substance from the Select query drop-down list.
Enter at least one search criteria into one of the fields listed in the Query specific fields area (see the screenshot below).

Note

The resulting Dossiers are the ones matching the Reference substance specified in the section 1.1 Identification (see chapter E.1.1 Identification).

D.15.9.9. Find Dossiers by Legal entity Site

To retrieve Dossiers based on Legal entity site:

Go Home to the Task panel if you are not already there.
Under Dossier click View. Click the Query button; a query window opens.
Select Dossier from the Select query result type drop-down list.
Select Find dossiers by site from the Select query drop-down list.
Enter at least one search criteria into one of the fields listed in the Query specific fields area (see the screenshot below).

D.15.9.10. Find Dossiers by Substance

To retrieve Dossiers based on related Substance datasets:

Go Home to the Task panel if you are not already there.
Under Dossier click View. Click on the Query button; a query window opens.
Select Dossier from the Select query result type drop-down list.
Select Find dossiers by substance from the Select query drop-down list.
Enter at least one search criteria into one of the fields listed in the Query specific fields area (see the screenshot below).