Custom User Application: "Unrefs"

For more examples of Customizing RoAccess, Click Here

This RoAccess user wanted to find which Items were not referenced by a specific ItemType.

Rochade makes it easy to find which Items are not referenced by ANY ItemType.  But it does not let you be specific about links from a specific ItemType.   So you create an custom application to do this very useful search.

If, by definition, a certain ItemType must be linked to another ItemType, and it is not, then the data is in error.  These errors must be detected and corrected for the data to be consistent and valid.

An example would be to find all Items of ADABAS-FIELD that are not referenced by any Items of ItemType ADABAS-FILE.   This would show ADABAS-FIELDs that are not longer attached to ADABAS-FILEs.   Since all ADABASFILEs point to the ADABAS-FIELDs that comprise it, any ADABAS-FIELDs not linked, are an error.  If an ADABAS-FIELD exists, but is not part of an ADABAS-FILE, you have a contradiction.   Obviously, you cannot have fields if they are not part of a file.   In this example, there are over 8000 ADABAS-FIELDs.

Perhaps the Item names were misspelled when loaded or initially entered.  Perhaps  incorrect ADABAS-FIELDs have been linked to ADABAS-FILEs by mistake.

By finding these "orphan" Items, you can the begin to find why the error occurred, and proceed to correct the data.

 
The first screen of the User Application  presents two List Boxes that have all the ItemTypes in the Subject Area.  You must select the "TO" ItemType from the left list box, and the "FROM"  ItemType from the right list box.
 
From the left list box, you select ADABAS-FIELD as the ItemType that is referenced.
 
You then select the ItemType in the right list box that references the ItemType on the left, which you have just selected.
 
You have specified to find all ADABAS-FIELDs that are not referenced by any ADABAS-FILE Items.  Click the button tot proceed.
 
All 8000+ ADABASFIELDs are analyzed to determine if they are not referenced by ANY Item of ADABAS-FILE.  Here we find there are 3 such "orphan Items".  Since this is a clear data error or inconsistency, you can now begin to determine the cause and correct it.