Survey settings inheritance: Difference between revisions
From LimeSurvey Manual
| Line 9: | Line 9: | ||
[[File:db_schema.png]] | [[File:db_schema.png]] | ||
# '''Table surveys_groups''' There is one default group in table “survey groups” with the gsid=1 and name=”default”. This is the group from which a new created survey and a new created survey group inherit from. All other survey groups that could be created by the user are stored in this table. [[File:create_survey_default_group.png]] Every new created survey belongs to a group. When no special group is selected it belongs to the default group, inheriting all settings from that group. [[File:surveygroup_list.png]] This is the group from which a new created survey and a new created survey group inherit from. | # '''Table surveys_groups''' There is one default group in table “survey groups” with the gsid=1 and name=”default”. This is the group from which a new created survey and a new created survey group inherit from. All other survey groups that could be created by the user are stored in this table. The next screenshto shows the process of creating a new survey with "default group" selected.[[File:create_survey_default_group.png]] Every new created survey belongs to a group. When no special group is selected it belongs to the default group, inheriting all settings from that group. [[File:surveygroup_list.png]] This is the group from which a new created survey and a new created survey group inherit from. | ||
# '''Table surveys_groupsettings''' Here we save all group settings. There is a relation to table survey_groups (1:1). The table "survey_groupssettings" has two basic (inserted to DB on installtion)entries: | # '''Table surveys_groupsettings''' Here we save all group settings. There is a relation to table survey_groups (1:1). The table "survey_groupssettings" has two basic (inserted to DB on installtion)entries: | ||
## gsid = 0: There is no entry in table surveys_group that is related to this. Example attribute: save ip address “ipaddr” = ‘N’. That are the values the software starts with.These values are the global survey settings. | ## gsid = 0: There is no entry in table surveys_group that is related to this. Example attribute: save ip address “ipaddr” = ‘N’. That are the values the software starts with.These values are the global survey settings. | ||
## gsid: 1 “insert settings for default survey group” (save ip address “ipaddr” = ‘I’ ) ‘I’ means inherit the behaviour from gsid=0 | ## gsid: 1 “insert settings for default survey group” (save ip address “ipaddr” = ‘I’ ) ‘I’ means inherit the behaviour from gsid=0 | ||
Revision as of 11:10, 1 April 2020
General
This documentation will give you an overview how the inheritance process of survey settings works in Limesurvey software.
Database tables for inheritance
We have three tables that are relevant for the inheritance process.
- Table surveys_groups There is one default group in table “survey groups” with the gsid=1 and name=”default”. This is the group from which a new created survey and a new created survey group inherit from. All other survey groups that could be created by the user are stored in this table. The next screenshto shows the process of creating a new survey with "default group" selected.
Every new created survey belongs to a group. When no special group is selected it belongs to the default group, inheriting all settings from that group. 
This is the group from which a new created survey and a new created survey group inherit from. - Table surveys_groupsettings Here we save all group settings. There is a relation to table survey_groups (1:1). The table "survey_groupssettings" has two basic (inserted to DB on installtion)entries:
- gsid = 0: There is no entry in table surveys_group that is related to this. Example attribute: save ip address “ipaddr” = ‘N’. That are the values the software starts with.These values are the global survey settings.
- gsid: 1 “insert settings for default survey group” (save ip address “ipaddr” = ‘I’ ) ‘I’ means inherit the behaviour from gsid=0
