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?
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
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.