Survey details filled by a particular person

[Former Member]

Hi experts,

I have the following requirement. I created one lead survey. I want to get the answers filled by the bp. I am able to see the survey guid, survey id, value id, value version, survey version from crm_order_read(et_sruvery) function module.

Using the information, i am passing values to the function module CRM_SVY_GET_SURVEY_TEXTS. here i am getting the survery texts means all the available questions and answers only. not the particualar answers filled by bp.

How can i get the particular values?

Thanks,

mallik

[Former Member]

hi,

i got the answer. i used the following logic to get the answer.

may be useful to anybody.

first i read the details using crm_order_read.(et_survey)

with those details.

read table ls_et_survey into line_survey index 1.

select single APPLICATIONID

from CRM_SVY_DB_S

into appl

where SURVEYID = line_survey-SURVEYID.

create object survey1 exporting I_APPLICATION_ID = appl

I_SURVEY_ID = line_survey-SURVEYID

I_SURVEY_VERSION = line_survey-SURVEYVERSION

I_LANGUAGE = 'E'

I_VALUEGUID = line_survey-VALUEGUID

I_VALUEVERSION = line_survey-VALUEVERSION.

create object rating1 exporting I_VALUE_XML_HEX = line_survey-valuexml.

call method survey1->GET_ALL_VALUES

importing

E_ALL_VALUES = ls_all_values.

call method survey1->GET_ALL_TEXTS

importing

ET_TEXTS = ls_texts.

*********

call method rating1->GET_SURVEY_RATING

importing

E_OPTIMUM = ls_optimum

E_ACHIEVED = ls_achieved.

call method rating1->GET_QUESTION_RATING

importing

ET_QUESTION_RATING = ls_qs_rat.

call method rating1->GET_ITEM_RATING

importing

ET_ITEM_RATING = ls_it_rat.

***********

i got my results here