Project and Portfolio Management Practitioners Forum
cancel

Staffing Profile Token Access

SOLVED
Go to solution
Highlighted
Aaron Lo
Contributor.

Staffing Profile Token Access

Hi,

Can anyone please tell me how to access tokens within a Staffing Profile Header (using Custom SQL)?

I have added 2 additional fields to a Staffing Profile Header (via User Data). I am trying to get one to populate based on what is selected in the other. I am using an auto-complete validation with Custom SQL:

SELECT lookup_code, meaning FROM knta_lookups LU
WHERE lookup_type = 'Strategic Priority Subclass'
and enabled_flag = 'Y'
and USER_DATA1= '[???]'
ORDER BY seq

I need to point USER_DATA1 to the other fied on my Staffing Profile Header. I have done this before on request types using the following syntax:
[REQ.P.xxx]

Any ideas on how I do this in a Staffing Profile Header.

Thanks,
Aaron
__________
PPM 7.5
3 REPLIES
Mahen M
Acclaimed Contributor.
Solution

Re: Staffing Profile Token Access

I hope [STFP.UD.TOKEN_NAME] Should work.

Refresh the token builder if the userdata token does not show up in the Token Builder.

Regards,
Mahendran M
Aaron Lo
Contributor.

Re: Staffing Profile Token Access

Thanks Mahen,

Works perfectly. Will close the thread.

Regards,
Aaron
Aaron Lo
Contributor.

Re: Staffing Profile Token Access

Solved as per Mahen's comment.