The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Staffing Profile Token Access

SOLVED
Go to solution
Highlighted
Aaron Lo
Occasional Advisor

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
Honored 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
Occasional Advisor

Re: Staffing Profile Token Access

Thanks Mahen,

Works perfectly. Will close the thread.

Regards,
Aaron
Aaron Lo
Occasional Advisor

Re: Staffing Profile Token Access

Solved as per Mahen's comment.
//Add this to "OnDomLoad" event