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

Token Question

Highlighted
Rafał Maliszews
Occasional 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
Honored 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
Esteemed 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
Occasional 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
Esteemed 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
Occasional Contributor

Re: Token Question

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

regards
Rafał Maliszews
Occasional Contributor

Re: Token Question

-
//Add this to "OnDomLoad" event