Has anyone been able to use active project participants as an attribute in a PW Environment?
What we are trying to do is get a list of the active project participants, which are prefixed with the active project number and then pass that as an attribute.
The screenshot below shows the active Project participants, along with other user lists.
We can use the statement select o_name from dms_ulst but that returns all active user lists and we just want the current project.
Anyone have any ideas?
Thanks in advance
We resolved this issue by adding Select statements to the Value list settings within the ProjectWise Environment attributes definitions and taking advantage of cascading attributes. Nothing was done within PowerShell. The following is an example of the solution.
DECLARE @projID INT = (
WHERE o_projectname LIKE '$EDIT#ProjectName$'
WHERE SUBSTRING(o_name, 1, 4) = '$EDIT#ProjectNumber$' AND
o_usrlstno IN (
WHERE o_memtype = 3 AND
o_aclno = (
WHERE o_projectno = @projID
Answer Verified By: Mahesh Patel
I can verify that not only did this work it made it relatively easy to have active project participants as an attribute. While this may not seem like a big deal it was huge. A BIG BIG thank you to THE BRIAN FLAHERTY he was the mastermind behind this solution.