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: 

portlets with custom information

SOLVED
Go to solution
Highlighted
Jorge Avendano
Super Collector

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
Esteemed 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
Honored 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
Super Collector

Re: portlets with custom information

Thank you guys.

Your information was very useful for me and solved entire my doubt.
//Add this to "OnDomLoad" event