{
  "title": "{{SELECT IF('{{id:R0}}' = 0, 'New issue', CONCAT('<div><span>Issue #{{id:R0}}<\/span><br><span style=\"font-weight: 400; font-size: 0.85em;\">Created by ', CONCAT_WS(' ', p.`{{personFirstNameColumnName:Y}}`, p.`{{personLastNameColumnName:Y}}`), ' on ', DATE_FORMAT('{{created:RE}}', '%d.%m.%Y') , ', updated on ', QDATE_FORMAT('{{modified:RE}}'), '<\/span><\/div>')) FROM (SELECT 1) AS fake LEFT JOIN `{{personTableName:Y}}` AS p ON p.id = '{{pIdCreator:R0}}'}}",
  "noteInternal": "",
  "tableName": "Issue",
  "primaryKey": "",
  "permitNew": "sip",
  "permitEdit": "sip",
  "restMethod": "",
  "escapeTypeDefault": "c",
  "render": "bootstrap",
  "requiredParameterNew": "",
  "requiredParameterEdit": "",
  "dirtyMode": "exclusive",
  "showButton": "new,delete,close,save",
  "multiMode": "none",
  "multiSql": "",
  "multiDetailForm": "",
  "multiDetailFormParameter": "",
  "forwardMode": "auto",
  "forwardPage": "",
  "labelAlign": "default",
  "bsLabelColumns": "",
  "bsInputColumns": "",
  "bsNoteColumns": "",
  "parameter": "btnCustom[delete] = p:{{pageSlug:T}}?iss={{id:R0}}&action=deleteIssue&deleteId={{id:R0}}|b:btn btn-default navbar-btn|G:glyphicon-trash|q:Do you really want to delete the issue?:warning|o:Delete|s|A:data-ignore-history\r\nrememberLastPill = 0\r\nmessage = {{websocketMessageIssue:Y}}",
  "parameterLanguageA": "",
  "parameterLanguageB": "",
  "parameterLanguageC": "",
  "parameterLanguageD": "",
  "recordLockTimeoutSeconds": 900,
  "deleted": "no",
  "modified": "2025-06-18 16:34:40",
  "created": "2025-04-08 18:49:15",
  "FormElement_ff": [
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "myGeneralPill",
      "label": "General",
      "mode": "show",
      "modeSql": "",
      "class": "container",
      "type": "pill",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "auto",
      "checkPattern": "",
      "onChange": "",
      "ord": 10,
      "tabindex": 0,
      "size": "",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2025-06-18 16:34:40",
      "created": "2025-05-05 14:02:14"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "title",
      "label": "",
      "mode": "required",
      "modeSql": "",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "auto",
      "checkPattern": "",
      "onChange": "",
      "ord": 20,
      "tabindex": 0,
      "size": "",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "0",
      "bsInputColumns": "12",
      "bsNoteColumns": "0",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "Title",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2025-06-18 16:34:40",
      "created": "2025-04-08 18:51:49",
      "containerName_ff": "myGeneralPill"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "description",
      "label": "",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "editor",
      "subrecordOption": "",
      "encode": "none",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 30,
      "tabindex": 0,
      "size": "",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "0",
      "bsInputColumns": "12",
      "bsNoteColumns": "0",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "Description...",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2025-06-18 16:34:40",
      "created": "2025-04-08 18:51:49",
      "containerName_ff": "myGeneralPill"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "stId",
      "label": "Status",
      "mode": "required",
      "modeSql": "",
      "class": "native",
      "type": "select",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "auto",
      "checkPattern": "",
      "onChange": "",
      "ord": 40,
      "tabindex": 0,
      "size": "",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "2",
      "bsInputColumns": "2",
      "bsNoteColumns": "1",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "{{p:\/status|b|t:Setup|g:_blank|G:glyphicon-new-window AS link}}",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "{{!SELECT st.id AS id\r\n      , st.name AS label\r\n    FROM Status AS st, Grp AS gr\r\n    WHERE st.grId = gr.id\r\n      AND gr.reference = 'qfq_status_issue'\r\n}}",
      "parameter": "emptyItemAtStart = 1",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2025-06-18 16:34:40",
      "created": "2025-04-08 18:51:49",
      "containerName_ff": "myGeneralPill"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "myContextPill",
      "label": "Context",
      "mode": "show",
      "modeSql": "",
      "class": "container",
      "type": "pill",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "auto",
      "checkPattern": "",
      "onChange": "",
      "ord": 50,
      "tabindex": 0,
      "size": "",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2025-06-18 16:34:40",
      "created": "2025-05-05 14:13:38"
    },
    {
      "dynamicUpdate": "yes",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "prId",
      "label": "Project",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "select",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "auto",
      "checkPattern": "",
      "onChange": "",
      "ord": 60,
      "tabindex": 0,
      "size": "",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "2",
      "bsInputColumns": "3",
      "bsNoteColumns": "1",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note",
      "note": "{{p:\/project|b|t:Setup|g:_blank|G:glyphicon-new-window|A:style=\"position: absolute; right: 15px;\" AS link}}",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "{{!SELECT pr.id AS id\r\n      , pr.name AS label\r\n    FROM Project AS pr, Glue AS gl, Person AS p, Grp AS gr\r\n    WHERE p.id = '{{pIdUser:Y0}}'\r\n      AND p.id = gl.pId\r\n      AND gl.grId = gr.id\r\n      AND (gr.reference = 'qfq_project_access_write'\r\n      OR gr.reference = 'qfq_project_access_admin')\r\n      AND gl.xId = pr.id\r\n}}",
      "parameter": "emptyItemAtStart = 1",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2025-06-18 16:34:40",
      "created": "2025-04-11 10:48:33",
      "containerName_ff": "myContextPill"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "accessContact",
      "label": "Access",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "checkbox",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "auto",
      "checkPattern": "",
      "onChange": "",
      "ord": 70,
      "tabindex": 0,
      "size": "",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "2",
      "bsInputColumns": "4",
      "bsNoteColumns": "0",
      "rowLabelInputNote": "label,\/label,input,\/input,note,\/note,\/row",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "label2 = Contact\/Watcher",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2025-06-18 16:34:40",
      "created": "2025-04-08 18:51:49",
      "containerName_ff": "myContextPill"
    },
    {
      "dynamicUpdate": "yes",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "pIdAssignee",
      "label": "Assignee",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "auto",
      "checkPattern": "",
      "onChange": "",
      "ord": 80,
      "tabindex": 0,
      "size": "",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "2",
      "bsInputColumns": "4",
      "bsNoteColumns": "0",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "hideZero = 1\r\nfillStoreVar = {{!SELECT GROUP_CONCAT(DISTINCT p.id) AS pIds FROM (`{{personTableName:Y}}` AS p, Grp AS gr) LEFT JOIN (Project AS pr, Glue AS gl) ON pr.id = {{prId:FR0:digit}} AND gl.xId = pr.id AND p.id = gl.pId AND gl.grId = gr.id WHERE IFNULL(gl.id, '{{prId:FR0:digit}}' = 0) AND (gr.reference = 'qfq_project_access_write' OR gr.reference = 'qfq_project_access_read' OR gr.reference = 'qfq_project_access_admin') GROUP BY NULL}}\r\ntypeAheadSql = SELECT p.id AS id, CONCAT(p.`{{personFirstNameColumnName:Y}}`, ' ', p.`{{personLastNameColumnName:Y}}`, ' (', p.`{{personEmailColumnName:Y}}`, ')') AS label FROM `{{personTableName:Y}}` AS p WHERE (CONCAT(p.`{{personFirstNameColumnName:Y}}`, ' ', p.`{{personLastNameColumnName:Y}}`) LIKE ? OR CONCAT(p.`{{personLastNameColumnName:Y}}`, ' ', p.`{{personFirstNameColumnName:Y}}`) LIKE ? OR p.`{{personEmailColumnName:Y}}` LIKE ? OR CONCAT(p.`{{personFirstNameColumnName:Y}}`, ' ', p.`{{personLastNameColumnName:Y}}`, ' (', p.`{{personEmailColumnName:Y}}`, ')') LIKE ?) AND FIND_IN_SET (p.id, '{{pIds:VE}}') GROUP BY p.id\r\ntypeAheadSqlPrefetch = SELECT CONCAT(p.`{{personFirstNameColumnName:Y}}`, ' ', p.`{{personLastNameColumnName:Y}}`, ' (', p.`{{personEmailColumnName:Y}}`, ')') FROM `{{personTableName:Y}}` AS p WHERE (p.id LIKE ? OR CONCAT(p.`{{personFirstNameColumnName:Y}}`, ' ', p.`{{personLastNameColumnName:Y}}`, ' (', p.`{{personEmailColumnName:Y}}`, ')') LIKE ?) AND FIND_IN_SET(p.id, '{{pIds:VE}}') GROUP BY p.id",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2025-06-20 13:21:31",
      "created": "2025-04-08 18:51:49",
      "containerName_ff": "myContextPill"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "pIdCreator",
      "label": "Creator",
      "mode": "show",
      "modeSql": "{{SELECT IF('{{isAdmin:S0}}' OR '{{beUser:T}}' != '', 'required', 'hidden')}}",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "auto",
      "checkPattern": "",
      "onChange": "",
      "ord": 90,
      "tabindex": 0,
      "size": "",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "2",
      "bsInputColumns": "4",
      "bsNoteColumns": "0",
      "rowLabelInputNote": "label,\/label,input,\/input,note,\/note,\/row",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "{{SELECT IF('{{id:R0}}', '{{pIdCreator:R0}}', '{{pIdUser:Y0}}')}}",
      "sql1": "",
      "parameter": "extraButtonLock = 1\r\nhideZero = 1\r\ntypeAheadSql = SELECT p.id AS id, CONCAT(p.`{{personFirstNameColumnName:Y}}`, ' ', p.`{{personLastNameColumnName:Y}}`, ' (', p.`{{personEmailColumnName:Y}}`, ')') AS label FROM `{{personTableName:Y}}` AS p WHERE CONCAT(p.`{{personFirstNameColumnName:Y}}`, ' ', p.`{{personLastNameColumnName:Y}}`) LIKE ? OR CONCAT(p.`{{personLastNameColumnName:Y}}`, ' ', p.`{{personFirstNameColumnName:Y}}`) LIKE ? OR p.`{{personEmailColumnName:Y}}` LIKE ? OR CONCAT(p.`{{personFirstNameColumnName:Y}}`, ' ', p.`{{personLastNameColumnName:Y}}`, ' (', p.`{{personEmailColumnName:Y}}`, ')') LIKE ? GROUP BY p.id\r\ntypeAheadSqlPrefetch = SELECT CONCAT(p.`{{personFirstNameColumnName:Y}}`, ' ', p.`{{personLastNameColumnName:Y}}`, ' (', p.`{{personEmailColumnName:Y}}`, ')') FROM `{{personTableName:Y}}` AS p WHERE p.id LIKE ? OR CONCAT(p.`{{personFirstNameColumnName:Y}}`, ' ', p.`{{personLastNameColumnName:Y}}`, ' (', p.`{{personEmailColumnName:Y}}`, ')') LIKE ? GROUP BY p.id",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2025-06-18 16:34:40",
      "created": "2025-04-22 08:41:08",
      "containerName_ff": "myContextPill"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "myTags",
      "label": "Tags",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "auto",
      "checkPattern": "",
      "onChange": "",
      "ord": 100,
      "tabindex": 0,
      "size": "",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "2",
      "bsInputColumns": "4",
      "bsNoteColumns": "6",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "{{SELECT GROUP_CONCAT(CONCAT(gl.id\r\n      , ':'\r\n      , grC.name))\r\n    FROM Glue AS gl, Grp AS grC, Grp AS grP\r\n    WHERE grC.id = gl.grId\r\n      AND gl.xId = '{{id:R0}}'\r\n      AND grC.grId = grP.id\r\n      AND grP.reference = 'qfq_issue_tag'}}",
      "sql1": "",
      "parameter": "fillStoreVar = {{!SELECT gr.id AS grId FROM Grp AS gr WHERE gr.reference = 'qfq_issue_tag'}}\r\ntypeAheadTag = 1\r\ntypeAheadSql = SELECT gr.id AS id, gr.name AS value FROM Grp AS gr LEFT JOIN Glue AS gl ON gl.grId = gr.id AND gl.xId = '{{id:R0}}' WHERE gr.grId = '{{grId:V0}}' AND ISNULL(gl.id) AND gr.name LIKE ?\r\ntypeAheadMinLength = 2\r\ntypeAheadPedantic = 0\r\ntypeAheadTagInsert = {{INSERT INTO Grp (grId, name) VALUES('{{grId:V0}}', '{{tagValue:VE}}')}}\r\ntypeAheadGlueInsert = {{INSERT INTO Glue (xId, grId) VALUES('{{id:R0}}', '{{tagId:V0}}')}}\r\ntypeAheadGlueDelete = {{DELETE FROM Glue WHERE id = '{{tagId:V0}}'}}",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2025-06-19 16:43:38",
      "created": "2025-05-15 13:31:17",
      "containerName_ff": "myContextPill"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "myContactPill",
      "label": "Contact",
      "mode": "show",
      "modeSql": "",
      "class": "container",
      "type": "pill",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "auto",
      "checkPattern": "",
      "onChange": "",
      "ord": 110,
      "tabindex": 0,
      "size": "",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2025-06-18 16:34:40",
      "created": "2025-05-05 14:16:05"
    },
    {
      "dynamicUpdate": "yes",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "pIdContact",
      "label": "Contact person",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "auto",
      "checkPattern": "",
      "onChange": "",
      "ord": 120,
      "tabindex": 0,
      "size": "",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "2",
      "bsInputColumns": "4",
      "bsNoteColumns": "0",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "hideZero = 1\r\ntypeAheadSql = SELECT p.id AS id, CONCAT(p.`{{personFirstNameColumnName:Y}}`, ' ', p.`{{personLastNameColumnName:Y}}`, ' (', p.`{{personEmailColumnName:Y}}`, ')') AS label FROM `{{personTableName:Y}}` AS p WHERE CONCAT(p.`{{personFirstNameColumnName:Y}}`, ' ', p.`{{personLastNameColumnName:Y}}`) LIKE ? OR CONCAT(p.`{{personLastNameColumnName:Y}}`, ' ', p.`{{personFirstNameColumnName:Y}}`) LIKE ? OR p.`{{personEmailColumnName:Y}}` LIKE ? OR CONCAT(p.`{{personFirstNameColumnName:Y}}`, ' ', p.`{{personLastNameColumnName:Y}}`, ' (', p.`{{personEmailColumnName:Y}}`, ')') LIKE ? GROUP BY p.id\r\ntypeAheadSqlPrefetch = SELECT CONCAT(p.`{{personFirstNameColumnName:Y}}`, ' ', p.`{{personLastNameColumnName:Y}}`, ' (', p.`{{personEmailColumnName:Y}}`, ')') FROM `{{personTableName:Y}}` AS p WHERE p.id LIKE ? OR CONCAT(p.`{{personFirstNameColumnName:Y}}`, ' ', p.`{{personLastNameColumnName:Y}}`, ' (', p.`{{personEmailColumnName:Y}}`, ')') LIKE ? GROUP BY p.id",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2025-06-18 16:34:40",
      "created": "2025-04-08 18:51:49",
      "containerName_ff": "myContactPill"
    },
    {
      "dynamicUpdate": "yes",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "mailContact",
      "label": "Contact person mail",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "auto",
      "checkPattern": "",
      "onChange": "",
      "ord": 130,
      "tabindex": 0,
      "size": "",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "2",
      "bsInputColumns": "4",
      "bsNoteColumns": "0",
      "rowLabelInputNote": "label,\/label,input,\/input,note,\/note,\/row",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2025-06-18 16:34:40",
      "created": "2025-04-08 18:51:49",
      "containerName_ff": "myContactPill"
    },
    {
      "dynamicUpdate": "yes",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "mailWatcherSet",
      "label": "Watcher mail (list)",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "auto",
      "checkPattern": "",
      "onChange": "",
      "ord": 140,
      "tabindex": 0,
      "size": "",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "2",
      "bsInputColumns": "10",
      "bsNoteColumns": "0",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2025-06-18 16:34:40",
      "created": "2025-04-08 18:51:49",
      "containerName_ff": "myContactPill"
    },
    {
      "dynamicUpdate": "yes",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "mailNotificationSet",
      "label": "Notification",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "checkbox",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "auto",
      "checkPattern": "",
      "onChange": "",
      "ord": 150,
      "tabindex": 0,
      "size": "",
      "maxLength": "3",
      "labelAlign": "default",
      "bsLabelColumns": "2",
      "bsInputColumns": "10",
      "bsNoteColumns": "0",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "checkBoxMode = multi\r\nitemList = {{SELECT CONCAT_WS(',', pCr.`{{personEmailColumnName:Y}}`, QIFEMPTY(pCo.`{{personEmailColumnName:Y}}`, NULL), QIFEMPTY('{{mailContact:FRE:allbut}}', NULL), QIFEMPTY('{{mailWatcherSet:FRE:allbut}}', NULL), QIFEMPTY(pAs.`{{personEmailColumnName:Y}}`, NULL)) FROM `{{personTableName:Y}}` AS pCr LEFT JOIN `{{personTableName:Y}}` AS pCo ON pCo.id = '{{pIdContact:FR0:digit}}' LEFT JOIN `{{personTableName:Y}}` AS pAs ON pAs.id = '{{pIdAssignee:FR0:digit}}' WHERE pCr.id = QIFEMPTY('{{pIdCreator:FRS0:digit}}', '{{pIdUser:SY0}}')}}",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2025-06-18 16:34:40",
      "created": "2025-04-08 18:51:49",
      "containerName_ff": "myContactPill"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "myTimelinePill",
      "label": "Timeline",
      "mode": "show",
      "modeSql": "",
      "class": "container",
      "type": "pill",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "auto",
      "checkPattern": "",
      "onChange": "",
      "ord": 160,
      "tabindex": 0,
      "size": "",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2025-06-18 16:34:40",
      "created": "2025-05-05 14:17:31"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "start",
      "label": "Start date",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "date",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "auto",
      "checkPattern": "",
      "onChange": "",
      "ord": 170,
      "tabindex": 0,
      "size": "",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "2",
      "bsInputColumns": "2",
      "bsNoteColumns": "2",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2025-06-18 16:34:40",
      "created": "2025-04-08 18:51:49",
      "containerName_ff": "myTimelinePill"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "due",
      "label": "Due date",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "date",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "auto",
      "checkPattern": "",
      "onChange": "",
      "ord": 180,
      "tabindex": 0,
      "size": "",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "2",
      "bsInputColumns": "2",
      "bsNoteColumns": "2",
      "rowLabelInputNote": "label,\/label,input,\/input,note,\/note,\/row",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2025-06-18 16:34:40",
      "created": "2025-04-08 18:51:49",
      "containerName_ff": "myTimelinePill"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "reminder",
      "label": "Reminder",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "datetime",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "auto",
      "checkPattern": "",
      "onChange": "",
      "ord": 190,
      "tabindex": 0,
      "size": "",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "2",
      "bsInputColumns": "2",
      "bsNoteColumns": "2",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2025-06-18 16:34:40",
      "created": "2025-04-08 18:51:49",
      "containerName_ff": "myTimelinePill"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "estimatedTime",
      "label": "Estimated time",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "auto",
      "checkPattern": "",
      "onChange": "",
      "ord": 200,
      "tabindex": 0,
      "size": "",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "2",
      "bsInputColumns": "2",
      "bsNoteColumns": "2",
      "rowLabelInputNote": "label,\/label,input,\/input,note,\/note,\/row",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2025-06-18 16:34:40",
      "created": "2025-04-08 18:51:49",
      "containerName_ff": "myTimelinePill"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "myAttachmentPill",
      "label": "Attachments",
      "mode": "show",
      "modeSql": "",
      "class": "container",
      "type": "pill",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "auto",
      "checkPattern": "",
      "onChange": "",
      "ord": 210,
      "tabindex": 0,
      "size": "",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2025-06-18 16:34:40",
      "created": "2025-05-05 14:21:18"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "myMultiUpload",
      "label": "File(s)",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "note",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "auto",
      "checkPattern": "",
      "onChange": "",
      "ord": 220,
      "tabindex": 0,
      "size": "",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "2",
      "bsInputColumns": "0",
      "bsNoteColumns": "4",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "#!report\r\n\r\n{\r\n  sql = SELECT gr.id AS _grUploadIssueId\r\n          FROM Grp AS gr\r\n          WHERE gr.reference = 'qfq_upload_issue'\r\n}\r\n\r\n{\r\n  sql = SELECT '' FROM DUAL WHERE '{{id:R0}}' != 0\r\n\r\n  althead = <p>Please save this record first.<\/p>\r\n\r\n  {\r\n    sql = SELECT CONCAT('uploadId:', IFNULL(fu.uploadId, 0)\r\n              , '|F:\/fileadmin\/protected\/issues\/', YEAR(NOW()), '\/{{id:R0}}\/'\r\n              , '|recordData:xId:{{id:R0}},grId:{{grUploadIssueId:R0}},pId:{{pIdUser:S0}}'\r\n              , '|accept:'\r\n              , '|M|x') AS _upload\r\n            FROM Issue AS i\r\n            LEFT JOIN FileUpload AS fu\r\n            ON fu.grId = '{{grUploadIssueId:R0}}'\r\n              AND fu.xId = i.id\r\n              AND fu.uploadId != 0\r\n            WHERE i.id = '{{id:R0}}'\r\n            GROUP BY i.id\r\n  }\r\n}",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2025-06-18 16:34:40",
      "created": "2025-04-25 07:59:15",
      "containerName_ff": "myAttachmentPill"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "myCommentPill",
      "label": "Comment",
      "mode": "show",
      "modeSql": "{{SELECT IF('{{id:R0}}' = 0, 'hidden', 'show')}}",
      "class": "container",
      "type": "pill",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "auto",
      "checkPattern": "",
      "onChange": "",
      "ord": 230,
      "tabindex": 0,
      "size": "",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2025-06-18 16:34:40",
      "created": "2025-05-05 14:19:27"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "myComment",
      "label": "",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "editor",
      "subrecordOption": "",
      "encode": "none",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 240,
      "tabindex": 0,
      "size": "",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "0",
      "bsInputColumns": "12",
      "bsNoteColumns": "0",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2025-06-18 16:34:40",
      "created": "2025-04-08 19:03:44",
      "containerName_ff": "myCommentPill"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "myCommentAccess",
      "label": "Access (comment)",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "checkbox",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "auto",
      "checkPattern": "",
      "onChange": "",
      "ord": 250,
      "tabindex": 0,
      "size": "",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "2",
      "bsInputColumns": "4",
      "bsNoteColumns": "0",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "{{accessContact:RE}}",
      "sql1": "",
      "parameter": "checked = yes\r\nunchecked = no\r\nlabel2 = Contact\/Watcher",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2025-06-18 16:34:40",
      "created": "2025-04-17 12:54:00",
      "containerName_ff": "myCommentPill"
    },
    {
      "dynamicUpdate": "yes",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "myCommentMailNotificationSet",
      "label": "Notification (comment)",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "checkbox",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "auto",
      "checkPattern": "",
      "onChange": "",
      "ord": 260,
      "tabindex": 0,
      "size": "",
      "maxLength": "3",
      "labelAlign": "default",
      "bsLabelColumns": "2",
      "bsInputColumns": "10",
      "bsNoteColumns": "0",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "checkBoxMode = multi\r\nitemList = {{SELECT CONCAT_WS(',', pCr.`{{personEmailColumnName:Y}}`, QIFEMPTY(pCo.`{{personEmailColumnName:Y}}`, NULL), QIFEMPTY('{{mailContact:FRE:allbut}}', NULL), QIFEMPTY('{{mailWatcherSet:FRE:allbut}}', NULL), QIFEMPTY(pAs.`{{personEmailColumnName:Y}}`, NULL)) FROM `{{personTableName:Y}}` AS pCr LEFT JOIN `{{personTableName:Y}}` AS pCo ON pCo.id = '{{pIdContact:FR0:digit}}' LEFT JOIN `{{personTableName:Y}}` AS pAs ON pAs.id = '{{pIdAssignee:FR0:digit}}' WHERE pCr.id = QIFEMPTY('{{pIdCreator:FRS0:digit}}', '{{pIdUser:Y0}}')}}",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2025-06-18 16:34:40",
      "created": "2025-04-28 16:27:01",
      "containerName_ff": "myCommentPill"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "myCommentMultiUpload",
      "label": "File(s) (comment)",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "note",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "auto",
      "checkPattern": "",
      "onChange": "",
      "ord": 270,
      "tabindex": 0,
      "size": "",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "2",
      "bsInputColumns": "0",
      "bsNoteColumns": "4",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "#!report\r\n\r\n{\r\n  sql = SELECT gr.id AS _grUploadCommentNewId\r\n          FROM Grp AS gr\r\n          WHERE gr.reference = 'qfq_upload_commentNew'\r\n}\r\n\r\n{\r\n  sql = SELECT CONCAT('uploadId:0'\r\n            , '|F:\/fileadmin\/protected\/issues\/', YEAR(NOW()), '\/{{id:R0}}\/comments\/'\r\n            , '|recordData:xId:{{id:R0}},grId:{{grUploadCommentNewId:R0}},pId:{{pIdUser:S0}}'\r\n            , '|accept:'\r\n            , '|M|x') AS _upload\r\n}",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2025-06-18 16:34:40",
      "created": "2025-04-28 16:29:22",
      "containerName_ff": "myCommentPill"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "formId",
      "label": "",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "extra",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "auto",
      "checkPattern": "",
      "onChange": "",
      "ord": 280,
      "tabindex": 0,
      "size": "",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2025-06-18 16:34:40",
      "created": "2025-04-25 10:10:51"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "formName",
      "label": "",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "extra",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "auto",
      "checkPattern": "",
      "onChange": "",
      "ord": 290,
      "tabindex": 0,
      "size": "",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2025-06-18 16:34:40",
      "created": "2025-04-25 10:11:08"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "xId",
      "label": "",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "extra",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "auto",
      "checkPattern": "",
      "onChange": "",
      "ord": 300,
      "tabindex": 0,
      "size": "",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2025-06-18 16:34:40",
      "created": "2025-04-25 10:11:29"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "myAfterSave",
      "label": "",
      "mode": "show",
      "modeSql": "",
      "class": "action",
      "type": "afterSave",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "auto",
      "checkPattern": "",
      "onChange": "",
      "ord": 310,
      "tabindex": 0,
      "size": "",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "fillStoreVar = {{!SELECT grUploadComment.id AS grUploadCommentId, grUploadCommentNew.id AS grUploadCommentNewId FROM Grp AS grUploadComment, Grp AS grUploadCommentNew WHERE grUploadComment.reference = 'qfq_upload_comment' AND grUploadCommentNew.reference = 'qfq_upload_commentNew'}}\r\nsqlBefore = {{UPDATE Issue AS i SET i.mailNotification = IF('{{mailNotificationSet:RE}}' = '', '0000-00-00 00:00:00', DATE_ADD(NOW(), INTERVAL {{issueMailNotificationInterval:Y:::2}} MINUTE)) WHERE i.id = '{{id:R0}}'}}\r\nsqlInsert = {{INSERT INTO Comment(isId, pIdCreator, comment, accessContact, mailNotificationSet) SELECT '{{id:R0}}', '{{pIdUser:S0}}', '{{myComment:FE:all}}', '{{myCommentAccess:FE:alnumx}}', QIFEMPTY('{{myCommentMailNotificationSet:FE:allbut}}', '') FROM DUAL WHERE '{{myComment:FE:all}}' != ''}}\r\nsqlAfter = {{UPDATE FileUpload AS fu SET fu.xId = '{{slaveId:V0}}', fu.grId = '{{grUploadCommentId:V0}}' WHERE fu.grId = '{{grUploadCommentNewId:V0}}' AND fu.xId = '{{id:R0}}' AND fu.pId = '{{pIdUser:S0}}'}}",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2025-06-18 16:34:40",
      "created": "2025-04-08 19:06:28"
    }
  ]
}