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: Reports based on a word within a name
Topic Summary:
Created On: 20-Jun-2007 14:45
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.
 20-Jun-2007 14:45
User is offline View Users Profile Print this message


Justin Floyd

Posts: 8
Joined: 25-Apr-2007

I'm trying to create a Data Element report which looks at part of a name to only select elements with that name to be reported on, eg:-

{
      SELECT "Name"
      WHERE Class = Definition
      WHERE "Type Number" = 5
      WHERE "Name"
LIKE '%Model_Name%'
}

But wild cards do not appear to work. Can you suggest how I could generate a report like this in SA?

Thanks

Report this to a Moderator Report this to a Moderator
 22-Jun-2007 17:19
User is offline View Users Profile Print this message


Matt Sheranko

Posts: 82
Joined: 7-Oct-2005

Justin,  I can not get the LIKE to work with any string in the Report Generator.  Can you get it to work without the wild cards?  When you say "Type Number" = 5, is that an "Entity" definition type?

 

 



-------------------------
Thanks,

MattS
Report this to a Moderator Report this to a Moderator
 25-Jun-2007 12:33
User is offline View Users Profile Print this message


Justin Floyd

Posts: 8
Joined: 25-Apr-2007

"Type Number" = 5 I believe refers to Data Element. I can't ger LIKE to work at all even without the wild cards. What I' trying to do is print a report that details all Data Elements containing a specific suffix
Report this to a Moderator Report this to a Moderator
 3-Jul-2007 12:28
User is offline View Users Profile Print this message


Justin Floyd

Posts: 8
Joined: 25-Apr-2007

Hello Mark

Do you have any further ideas on my problem?

Thanks

Justin
Report this to a Moderator Report this to a Moderator
 27-Jul-2007 17:17
User is offline View Users Profile Print this message


Phil Kindy

Posts: 5
Joined: 5-Oct-2005

Try * instead of % for the wildcard character.  This works for me.
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.