Project and Portfolio Management Practitioners Forum
cancel

portlets with custom information

SOLVED
Go to solution
Highlighted
Jorge Avendano
Trusted Contributor.

portlets with custom information

Hi,
I create a request type with customize fields where the user can select a person of the company that work in the project as a IT leader. This information was handle with a token (LIDER_TECNOLOGICO) and a validation "auto complete list" type with the name (PPM - User Id - All).
I want know where the user selection was stored in order to use in the portlet data source?.
In which table was stored this information to create the query for the portlet?

Thank you for your support.
3 REPLIES
Semenov Alexand
Acclaimed Contributor.
Solution

Re: portlets with custom information

HI,
this inf stored in KCRT_REQ_HEADER_DETAILS table as parameter and visible_parameter.
How see number of this parameter: open WorkBench-->Request type-->open your field and see on "storage" tabe.
Good Luck
Jason Nichols K
Acclaimed Contributor.

Re: portlets with custom information

If your custom field is not stored in the header, it won't be in the KCRT_REQ_HEADER_DETAILS table, but the KCRT_REQUEST_DEATILS table. The same process for finding the columns applies for both tables.
Jorge Avendano
Trusted Contributor.

Re: portlets with custom information

Thank you guys.

Your information was very useful for me and solved entire my doubt.