replacementvariables
| Sr.No | Name | Type | Comments |
|---|---|---|---|
| 1 | id | Primary int | |
| 2 | moduleid | varchar(100) | stores comma separated moduleids |
| 3 | variable | varchar(200) | stores the pattern that is to be replaced in questionnaire |
| 4 | fieldidtype | varchar(200) | defines whether the value given in 'fieldid' belongs to fw_invitaitonfields(invitation) or fw_questionniredetails(question) |
| 5 | fieldid | varchar(150) | id from either fw_invitationfields or fw_questionnairedetails |
| 6 | fieldvalue | varchar(1000) | value in this column is optional. If set, the column id given in fieldid is to have the value in this column |
| 7 | replacementtext | varchar(8000) | Value is set in this column only when value is set in fieldvalue. Replaces 'variable' with value in this column if 'fieldid' column's field is matched with fieldvalue |
| 8 | replacementparams | text | the query part which will replace the pattern with the outcome of the query |
| 9 | showintestinv | int | whether to consider in test invitation or not |
replacementvariables.txt · Last modified: 2025/02/05 05:35 by gloria