• 0 Vote(s) - 0 Average
  • 5
  • 4
  • 3
  • 2
  • 1
Thread Modes

Service request with options
#1
Hello
I'm trying to configure at Service Request Catalog one request type with other request type as option. 
Both request types have their own questionnaire and some questions are common into both questionnaires.. so I want to hide common questions at second questionnaire where are already answered into first one; but show them if the questionnaire is used alone.

My question is: there is any way to hide some questions at second (optional) questionnarie that are been answered into the firs one? Any way to detect this?

As I see, answers from first questionnaire are stored into "sd_question_result_details" when answering the second one, but I can't see any common ID for joning it with second questionnaire .... perhaps, if there is any way to join both questionnaires at one sql, I could define one question's default value and use this value for hide or show these common questions)

thank you

#2
(05-30-2019, 06:12 AM)egomez Wrote: Hello
I'm trying to configure at Service Request Catalog one request type with other request type as option. 
Both request types have their own questionnaire and some questions are common into both questionnaires.. so I want to hide common questions at second questionnaire where are already answered into first one; but show them if the questionnaire is used alone.

My question is: there is any way to hide some questions at second (optional) questionnarie that are been answered into the firs one? Any way to detect this?

As I see, answers from first questionnaire are stored into "sd_question_result_details" when answering the second one, but I can't see any common ID for joning it with second questionnaire .... perhaps, if there is any way to join both questionnaires at one sql, I could define one question's default value and use this value for hide or show these common questions)

thank you

Hello,
We have used "linking request" for 5 years but only 8% of the requests needed to be grouped.

From what i see :
Each requests are stored in SD_REQUEST_DETAIL.REQUEST_ID => SD_REQUEST.REQUEST_ID
Each questions of sub-requests are stored in SD_QUESTION_RESULT_DETAIL.REQUEST_DETAIL_ID AND SD_QUESTION.QUESTION_ID

I think you should create a condition to not dispay question if :
SD_REQUEST inner join SD_REQUEST_DETAIL inner join SD_QUESTION_RESULT_DETAIL inner join SD_QUESTION
where REQUEST_ID= @ ID @ and QUESTION_CODE='code of question to not dispay'

P.ABBE
ABBE Philippe, proud to be a member of EV CONNECT FORUM since Nov 2015.






Users browsing this thread: 1 Guest(s)