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

Questionnaire
#1
Hello,

We are trying to define a questionnaire to select an equipment based on the brand and model. We already have this information on AM_MANUFACTURER and AM_CATALOG tables.

We wanted to select the brand of the equipment and then show, in another field, the possible models to that specific brand. Is this possible?

Thank you.
pms23, proud to be a member of EV CONNECT FORUM since Apr 2017.

#2
(02-10-2020, 10:36 AM)pms23 Wrote: Hello,

We are trying to define a questionnaire to select an equipment based on the brand and model. We already have this information on AM_MANUFACTURER and AM_CATALOG tables.

We wanted to select the brand of the equipment and then show, in another field, the possible models to that specific brand. Is this possible?

Thank you.

Hello,
If your 2 questions are in separed section/questionnaire, you can display model with selected brand (linked with the code) :

Code:
select ARTICLE_MODEL from AM_CATALOG
INNER JOIN SD_QUESTION_RESULT on SD_QUESTION_RESULT.RESULT=AM_MANUFACTURER.MANUFACTURER_ID

INNER JOIN SD_REQUEST on SD_REQUEST.REQUEST_ID=SD_QUESTION_RESULT.REQUEST_ID

INNER JOIN SD_QUESTION ON SD_QUESTION.QUESTION_ID=SD_QUESTION_RESULT.QUESTION_ID

WHERE SD_REQUEST.REQUEST_ID=@ID@ AND SD_QUESTION.QUESTION_CODE='Select_Brand'

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

#3
(02-10-2020, 10:48 AM)ABBE Philippe Wrote:
(02-10-2020, 10:36 AM)pms23 Wrote: Hello,

We are trying to define a questionnaire to select an equipment based on the brand and model. We already have this information on AM_MANUFACTURER and AM_CATALOG tables.

We wanted to select the brand of the equipment and then show, in another field, the possible models to that specific brand. Is this possible?

Thank you.

Hello,
If your 2 questions are in separed section/questionnaire, you can display model with selected brand (linked with the code) :

Code:
select ARTICLE_MODEL from AM_CATALOG
INNER JOIN SD_QUESTION_RESULT on SD_QUESTION_RESULT.RESULT=AM_MANUFACTURER.MANUFACTURER_ID

INNER JOIN SD_REQUEST on SD_REQUEST.REQUEST_ID=SD_QUESTION_RESULT.REQUEST_ID

INNER JOIN SD_QUESTION ON SD_QUESTION.QUESTION_ID=SD_QUESTION_RESULT.QUESTION_ID

WHERE SD_REQUEST.REQUEST_ID=@ID@ AND SD_QUESTION.QUESTION_CODE='Select_Brand'

P.ABBE

Thank you Abbe!
pms23, proud to be a member of EV CONNECT FORUM since Apr 2017.






Users browsing this thread: 1 Guest(s)