Searching the Help
To search for information in the Help, type a word or phrase in the Search box. When you enter a group of words, OR is inferred. You can use Boolean operators to refine your search.
Results returned are case insensitive. However, results ranking takes case into account and assigns higher scores to case matches. Therefore, a search for "cats" followed by a search for "Cats" would return the same number of Help topics, but the order in which the topics are listed would be different.
Words and Phrases
| Search for | Example | Results |
|---|---|---|
| A single word | cat
|
Topics that contain the word "cat". You will also find its grammatical variations, such as "cats". |
|
A phrase. You can specify that the search results contain a specific phrase. |
"cat food" (quotation marks) |
Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase. |
Using Boolean Operators
| Search for | Operator | Example |
|---|---|---|
|
Two or more words in the same topic |
|
|
| Either word in a topic |
|
|
| Topics that do not contain a specific word or phrase |
|
|
| Topics that contain one string and do not contain another | ^ (caret) |
cat ^ mouse
|
| A combination of search types | ( ) parentheses |
|
- Missing Reference Report utility
- Start the refcheck.startup scheduler
- Enable data reference checking for a file
- Skip data reference checking for a relationship
- Run a data reference check against selected files
- View the status of existing data reference checks
- Cancel a scheduled data reference checking job
- View missing reference report results
- Identify the root cause of a missing reference
View missing reference report results
Applies to User Roles:
System Administrator
Data changes may result in invalid records in your database. For example, a department name has changed in your database, which may cause previous incidents to disappear from an Incident Manager's “Incidents assigned to my group” view. In this case, you can run a data reference check on the dept table to find out the invalid records, and further view the detailed results so that you can clean up the invalid data accordingly.
Tip Instead of using the steps described here, you can directly view missing reference report results by clicking the Id field in the Missing Reference Report Status form. See View the status of existing data reference checks.
To view the results of a data reference check and fix the invalid data, follow these steps:
- Navigate to Tailoring > SQL Utilities > Missing Reference Report.
-
In the Report Set box, click Fill to select the data reference check report.
Note The Batch ID field corresponds to the Id field that appears when you click View Status.
-
Optionally, complete one or more of the following fields to narrow down your results:
- Table Name: the name of a file on which the data reference check was performed
- Field: the name of a field in the file
- Relationship Type: a type of relationships for the file
- Definition Type: a type of relationship definitions for the file
-
Click View Result.
A list of relationships for the files is displayed. In these relationships, the files can be either a source file or a target file.
- Select a relationship from the list. The reference check results of the relationship are displayed. The results consist of two sections: Details and Record Analysis.
-
View the information in the Details section. This read-only section displays the relationship details and statistic information about the source and target records.
Field Description Notes Id The unique identifier number of the relationship record Source File The name of the source file of the relationship record For more information, see Add a relationship record Source Field The name of the source field of the relationship record Target File The name of the target file of the relationship record Target Field The name of the target field of the relationship record Relationship Type The type of the relationship record Definition Type The type of the relationship definition
Note To view the relationship definition record, click the Go to definition arrow button next to this field.
Definition Query The query of the relationship definition From Lob Indicates if the source field or target field is mapped to a large object (LOB) Report ID The unique identifier number of the date reference check report Report Time The time when the report was generated Null Records The number of null records based on the relationship Source Records The number of source records based on the relationship Target Records The number of target fields based on the relationship Missing Reference Records The number of records that contain a missing reference Source field in First unique key Indicates if the source field is, or is part of, the first unique key of the source file. The first unique key of a file may consist of multiple fields. Target field in First unique key Indicates if the target field is, or is part of, the first unique key of the target file. -
The Record Analysis section displays the numbers and percentages of valid and invalid records. To view or edit the invalid records, click Show All Invalid Records.
A list of invalid records that use the default form of either the source file or the target file is displayed.
Note If there is only one invalid record, the invalid record opens directly.
Next, you need to identify the root cause of each invalid record in the report and take necessary actions. For more information, see Identify the root cause of a missing reference.
Related concepts
Missing Reference Report utility
Related tasks
