Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic System Architect (steve huntington)
Decrease font size
Increase font size
Topic Title: Extracting proper attribute definition (instead of domain)
Topic Summary:
Created On: 10-Jul-2006 16:18
Status: Read Only
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
Subscribe to this topic Subscribe to this topic
E-mail this topic to someone. E-mail this topic
Bookmark this topic Bookmark this topic
View similar topics View similar topics
View topic in raw text format. Print this topic.
 10-Jul-2006 16:18
User is offline View Users Profile Print this message


Sheri Dumire-Hamilton

Posts: 5
Joined: 15-Mar-2006

The report definition below works EXCEPT when I used a domain to define the data type.  In those cases, it displays the text description of the domain rather than the attribute.  What do I need to change?

 

REPORT "Entity and Attribute Properties Report - Current Diagram (SDH)"
DESCRIPT "Meta Data associated with an Entity and each of its Attibutes"
ID 25299
{
 SETTING { PAGESIZE -1, 0.00 }
 SETTING { HEADER 1 "Entity and Attribute Properties" }
                SETTING { TRAILER 1 "as of ", "date","                                                                                  page","#pg#" }
 SETTING { INHERITVIAISA YES }
 FIELD "PK" { SOURCE PROPERTY "Key" LENGTH 1 TYPE BOOLEAN }
 FIELD "Null" { SOURCE PROPERTY "Default Nullity" LENGTH 1 TYPE BOOLEAN }
 FIELD "Data Type" { SOURCE PROPERTY "SQL Data Type" LENGTH 22 TYPE CHARACTER }
                FIELD "Effectivity Type" { SOURCE PROPERTY "Effectivity Type" LENGTH 30 TYPE CHARACTER }
      FIELD "Default Value" { SOURCE PROPERTY "Default Value" LENGTH 30 TYPE CHARACTER }
      FIELD "Value List" { SOURCE PROPERTY "Value List" LENGTH 120 TYPE MEMO }
      FIELD "Text Description" { SOURCE PROPERTY "Description" LENGTH 1500 TYPE MEMO }
      FIELD "Unique Set of Attributes" { SOURCE PROPERTY "Unique Set of Attributes" LENGTH 500 TYPE MEMO }
                FIELD "Availability" { SOURCE PROPERTY "Availability" LENGTH 30 TYPE CHARACTER }
 FIELD "Comments" { SOURCE PROPERTY "Comments" LENGTH 3000 TYPE MEMO }

 

 TABULAR 1 {
  SELECT "Name" LEGEND "Entity" LABEL LEFT WIDTH 5.0
  SELECT "Unique Set of Attributes" LABEL LEFT
                                SELECT "Availability" LABEL LEFT
  SELECT "Comments" LABEL LEFT

  WHERE Class = Definition
  WHERE Type = "Entity"
                 WHERE Current = T
                                ORDERBY "Name" 
  JOIN
  WHERE RELATION = "uses"
  JOIN
  SELECT "Name" LEGEND "Attribute" LABEL LEFT WIDTH 5.0
                                SELECT "Text Description" LABEL LEFT WIDTH 5.0
                                SELECT "PK" LABEL LEFT
                                SELECT "Null" LABEL LEFT
  SELECT "Data Type" LABEL LEFT
            SELECT "Default Value" LABEL LEFT
            SELECT "Effectivity Type" LABEL LEFT
            SELECT "Value List" LABEL LEFT WIDTH 5.0

  WHERE Class = Definition
  WHERE Type = "Attribute"
 }
}

Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic System Architect forum.
There are currently 1 users logged in.
The most users ever online was 16 on 30-Oct-2008 at 14:46.
There are currently 0 guests browsing this forum, which makes a total of 1 users using this forum.
You have posted 0 messages to this forum. 0 overall.

FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.