Hi i am working in a bank's IT. We bought PPM and now my managers wat me a report from PPM database. Every project ends the business depatmant fills a survey(questionary) about the project. They score the project accourding to their pleasure. My manager wants to see the survey results . I could not find the table in the PPM database. I want to SELECT the resultsfrom database Do you know the table and field names
If the survey is a request type you created, you will find most contents in the tables: kcrt_requests kcrt_request_details kcrt_req_header_details Filter in these tables for the correct request_type_id which can be found in kcrt_request_types
Can you give the fields estimated. I could not found my select is like this is it correct:
select D.STATUS_NAME,C.FULL_NAME,B.*, A.* from ppmktprod_usr.kcrt_requests A INNER JOIN ppmktprod_usr.kcrt_request_types B ON B.REQUEST_TYPE_ID= A.REQUEST_TYPE_ID INNER JOIN ppmktprod_usr.knta_users C ON A.CREATED_BY = C.USER_ID INNER JOIN ppmktprod_usr.KCRT_STATUSES D ON D.STATUS_ID = A.STATUS_ID WHERE A.STATUS_CODE = 'CLOSED_SUCCESS' AND A.APPLICATION='elIT' ORDER BY A.CREATION_DATE DESC
In the workbench when you open a field in a request type or request header type you will find several tab. One of them shows where the value for that field is stored. If there is no sturage tab like for the status field, these fields have there dedicated columns in the tables. You might find things easier using a view like kcrt_requests_v because they already contain e.g. the speaking name of a status.
First you must identify the fields which you need. Open the Workbench -> Demand Mgmt -> Request Types
Open your survey Request Type goto the fields tab. Open the field configuration of each field you need, goto the storage tab. There you find the parameterXX and the batch number.
with this information you can build a statement like this:
select r1.request_id, r1.visible_parameter1, r1.visible_parameter2, r2.visible_parameter3 from kcrt_requests_v r1, kcrt_requests_v r2 where r1.request_type_name ='' and r1.batch_number=1 and r2.batch_number=2 and r1.request_id=r2.request_id
However it is mandentory to identify the fields your manager wants and there matching database fields.