Advanced Query Tool 3.3.1 serial key or number

Quick Search Field

With the Quick Search Field, you can perform a search regardless of the page in the content area. The Quick Search field performs a substring search of the title and content ID metadata, and the indexed full-text if it is supported on your system.

A substring search is equivalent to including a wildcard at the beginning and end of the search term. For example, if you enter in the Quick Search field, the search returns items with words such as , , and in the title or content ID metadata, or in the indexed full-text if it is supported on your system.

You or your system administrator can also build custom searches targeted to search one or more metadata fields you specify, and make them available through the Quick Search field. You can create targeted searches with either the Query Builder Form or Expanded Form.

The Quick Search field supports Internet-style search syntax, complex construction, and alternate query formats. For more information, see Section , "Using Additional Search Capabilities."

Home Page Search Fields

With the search fields on the Home Page, you can perform a metadata search, a full-text search, or a combination of both. Only the most commonly used search fields are available from the home page.

Search Tray

With the Search Tray, you can perform a metadata, full-text, or combination search. Only the most commonly used search fields are available from the Search tray.

The Criteria Tab on the Search Tray displays a form where you can enter your criteria. The Results Tab displays the search results.

Advanced Search Page

With the Advanced Search Page, you can perform a metadata search, full-text search, or a combination of both on all available fields.

To access this page, click the Advanced link in the Search Tray or use the Search menu on the Toolbar.

The expanded form on the Advanced Search Page displays all search fields available to you on a single page. You can alternate between the expanded form and the query builder form using the Search Forms menu at the top of the search page.

You can also select a different search profile from the Switch Profile menu, if your system administrator has defined them for you. You can specify the default search form to use the Advanced Search page. For more information, see Section , "User Profile Page."

Query Builder Form

The Query Builder Form creates and saves complex queries by selecting options from a series of lists. After a query is built, you can edit the query directly, perform the search, or save the query for easy access from My Saved Queries.

With the Query Builder form, you can separate the metadata fields with either the <AND> operator or the <OR> operator. If you use the <AND> operator, then each search criteria entered into each field must be met to return a result.

If you use the <OR> operator, then only one of each field's criteria must be met. For example, if you enter into the Title field and into the Type field separated by <OR>, then results include content that has either as the type or has in the title.

Displaying Search Results

Use the following procedure to specify how to display the search results:

1. Display the Home Page Search Fields or Advanced Search Page.

2. Scroll down to the Results Options.

3. Set Results Per Page to the maximum number of content items to display on each Search Results Page.

4. Specify the Sort By method and order.

5. Click Search.

6. From the Content Actions menu on a Search Results Page, choose the view option to specify the search results view.

Changing the Search Results View

Use the following procedure to change the default search results view:

1. Display the User Profile Page.

2. Scroll down to the Search Template option.

3. Click Search Template, and select the search result view.

4. Click Update.

Classic View Template

The Classic template lists content items sequentially in single rows, based on the default sort field and order set on the User Profile Page.

Headline View Template

The Headline template by default lists items in a single line, with a minimum of information. The Headline template uses the sort field, sort order, and result count fields on the User Profile Page to arrange the results.

Thumbnail View Template

The Thumbnail template by default lists items in a grid from left-to-right and top-to-bottom and displays an icon based on the content type, or a thumbnail image of the content if your system administrator has set up Content Server to create one. This template is particularly suited for displaying images and other graphic content. The grid arranges results based on the sort field and order set on the User Profile Page.

Creating a Custom Search Result Template

Use the following procedure to create a custom search result template:

1. Navigate to the Search Result Templates for User Page.

2. Click the Add Template icon in the Actions column next to the provided List template on which you want to base your custom template. The Create Custom Template page opens.

3. If your custom template is not based on the provided Headline View template, skip to the next step. If your custom template is based on the Headline View template, select a metadata field to display as a column from the Available Fields box, and click the right arrow. The selected metadata field is added to the Columns field. You must select and move each field separately.

   To reorder the column display, use the up and down arrows next to the Columns field. Click the up arrow to move the selected column to the left in the results template. Click the down arrow to move the selected column to the right in the results template.

4. Select a metadata field to display in the Description column from the Available Fields box, and click Move Here beneath the Description box. The metadata field is added to the Description box. You must select and move each field separately.

   To reorder the column display, use the up and down arrows next to the Main Information field. Click the up arrow to move the selected item up in the Description column. Click the down arrow to move the selected column down in the Description column.

   Important:

   To display the selected fields, you must also display the Description metadata field as a column.

5. Click Save.

   For more information about custom search result templates, see Section A.3, "Creating and Editing Custom Search Result Templates."

About Saved Queries

To quickly display results for a search that you perform often, you can save the search in the My Saved Queries folder in the My Content Server Tray.

After you save a query link, you can modify or delete the link from your Saved Queries Page.

You or your system administrator can also build custom searches targeted to search one or more metadata fields you specify, and make them available through the Quick Search field.

Saving a Query

Use the following procedure to save a search as a query link on the Saved Queries Page:

1. Specify the search criteria you want to save.

2. Choose Save Search from the Actions menu on the Search Results Page.

   A prompt dialog opens.

3. Enter a title to use as the link name for the saved query.

4. Click OK.

   The new link is shown under the My Saved Queries tray.

Rerunning a Recent Query

Use the following procedure to rerun a recent query.

To rerun a recent query:

1. Open the My Recent Queries folder in the My Content Server Tray.

2. Double-click the link for the query you want to run.

   The output from the query displays on your Search Results Page.

Clearing Recent Queries

Use the following procedure to clear all recent queries from your My Recent Queries tray.

To clear recent queries:

1. Open My Recent Queries in the My Content Server Tray.

2. Double-click the Clear link.

   Content Server deletes all links except Clear from the My Recent Queries folder.

Creating Quick Search Queries

Use the following procedure to build a targeted search available through the Quick Search field. You can create targeted searches with either the Query Builder Form or Expanded Form. To customize the query string directly, you must use the Query Builder Form as shown in this procedure.

1. Click My Quick Searches in the My Content Server Tray.

   The Quick Searches Page opens listing any existing quick search queries that you or an administrator have created. You must be an administrator to modify the quick searches defined by administrators.

2. To create a new Quick Search, click Create New beneath the My Quick Searches area.

   To edit an existing Quick Search, choose Edit from the associated Actions menu.

   The Create/Edit Targeted Quick Search Page opens.

3. From the Search Form menu, select the form to use to create the search query.

   The form you select when you create the quick search is the form you must use when you edit the quick search (the Search Form menu is not available when you edit an existing quick search.)

   The Expanded Form is selected by default. If you want to manually edit the query text, use the Query Builder form. For more information about these forms, see Section A, "Advanced Search Page."

4. Specify a Quick Search Key to select the search from the Quick Search list. Use lower case letters or numbers. Searches are listed in ascending order based on this key.

   Duplicate keys within the My Quick Searches table are not allowed. Although it is best to use a single character, you can use multiple character keys to avoid duplicate key names. Only the first character acts as the shortcut. For Example, if you have keys a1, a2, and a3, the first time you press a, you select the search associated with key a1. The next time you press a, you select the search associated with key a2, and so on.

5. Specify the Quick Search Label to display in the Quick Search list.

6. Enter #s in one or more fields to represent the search terms entered by the user in the Quick Search field. To further restrict the search, you can provide specific values for one or more search fields, but you must include #s in at least one field.

   If you use the Query Builder form, you can manually edit the query when you click show advanced query builder options and then select Modify Query Text.

   For example, if you select the date field, the On or After operator, and specify #s to represent the user input, the resulting query text is:

   dInDate >= `#s`

   To create a query that shows check-ins within the last specified period of days, subtract the number of days entered by the user from the current date returned by the dateCurrent function:

   dInDate > `<$dateCurrent(-#s)$>`

7. Specify the number of results to show on each page, or use the default.

8. Specify how to sort the results, or use the defaults.

9. Specify the template to use to format the results, or use the default.

10. Click Save.

    The searches you create are displayed under My Quick Searches in the Quick Search menu.

Note:

In addition to the options outlined here, Content Server can integrate with other search engines. Check with your system administrator to see what options are available to you.

Searching with Oracle Text Search

If your system administrator has configured the Oracle Text Search option, you can specify full-text and metadata searches and select options to filter the results of a search by categories.

Oracle Text Search can filter and extract content from different document formats in different languages. It supports a large number of document formats, including Microsoft Office file formats, Adobe PDF, HTML, and XML. It can render search results in various formats, including unformatted text, HTML with term highlighting, and original document format.

This section covers the following topics:

Searching with the Expanded Form

On the Expanded Form, you can specify a metadata search, a full-text search, or both to identify a content item or items to search for. Also, you can specify result options.

Figure shows part of the Expanded Form for specifying Oracle Text Search queries.

Figure Expanded Form for Oracle Text Search

To specify a search on the Expanded Form:

1. On the Content Server home page, display the Home Page Search Fields from the Search menu or the Search Tray.

2. In the Metadata Search area of the Expanded Form, you can enter one or more search criteria for metadata fields:

3. In the Full-Text Search area, you can enter text to search for in a content item or items, to refine your search.

4. In the Results Options area, you can change the Results Options for displaying the results.

5. To save the search query under My Saved Queries, click Save.

6. To run the search query, click Search.

The content item or items that match your search criteria are displayed on the Search Results Page.

Filtering Search Results

The Search Results Page displays a menu bar with metadata categories you can use to filter the search results. Each category lists values that are valid for the particular search results. The system administrator can add or remove categories. The default set of categories include Content Type, Security Group, and Account.

Figure Search Results with Oracle Text Search Default Menu

An arrow next to the category name indicates that the search results include multiple values for that category. When you move your cursor over the option name, a menu displays the list of the values found in the search results for that category and the number of content items for each value. Click a value to filter the Search Results Page to list only the items that have the selected value in the selected category.

Figure shows a list of categories under Security Group and the number of items found in each category.

Figure Search Results with Expanded Oracle Text Search Menu

Searching with the Query Builder Form

On the Query Builder form, you can select search criteria from menus as required. You can build and save complex queries by selecting options from a series of lists. You can also manually edit the query text.

Figure shows the Query Builder Form for specifying Oracle Text Search queries.

Figure Query Builder Form for Oracle Text Search

To specify a search on the Query Builder Form:

1. On the Content Server home page, display the Home Page Search Fields from the Search menu or the Search Tray.

2. On the Search Forms Menu, choose Query Builder Form.

3. To edit the query, click show advanced query builder options, and then choose Modify Query Text.

   For example, if you select the date field, the On or After operator, and specify a date, the resulting query text is similar to the following:

   dInDate >= `9/22/11 AM`

   To create a search that shows check-ins within the last specified period of days, subtract the number of days (7 in the example below) from the current date returned by the dateCurrent function:

   dInDate > `<$dateCurrent(-7)$>`

4. In the Results Options area, you can change the Results Options for displaying the results.

5. To save the search query under My Saved Queries, click Save.

6. To run the search query, click Search.

Searching with Database Metadata Search

This section covers the following topics:

Searching with Database Full-Text Search

This section covers the following topics:

Metadata Wildcards

A wildcard substitutes for unknown or nonspecific characters in the search term. You can use wildcards in metadata searches, even when using the Quick Search field.

Use the following wildcards in metadata search fields:

• An asterisk () indicates zero or more alphanumeric characters. For example:

  • matches and

  • matches and

  • matches , , , and

• A question mark () indicates one alphanumeric character. For example:

  • matches and , but not or

  • matches but not

Internet-Style Search Syntax

Search techniques common to the popular Internet search engines are supported in Content Server. For example, entered in the Quick Search field searches for , while searches for . The following table lists how Content Server interprets common characters.

The following table lists examples of how Content Server interprets Internet-style syntax in a full-text search.

The following table lists examples of how Content Server interprets Internet-style syntax when searching title metadata using the substring operator.

Complex Queries and Alternate Query Formats

Content Server allows for the use of parentheses for complex query construction and and formats when creating a query. By using these alternatives, you can more easily search the metadata field you want across multiple servers, if necessary, and refine your results. For example, to search only the title metadata for without having to go to the Advanced Search page, enter into the Quick Search field. The search looks only in the field you specified before the colon. You must know the Content Server identifier for the metadata field you want to search.

The following table lists some examples of complex and alternate query formats.

Note:

Because the Link Manager component extracts the URL links during the Content Server indexing cycle, only the URL links of released documents are extracted. For content items with multiple revisions, only the most current released revision is available for searching.

About Searching Links

Use the Search Links Page to search for links, using criteria stored in the repository database. Use this page to validate links, to determine where a resource is used, to determine if deleting a content item affects other documents, and so on.

The Link Search Results Page displays items matching your search criteria. Invalid or broken links are listed in bold font. Each item has an Link Item Actions Menu and an Info icon which displays a Link Info Page.

Link References on the Content Information Page

Use the References options to see whether the content item references or is referenced by other content items. References provides two options:

• Show: By default, the links are hidden when the Content Information page opens. Click Show to display all applicable links. If this content item contains one or more references to other documents, then these links are listed in the Links contained in this content item section. If other documents reference this content item, then those references are listed in the Links to this content item section.

  Links that are invalid or broken are listed using bold font. Click the Info link in the Actions column to display the Link Info Page for that particular link.

• Hide: Click Hide to hide the link information.

To access the available link information for content items, click any Content Information icon, which displays the Content Information Page and the References options. Or, you can choose either Content Information or Target Content Info from the Link Item Actions Menu, which also displays the Content Information page and the References options.

Notification of Expiration

With Link Manager installed, the Notification of Expiration page includes additional information for each content item that is expiring soon. The e-mail notification specifies if the expiring content item is referenced by another content item:

• Is Referenced: Yes

• Is Referenced: No

The e-mail does not provide a list of the content items that reference the soon-to-expire document. This information is available in the References section on the Content Information page. For more information, see Section , "Checking Content Item Link References."

If the Content Server configuration variable () has been enabled, an e-mail notification is sent to each author when content expires. For more information about setting this configuration variable, see "EnableExpirationNotifier" in the Oracle WebCenter Content Idoc Script Reference Guide.

Figure Notification of Expiration E-mail for Author

Performing a Link Search

To search for links in content items:

1. Click the Managed Links Search link in the Content Management tray. The Search Links Page opens.

2. Enter the applicable values in the field(s). For more detailed descriptions of the fields, see the Link Search Results Page.

3. Click Search. The Link Manager component generates and displays the search results, as shown in the Link Search Results Page.

Checking Content Item Link References

Use the Content Information page to display, check, and verify all the link references associated with a specific content item. You can access the Content Information page for a content item from either of two pages, as described in these topics:

Checking the Link Information About Specific Links

Use the Link Info page to view additional information about a specific link. You can access the Link Info Page for any link from either of two pages, as described in these topics:

About Content Tracker

Content Tracker monitors your system and records information about various activities. Content Tracker collects this information from various sources, then merges and writes the information to a set of tables in your Content Server database. You can customize Content Tracker to change or expand the types of information it collects. Content Tracker monitors activity based on:

• Content item accesses:

  Content Tracker gathers information about content item usage from Web filter log files, the Content Server database, and other external applications such as portals and Web sites. Content item access data includes dates, times, content IDs, current metadata, user names, and profile information about users.

• Content Server services:

  Content Tracker tracks all services that return content and services that handle search requests. And, with a simple configuration change, Content Tracker can monitor literally any Content Server service, even custom services.

About Content Tracker Reports

After Content Tracker extracts data and populates applicable database repository tables, the information is available for report generation. With Content Tracker Reports, you can:

• Generate reports:

  Content Tracker Reports queries the tables created by Content Tracker and generates summary reports of various kinds of activities and the usage history of particular content items. The reports help you analyze specific groups of content or users based on metadata, file extensions, or user profiles. You can use the pre-defined reports that are provided, customize them to suit your installation, or use a compatible third-party reporting package.

• Optimize content management practices.

  You can also use the reported data for content retention management. That is, depending on the access frequency of particular content items during specific time intervals, you may decide to archive or delete some items. Similarly, applications can use the data to provide portlets with the top content for particular types of users.

This section covers the following topics: