How to search on Data Type in Rational System Architect

Technote (FAQ)


Question

How can you search for specific Data Type values in IBM Rational System Architect?

Cause

You would like to find all "Entity Attributes" of a specific "Data Type" value.

Answer

You can search and find all "Entity Attributes" of a specific "Data Type" value by any of the following three methods:

Top



Each method is described as follows.

Method #1: Word Report
    1. Select from the menu:
      Reports > Word Reports > Logical Model Reports > Attribute Report

    2. Select the items you need

    3. Generate the report

Top

Method #2: Advanced Search
    1. Press the Advanced Search button on the tool-bar.

    2. Select Definitions in the Class drop down list.

    3. Select Data Element in the Types field.

    4. Select the Property Data Type <- SQL Data Type.

    5. Select a Comparison.

    6. Enter a Value.

      Your Advanced Search should look like this example where we are searching on Data Type of date or time:



    7. Press the OK button to see the results showing rows of "Name, Identity, Audit, Update Date, Type, Class".


      Note: The Advanced Search generates a string in the Search field in the tool bar that you can edit and reuse.
      The string from the above example is as follows:
      Class = Definition, "Type Number" = 5, "Data Type <-- SQL Data Type" ="date ", "time "

Top

Method #3: Report Generator

    1. Select from the menu:
      Reports
      > Report Generator

    2. Press the Add button.

    3. Select Definitions in the first drop down list after the 'Current diagram' line.

    4. Press the Where button.

    5. Select the Property Data Type <- SQL Data Type.

    6. Select a Comparison.

    7. Enter a Value.

    8. Press the OK button.

    9. Press the "Properties to Print" button.

    10. Select Name and Data Type <-- SQL Data Type.

    11. Press the OK button.

    12. Select "used by Definitions" in the next drop down list.

    13. Press the Where button.

    14. Select Entity in the Type section.

    15. Press the "Properties to Print" button.

    16. Select Name.
      Your report screens should look like this example picture where we are reporting on Data Type of date or time:



    17. Press the Generate button to see the results showing rows of "Name, Data Type, Name".The first name its the Attribute and the second name is the Entity.

    Notes:

    1. You can change the "Properties to Print" and the "Report Type" to suite your requirements.
    2. You can change the generated column names used in the report. To do that you need to edit the report in the editor. In the reports window if you highlight (select) a report name and choose from the menu Report > Text Edit, a window will open where you can edit the two "SELECT" lines.

      For example:
        • In the first "SELECT" statement:
          SELECT "Name" LEGENDFONT Font4, "Data Type <-- SQL Data Type"
          You can edit it to be as follows:
          SELECT "Name" LEGENDFONT Font4 LEGEND "Attribute", "Data Type <-- SQL Data Type"

          In the second "SELECT" statement:
          SELECT "Name"
          You can edit it to be as follows:
          SELECT "Name" LEGENDFONT Font4 LEGEND "Entity"
    3. You can change any LEGEND to suite your requirements.
Top

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Rational System Architect
General Information

Software version:

11.4, 11.4.0.1, 11.4.0.2, 11.4.0.3, 11.4.1, 11.4.1.1, 11.4.1.2, 11.4.2, 11.4.2.1, 11.4.2.2, 11.4.2.3, 11.4.2.4

Operating system(s):

Windows

Reference #:

1646354

Modified date:

2013-08-09

Translate my page

Machine Translation

Content navigation