System information

id: autoincrement PK
questionid: answer belongs to this question
ordernum: display order
answer: the answer text
alias: will be stored as answer (usually the same as the ‘answer’)
actioncontext: can be used for storing reject reasons or for data imput field specification
fields: used grids to determine its columns. Values must be separated by comma ‘,’ or semicolon ‘;’
jumpto: next presented question. possible values:
-3: no jump
-2: jumt to next question
-1: finished
-4: finised with voice
-5: jump forward
other: questionid
endcode: the endcode for the last answer (with a valid code) will be stored for statistical reasons. if you specify more endcodes, the last endcode will be
stored in the database.
entercondition: simlple sql clause. if the condition result is true, than will jump to question ‘onconditiontrue’, othervise will jumpt to ‘onconditionfalse’
entercondition rules:
1. any sql in the following format: select … (if return 0 than the result will be interpreted as false, othervise as true)
2. simplified condition. can use the following keywords:
prefixes:
any database table name (tb_cclient, tb_ccampain_clients, etc)
script (maps to scriptquestion.alias - scriptanswer.alias)
client (maps to tb_cclient)
cclient (maps to tb_ccampain_clients)
campaign (maps to tb_cccampaigns)
quotacount, quotapercent, completedcount, completedpercent, averagequotacompletition
suffixes: script alias names or table fields name
operators and functions: most of sql92 keywords will work (=, <>, <, (,),TRIM, LOWER, AND, OR, etc)
examples:
1. (script.alias = ‘fidesz’ or scriptcode.alias = 3 or quotacount.quotaalias >0) and (LOWER(client.name) = ‘john’)
2. quotacompletedpercent.quotaalias < 100
see the keywords
section for more details!
onconditiontrue: if the entercondition result is true, than the next question will be the question with this order (ordernum)
onconditionfalse: if the entercondition result is false, than the next question will be the question with this order (ordernum)
Running external applications: