SGQA identifier

From LimeSurvey Manual
Jump to: navigation, search
Other languages:Deutsch 53% • ‎English 100% • ‎français 50% • ‎Nederlands 100%

Contents


Starting in  Version 1.92, you no longer need to use SGQA identifiers. Instead, you can use Expression Manager compatible question codes. Here is information about their naming conventions.
Hint: This page describes how you can find out an SGQA identifier. For information how to use it please refer to the page Adding a question.

General Description

The SGQA (Survey/Group/Question/Answer) identifier is a shortcut to the answer of a question. Every survey, group and question you are creating gets a unique number assigned in your database. You can see this number in the admin interface in the title of the survey, group and question bar.

SGQA.png

To determine the SGQA identifier, you have to put these numbers together with the letter 'X' in between.

Note: Always use capital letters ("X" instead of "x")!

Use editor to add placeholder

The integrated editor has a feature to select the placeholder for a certain question. The icon is called "LimeSurvey replacement fields properties". This feature always lists questions of previous survey pages only, so it depends on the survey mode.

Lime replacement editor.png

Identifier for Single Choice Questions

For example: Survey has ID 1, Group has ID 6, Question has ID 12. Your identifier for a single choice question would look like this:

1X6X12

Identifier for Multiple Choice Questions

Since it is a multiple choice question the particular answer must be identified too. Just add the code of that answer without an X. For example: Survey has ID 1, Group has ID 6, Question has ID 12. The particular answer has code 'ber1'.

Your identifier for this multiple choice question answer would look like this:

1X6X12ber1

Identifier for Array question types

Since it is a array question the particular subquestion within the cell must be identified too. Add the subquestion code of the row without an X. For example: Survey has ID 1, Group has ID 6, Question has ID 12. The particular subquestion has code 'ber1'. Your identifier for this "Array" question answer would look like this:

1X6X12ber1

Identifier for Array (Text) or Array (Number) Questions

Since it is a combined array question the particular answer within the cell must be identified too. Add the subquestion code of the row without an X, then append the underscore char and finally add the subquestion code that indentifies the column. For example: Survey has ID 1, Group has ID 6, Question has ID 12. The particular subquestion has code 'ber1', and the column is identified by the subquestion with code 'lab1'

Your identifier for this "Array (Text)" question answer would look like this:

1X6X12ber1_lab1

Uses of the SGQA identifier

The SGQA identifier can be used to load the answers to previously saved questions into the question text of later questions. (See Information from previous answers)

It can also be used in the query URL of a survey to "prefill" answers to a survey. eg: for SGQA 1X6X121ab1, your query URL could include "&1X6X121ab1=Y" to prefill that answer with a "Y". (See Prefilling survey answers using the survey URL)

The SGQA identifier is also the field name where the data for each question is stored in the database survey responses table.

Dynamically reference the SGQ identifier

Some people may find a need to reference a question dynamically. For instance, if you would like to hide the input text field of a short text answer. You can now do this (as of SVN build 9755) by using the {SGQ} identifier. LimeSurvey will replace the {SGQ} with the full Id of that question, ex: 3583X84X249