Projects in Project table not displaying on P3 Scr
In the Open Standard
Thomas LeahyMember for 22 years 4 months
- Created
- 1
- 2
0
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
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
1 reply
Oldest first- 0Shirish Borkar ·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.
Log in or join to reply
ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.
Existing members: your original username and password still work. Forgot password?