Project

General

Profile

Actions

Bug #6116

open

value of checkbox not saved

Added by Nicola Chiapolini almost 6 years ago. Updated 16 days ago.

Status:
Priorize
Priority:
High
Assignee:
Carsten Rose
Target version:
Start date:
29.05.2018
Due date:
% Done:

0%

Estimated time:
Discuss:
Prio Planung:
No
Vote:

Description

In one of our forms, we have the following checkbox:

INSERT INTO `FormElement` (`id`, `formId`, `feIdContainer`, `dynamicUpdate`, `enabled`, `name`, `label`, `mode`, `modeSql`, `class`, `type`, `subrecordOption`, `encode`, `checkType`, `checkPattern`, `onChange`, `ord`, `tabindex`, `size`, `maxLength`, `bsLabelColumns`, `bsInputColumns`, `bsNoteColumns`, `rowLabelInputNote`, `note`, `adminNote`, `tooltip`, `placeholder`, `value`, `sql1`, `parameter`, `parameterLanguageA`, `parameterLanguageB`, `parameterLanguageC`, `parameterLanguageD`, `clientJs`, `feGroup`, `deleted`, `modified`, `created`) VALUES
(164, 1000, 380, 'no', 'yes', 'reg_done', 'Final', 'hidden', '{{SELECT IF( title_hash != \'\' AND (SELECT SUM(head) FROM `phd_committee_members` WHERE phd_student=(SELECT id FROM phd_graduation WHERE shortname=\'{{shortname}}\' )) = 1,\'show\', \'hidden\') FROM phd_graduation WHERE shortname=\'{{shortname}}\' }}', 'native', 'checkbox', '', 'specialchar', 'alnumx', '', '', 200, 0, '', '', '', '', '', 'row,label,/label,input,/input,note,/note,/row', '', '', '', '', '', '{{!SELECT IF(reg_done, reg_done, NOW()) FROM phd_graduation WHERE id=\'{{id:RE}}\' }}', 'checkBoxMode = single\r\nlabel2 = Submit this form and start the process.', '', '', '', '', '', '', 'no', '2018-05-29 09:34:25', '2018-03-09 10:06:26');

This checkbox gets correctly displayed with all the values of mode sql below, but only saved to the DB for some of them:

good


{{SELECT IF( title_hash != '' ,'show', 'hidden') FROM phd_graduation WHERE shortname='{{shortname}}' }}
{{SELECT IF( title_hash != '' AND (SELECT SUM(head) FROM `phd_committee_members` WHERE phd_student=(SELECT id FROM phd_graduation WHERE shortname='{{shortname}}' )) = 1,'show', 'hidden') FROM phd_graduation WHERE shortname='{{shortname}}' }}

bad


{{SELECT IF( title_hash != '' ,'show', 'hidden') FROM phd_graduation WHERE id='{{id}}' }}
{{SELECT IF( title_hash != '' ,'show', 'hidden') FROM phd_graduation WHERE shortname='{{shortname:R0}}' }}
{{SELECT IF( title_hash != '' ,'show', 'hidden') FROM phd_graduation WHERE shortname='{{shortname:FR0}}' }}
{{SELECT IF( title_hash != '' AND (SELECT SUM(head) FROM `phd_committee_members` WHERE phd_student='{{id:R0}}') = 1,'show', 'hidden') FROM phd_graduation WHERE id='{{id:R0}}' }}

shortname is a nativ / extra field in the form, id is not part of the form.

In any case, a displayed field should also be saved ;-)

Actions #1

Updated by Carsten Rose over 5 years ago

  • Target version set to 18.10.3
Actions #2

Updated by Carsten Rose over 5 years ago

  • Target version changed from 18.10.3 to 18.12.1
Actions #3

Updated by Carsten Rose over 5 years ago

  • Target version changed from 18.12.1 to 141
Actions #4

Updated by Carsten Rose over 4 years ago

  • Priority changed from Normal to Urgent
  • Target version changed from 141 to 146
Actions #5

Updated by Carsten Rose over 4 years ago

  • Status changed from New to Some day maybe
Actions #6

Updated by Carsten Rose over 4 years ago

  • Status changed from Some day maybe to New
Actions #7

Updated by Carsten Rose about 4 years ago

  • Assignee set to Carsten Rose
Actions #8

Updated by Carsten Rose about 4 years ago

  • Target version changed from 146 to 55
Actions #9

Updated by Carsten Rose about 4 years ago

  • Target version changed from 55 to next7
Actions #10

Updated by Carsten Rose almost 3 years ago

  • Target version changed from next7 to next4
Actions #11

Updated by Carsten Rose almost 3 years ago

  • Target version changed from next4 to next3
Actions #12

Updated by Carsten Rose almost 3 years ago

  • Priority changed from Urgent to Normal
Actions #13

Updated by Carsten Rose almost 3 years ago

  • Status changed from New to Priorize
Actions #14

Updated by Carsten Rose over 2 years ago

  • Priority changed from Normal to High
Actions #15

Updated by Carsten Rose over 2 years ago

  • Target version changed from next3 to next2
Actions #16

Updated by Carsten Rose over 1 year ago

  • Target version changed from next2 to Check if 'high' is still necessary
Actions #17

Updated by Carsten Rose 5 months ago

  • Target version changed from Check if 'high' is still necessary to 24.8.0
  • Prio Planung set to No
Actions #18

Updated by Carsten Rose 16 days ago

  • Target version changed from 24.8.0 to 24.3.1
Actions

Also available in: Atom PDF