Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Projects in Project table not displaying on P3 Scr

1 reply [Last post]
Wed, 2004-06-09 11:27
Thomas Leahy
User offline. Last seen 8 years 35 weeks ago. Offline
Joined: 9 Jun 2004
Posts: 11
Groups: None
All,

When I run the following SQL statement

"select * from project where (orig_proj_id is null and base_type_id is not null) or (orig_proj_id is not null and base_type_id is null)"

I shouldn’t get any records returned. However I get 302 records returned 299 with an orig_proj_id and no base_type_id and 3 with a base_type_id and no orig_proj_id.

The projects do not appear in the normal P3 screens. Any recommendations on what should I do?



Regards,

Tom Leahy
Top

Replies

Thu, 2004-11-25 06:06
#1
Shirish Borkar
User offline. Last seen 17 years 27 weeks ago. Offline
Joined: 24 Nov 2004
Posts: 15
Groups: None
299 records with orig_proj_id and no base type id - are baselines so anyways will not be shown on P33 screen.

3 with a base_type_id and no orig_proj_id - indicates that baselines restored as projects. These three should appear on screen as project. Have you done any other thing at backend? Have you applied any filters? Something which you could remember.

Top