Skip Headers

Oracle® Argus Insight User's Guide Release 7.0.3 E48117-01 |
Home | Book List | Contents | Contact Us

Previous | Next
| PDF · Mobi · ePub

# 6 Working with Libraries

Argus Insight provides a library that serves as a repository for all queries. This library, called the Query library, contains all the saved queries performed using QBEs, filters, and advanced conditions.

In addition, from the Associated Reports library, you can search for queries or case series that have a report associated with them.

This chapter includes the following topics:

- Viewing Save Queries in the Query Library

- Viewing All Reports Associated with a Query or Case Series

## 6.1 Viewing Save Queries in the Query Library

To view a list of all the saved queries, navigate to Queries, Library, and select Query Library. The QUERY LIBRARY page opens. See Figure 6-1

The QUERY LIBRARY page displays the following information about each query:

- Name of the query.

- Brief description of the query.

- Date when the query was last modified.

- Type of query (Advanced Condition, Filter Value Set, or Query By Example)

- Full name of the user who created the query.

- Category where the query is saved. The default categories are Case Processing, Compliance, Configuration, General, Management, and Pharmacovigilance.

- Number of reports, if any, associated with the query.

Figure 6-1 QUERY LIBRARY Page

### 6.1.1 Associating a Query in the Query Library

To associate a report to a query in the query library:

1. Navigate to the QUERY LIBRARY page.

2. Select a query from the list.

3. Click Associate to open the Scheduled Reports Group dialog box.

4. Select a report group and click Modify.

5. Make the necessary modifications and click OK.

6. Click Execute to execute a report.

   Note that the Execute button is available only if the group has just one report in it.

### 6.1.2 Deleting a Query from the Query Library

To delete a query from the query library:

1. Navigate to the QUERY LIBRARY page.

2. Select a query from the list.

3. Click Delete. The system prompts for confirmation that you want to delete the query.

4. Click OK.

### 6.1.3 Disassociating a Report in the Query Library

To disassociate a report from the query library:

1. Navigate to the QUERY LIBRARY page.

2. Select a query from the list.

3. Click Disassociate. The system prompts for confirmation that you want to remove the report association.

4. Click OK.

## 6.2 Viewing All Reports Associated with a Query or Case Series

To view a list of all the reports associated with a query or a case series, navigate to Reports and select Associated Reports Library. The ASSOCIATED REPORTS LIBRARY page opens. See Figure 6-2.

The ASSOCIATED REPORTS LIBRARY page displays the following information:

- Name of either the query or the case series associated with the report.

- Brief description of the query or case series associated with the report.

- Name of the report associated with the query or case series.

- Type of query (Advanced Condition, Filter Value Set, or Query By Example) if the report is associated with a query or the words Case Series if the report is associated with a case series.

- Full name of the user who created the query or case series.

- Status.

The Limit Query to Active Case Series check box is enabled only if the report is associated against a query. The check box is disabled for all reports associated against a case series.

Figure 6-2 ASSOCIATED REPORTS LIBRARY Page

### 6.2.1 Modifying a Query or Case Series in the Associated Reports Library

To modify a query or case series in the associated library:

1. Navigate to the ASSOCIATED REPORTS LIBRARY page.

2. Select the query or case series that you want to modify.

3. Click Modify. The Scheduled Reports Group dialog box opens.

4. Select any report group and click Modify.

5. Make the necessary modifications and click OK.

6. Click Execute to execute a report. The Execute button is available only if a group has just one report in it.

### 6.2.2 Disassociating a Report in the Associated Reports Library

To disassociate a report from the associated report library:

1. Navigate to the ASSOCIATED REPORTS LIBRARY page.

2. Select a report from the list.

3. Click Disassociate.

4. Click OK.