Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Require Client information for the projects

Highlighted
saiskt
Regular Collector

Require Client information for the projects

HI, in PPM database I was searching for the client information realted to the projects. Could anyone please let me know exactly in which table I can find this information?
4 REPLIES
Mahen M
Honored Contributor

Re: Require Client information for the projects

Client Information means?

Regards,
Mahendran M
saiskt
Regular Collector

Re: Require Client information for the projects

we select the client name while creating the project. I was specifically looking for the counts of projects group by each client.For reference I have attached the screen shot.
Mahen M
Honored Contributor

Re: Require Client information for the projects

I hope it is a custom field, Please see KCRT_Request_details Table.

Open the Work bench and see the storage parameter for this table.

Regards,
Mahendran M
Mahen M
Honored Contributor

Re: Require Client information for the projects

Sorry, It is in Summary Section, so it should be in Header

KCRT_REQ_HEADER_DETAILS

SELECT Parameter_column_number, Prompt, Batch_number, Parameter_token,Display_flag, Enabled_flag
FROM PRODPITG.KNTA_PARAMETER_SET_fields_V WHERE context_value='31260' AND source_parameter_set_id=906
ORDER BY 3, 1

Use the above Query, Please replace 31260 with your Header detail ID.

Regards,
Mahendran M
//Add this to "OnDomLoad" event