![]() |
Telelogic System Architect (steve huntington) | ![]() |
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 |
![]() |
![]()
|
![]() |
|
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 |
|
![]() |
|
![]() |
|
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) |
|
![]() |
|
![]() |
|
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. |
|
![]() |
|
![]() |
|
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. |
|
![]() |
|
![]() |
|
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 |
|
![]() |
|
![]() |
|
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. |
|
![]() |
|
![]() |
|
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.. |
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.