Project and Portfolio Management Practitioners Forum
cancel

Token Question

Highlighted
Rafał Maliszews
Regular Contributor.

Token Question

Hi

I've got trouble with PPM8 and tokens in the context of data source.

I want to pass PROJECT_ID and USER_ID to custom datasource.

So I create specialized view with column user_id and project_id and I pass this condition:

select project_name project_name
user_id = [SYS.USER_ID] and
project_id = [SYS.PROJECT_ID]

When I constructed portlet based on this data source I took error:
...
ORA-00936: missing expression

-- The SQL query that's being executed:
...

Query property resolves SYS.USER_ID to some value but PROJECT_ID does not.

How to do this? Any suggestion?
6 REPLIES
Mahen M
Acclaimed Contributor.

Re: Token Question

I think 'sys' is not the correct prefix for Project ID for your req.... I hope something like 'PRJ' should be used. You can see the possible prefixes.

Thank you.

Regards,
Mahendran M
Erik Cole_1
Outstanding Contributor.

Re: Token Question

Are you passing the project id in from a filter you've configured on the data source? If so, then the token should just be [P.TOKEN_NAME] or [VP.TOKEN_NAME] depending on which validation value you want to pass...
Rafał Maliszews
Regular Contributor.

Re: Token Question

My query in DSN looks like:

select project_name from
pm_projects
where
project_id = [P.PROJECT_ID]

But it doesn't work for me.

Portlet already has a context of selected project.

What did I do wrong? Any suggestion?
Semenov Alexand
Acclaimed Contributor.

Re: Token Question

Hi.
That you portlet type?
If you use project overview portlet then see this suggestions (http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=1328674)
Rafał Maliszews
Regular Contributor.

Re: Token Question

Thank's for that link, docs covers all issue.

regards
Rafał Maliszews
Regular Contributor.

Re: Token Question

-