Project - Views & Custom Fields
Asked By Bar
07-Mar-08 10:33 AM
I have a custom field, let call it Department, pulling data from a lookup
table. This lookup table is tree based, i.e. it has multiple levels (three
in this case). As an example lets assume it is like this:
Department
- UK
-- Sales
-- Engineering
-- Support
- US
-- Sales
-- Engineering
-- Support
- CA
-- Sales
-- Engineering
-- Support
When I create a view I want to filter by this field with anythign under UK.
In Project Server 2003 it used to work using the test 'Begins With' and use
the value 'UK'. This same option doesn't seem to work in Project Server 2007
and when I try it I get the message that the test can only be 'equals' or
'does not equals' for a lookup table.
Are there any ideas on how to get around this orget this working?
Many thanks in advance,
Bara
Department.UK.Support
(1)
Department.UK.Sales
(1)
Project Server
(1)
TheProjectServerGuru
(1)
Conroy
(1)
Dept
(1)
Bara
(1)
Orget
(1)
Jonathan Sofer replied...
This option no longer seems to be an option. I agree with you. I am not
sure how to get around this other than specifying all the values available
or opening a ticket with MS on this.
Sorry that I don't have any great workarounds for you.
Jonathan
pconroyATtheprojectserverguruDOTcoDOTnz replied...
It's not pretty, but you could add multiple filters ie:
Dept contains Department.UK OR
Dept contains Department.UK.Sales OR
Dept contains Department.UK.Support
etc
--
Did this post help you. Consider passing on the good will by making a
donation this great charity.
http://www.fundraiseonline.co.nz/TheProjectServerGuru/
http://theprojectserverguru.spaces.live.com
Bar replied...
Thank you both for your replies. At least this makes sure that I have not
missed something. Bit of a shame it no longer works as it did though.
Installing MS Project Server 2007 onto a single server. Project Hello, I'm trying to make a decision for our group at work to proceed to use MS Project Server 2007 but before I do, I want to test it out with the trial version try it out, then I have no way to convince management to proceed with using Project Server 2007 for our group. I want to install the Project Server 2007 Trial version on
Migration of ProjectServer2003 to ProjectServer2007 in single mach Project my VPC has the following 1. Project server 2003 with Service pack sp2a 2. SQL server 2000 3. SQL server 2005 4. Project Server 2007 I have created a PWA and was able to provision the same successfully. My project server 2003 contains only one project and i am trying to migrate the same to
MS Project Q's Project I'm trying to make the best decision in integrating MS project 2007 into my Server SBS 2003 network. I currently have Project Standard 2003 and 2007 as a standalone installed on multiple laptops. Scenario: -1 SBS Server 2003 w / MS Project Server 2007 installed -Client Laptops Question 1: Project Std 2007 I currently have Project Std â
Can't open Project - Unexpected error occured during command execu Project Hi All, Recently we have had trouble opening a project on Project server 2007 via the Project client or Project server interface. The error we get is: Try the following: Verify that all arguments names and
backup and restore PWA Project I have already tried many different ways to do backup / restore but I haven???t do that. Here is my situation, I have a PWA site (example: aaa / pwa) on server A and I got a backup from CA(Backup and Restore), and now I want everything that I have on that aaa / PWA site on different URL and different server server B, bbb / pwa). I have server B ready with sharepoint and MS project 2007, and I already have the backup files from the server A on the local drive in serverB. This is what I have tried: I created pwa I tried to load the backup from aaa / pwa to the new sharepoint & MS project. On both ways I was not able to get everything that I have (data, links