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: Explorer Object Report - using Dates to filter objects
Topic Summary: How to get date queries to work in Explorer Object Reports
Created On: 23-Sep-2008 17:09
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.
 23-Sep-2008 17:09
User is offline View Users Profile Print this message


Ted Carroll

Posts: 15
Joined: 17-Sep-2008

I have a Report that has a date filter and works fine - it uses a custom property Start Date.

When I use Text Edit in Report Editor and pick up the text to paste into an Explorer Object Report it looks like this...but fails..

SELECT "Name"
WHERE Class = Definition
WHERE "Type Number" = 147
WHERE "Start Date" = 1/1/1990

Note that I have modified the last line from what was originally shown in the Text Edit i.e. WHERE "Start Date <-- Start Date" = 1/1/1990
( I have found that it is always necessary to remove the second part of the property name when using Explorer Object Reports on Custom properties.)

Any help appreciated.

Thanks

Report this to a Moderator Report this to a Moderator
 24-Sep-2008 16:15
User is offline View Users Profile Print this message


Peter Crabb-Wyke

Posts: 73
Joined: 3-May-2007

Do you get an error message or does it believe that there are no results when you know that there are?

I tried this with a report of mine and it incorrectly came back with "no qualifying object was found".

I first ran it with the date formatted as my windows default of yyyy-mm-dd which is how the report normally runs, then tried both yyyymmdd and mm/dd/yyyy with the same result. I reran the report with the same parameters and had results.

No idea what the problem is but at least it can be replicated (version 10.1 under Windows XP)
Report this to a Moderator Report this to a Moderator
 24-Sep-2008 17:21
User is offline View Users Profile Print this message


Ted Carroll

Posts: 15
Joined: 17-Sep-2008

Yes - I should have been more specific - it comes back with no qualifying objects found - even though the equivalent report does find objects.

It is also interesting that when looking at the report in the Report Editor there are quotes round the date value date in the "Where" box, but when editing using the Text Edit option, the quotes are not present.
Report this to a Moderator Report this to a Moderator
 7-Oct-2008 16:01
User is offline View Users Profile Print this message


Arif Hussain

Posts: 53
Joined: 22-Dec-2005

Hi,

Same here.
Don't bother copying the Report Generator Report or reading the help.

Re-create the report in the "Explorer Object Report" definition,
by clicking on the "Edit Content" button.

Then it will work.
Report this to a Moderator Report this to a Moderator
 9-Oct-2008 09:12
User is offline View Users Profile Print this message


Ted Carroll

Posts: 15
Joined: 17-Sep-2008

Sorry this does not work for me..

The report code looks like this...

WHERE Class = Definition
WHERE "Type Number" = 147
WHERE "Start Date <-- Start Date" > 31/12/2010
WHERE "Start Date <-- Start Date" <= 31/12/2015


This works fine.

I then remove the label so it looks like this

WHERE Class = Definition
WHERE "Type Number" = 147
WHERE "Start Date" > 31/12/2010
WHERE "Start Date" <= 31/12/2015


and paste as an Explorer Object.

Pressing the Edit content makes no difference for me - what does Edit Content do to the statement?

Thanks
Report this to a Moderator Report this to a Moderator
 9-Oct-2008 12:49
User is offline View Users Profile Print this message


Arif Hussain

Posts: 53
Joined: 22-Dec-2005

Hi Ted,

what does Edit Content do to the statement?

Do not copy the report from anywhere.
Open the Explorer Object Report definition.
Click on the "Edit Content" button, you will get a Report Generator window.
Create your NEW report here.
It will then work.

If you copy the standard report into the Explorer Object Report definition,
Click on the "Edit Content" button, you will get a Report Generator window.
By merely re-entering the date in my case, makes it work.
In the Case of Telelogic supported they needed to specify a different format, to make it work ie MM/DD/YYYY.

I get a extra hiccup, I get prompted to enter the page header date.
and I can't see the page header button on the Page setup window.
If I remove it, I can only text edit it and manually changing the date has no effect.
Report this to a Moderator Report this to a Moderator
 9-Oct-2008 13:58
User is offline View Users Profile Print this message


Ted Carroll

Posts: 15
Joined: 17-Sep-2008

Hi Arif

I didn't know about the Edit Content - I see now... (I have had a gap of a few years using System Architect and I don't think this option was available in Release 9!)

Yes by creating the report direct using Edit Content it works - It accepts dates in DD/MM/YYYY format - and I dont have to make any changes using Text Edit..

Thanks for pointing me in the right direction..


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.