Project and Portfolio Management Practitioners Forum
cancel

Table Fields in a Request List Portlet ?

Highlighted
robgallop
New Member.

Table Fields in a Request List Portlet ?

Hi First time post, so please go easy on me. I have a table on a Request Form, and I'l like to show the fields within the table on a Request List Portlet. Is this possible, as I can only add the Table and this then shows how many entries there are, rather than the specific data (I hope this make sense) Thanks in advance Rob
3 REPLIES
AlexSavencu
Acclaimed Contributor.

Re: Table Fields in a Request List Portlet ?

hi, robgallop,

 

welcome to the forum!

 

for your requirement, you will have to write a custom portlet to display data within the table component - we have done a lot of these in our implementations.

 

cheers

alex


--remember to kudos people who helped solve your problem
robgallop
New Member.

Re: Table Fields in a Request List Portlet ?

Hi Alex

 

Many thanks for your reply

 

Do you have any script examples used to extract the fields ?

 

Cheers

 

Rob

AlexSavencu
Acclaimed Contributor.

Re: Table Fields in a Request List Portlet ?

Hi, robgallop,

 

below is a small sample, but I strongly suggest to go through the PPM data model and create a query to fit your specific needs:

select krq.request_id REQUEST_ID,

  krq.description DESCRIPTION,

  kte.visible_parameter42,

  kte.visible_parameter41,

  from kcrt_requests krq,

  kcrt_request_types krt,

  kcrt_table_entries kte

where

  krq.request_type_id = krt.request_type_id

and

  krq.request_id = kte.request_id

and

  krt.request_type_name = 'My Request Type'

 

cheers

alex


--remember to kudos people who helped solve your problem