{
  "title": "Form Editor: {{SELECT id, \" \/ \", name FROM Form WHERE id = {{r:S0}}}} (DB: {{dbNameQfq:Y}})",
  "noteInternal": "FormElement Editor",
  "tableName": "Form",
  "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": "maxVisiblePill=10\r\nclass=container-fluid\r\ndbIndex={{indexQfq:Y}}\r\nfillStoreVar={{!SELECT IF('{{name:FR:alnumx}}'='form' OR '{{name:FR:alnumx}}'='formElement', '{{indexQfq:Y}}', '{{indexData:Y}}') AS idx}}",
  "parameterLanguageA": "",
  "parameterLanguageB": "",
  "parameterLanguageC": "",
  "parameterLanguageD": "",
  "recordLockTimeoutSeconds": 900,
  "deleted": "no",
  "modified": "2024-06-26 10:46:29",
  "created": "2021-04-06 12:05:41",
  "FormElement_ff": [
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "",
      "label": "Delete FE",
      "mode": "show",
      "modeSql": "",
      "class": "action",
      "type": "beforeDelete",
      "subrecordOption": "",
      "encode": "none",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 10,
      "tabindex": 0,
      "size": "0",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "sqlAfter={{DELETE FROM FormElement WHERE formId={{id:R}} }}",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "virtual": "",
      "deleted": "no",
      "modified": "2024-06-26 10:46:29",
      "created": "2021-04-06 12:05:41"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "",
      "label": "Check for double form name",
      "mode": "show",
      "modeSql": "",
      "class": "action",
      "type": "beforeSave",
      "subrecordOption": "",
      "encode": "none",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 20,
      "tabindex": 0,
      "size": "0",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "sqlValidate={{!SELECT f.id FROM Form AS f WHERE  f.name!=\"\" AND f.name=\"{{name:F:alnumx}}\" AND f.id!={{id:R0}}  }}\nexpectRecords=0\nmessageFail=There is already another form with the name \"{{name:F:alnumx}}\".",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "virtual": "",
      "deleted": "no",
      "modified": "2024-06-26 10:46:29",
      "created": "2021-04-06 12:05:41"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "",
      "label": "Check for MultiForm: multiMode!='none'",
      "mode": "show",
      "modeSql": "",
      "class": "action",
      "type": "beforeSave",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "auto",
      "checkPattern": "",
      "onChange": "",
      "ord": 35,
      "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": "sqlValidate = {{!SELECT '' FROM DUAL WHERE ( ('{{multiMode:FRE:alnumx}}'!='none') != ('{{multiSql:FRE:all:SH}}'!='') ) }} \r\n\r\nexpectRecords = 0\r\nalert = 'Please either specify \"Multi SQL\" and \"Multi Mode\" or none of them.:danger'",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2025-04-23 17:37:35",
      "created": "2025-04-23 16:15:31"
    },    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "basic",
      "label": "Basic",
      "mode": "show",
      "modeSql": "",
      "class": "container",
      "type": "pill",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 30,
      "tabindex": 0,
      "size": "0",
      "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": "",
      "virtual": "",
      "deleted": "no",
      "modified": "2024-06-26 10:46:29",
      "created": "2021-04-06 12:05:41"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "name",
      "label": "Name",
      "mode": "required",
      "modeSql": "",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "pattern",
      "checkPattern": "[a-zA-Z0-9._+-]+",
      "onChange": "",
      "ord": 40,
      "tabindex": 0,
      "size": "0",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#form-name\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "autofocus\ndata-pattern-error=Allowed characters: alphabet, number or . - +",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "virtual": "",
      "deleted": "no",
      "modified": "2024-06-26 10:46:29",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "basic"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "title",
      "label": "Title",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "none",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 50,
      "tabindex": 0,
      "size": "80,1,350",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#form-title\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "virtual": "",
      "deleted": "no",
      "modified": "2024-06-26 10:46:29",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "basic"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "noteInternal",
      "label": "Note",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 60,
      "tabindex": 0,
      "size": "80,1,350",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#form-note\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "virtual": "",
      "deleted": "no",
      "modified": "2024-06-26 10:46:29",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "basic"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "tableName",
      "label": "Table",
      "mode": "required",
      "modeSql": "",
      "class": "native",
      "type": "select",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 70,
      "tabindex": 0,
      "size": "0",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#form-tablename\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "{{[{{idx:V}}]!SHOW tables}}",
      "parameter": "emptyItemAtStart",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "virtual": "",
      "deleted": "no",
      "modified": "2024-06-26 10:46:29",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "basic"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "myFormWizardButton",
      "label": "FormWizard",
      "mode": "show",
      "modeSql": "{{SELECT IF({{id:R0}} = 0,'hidden','show' )}}",
      "class": "native",
      "type": "note",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "auto",
      "checkPattern": "",
      "onChange": "",
      "ord": 80,
      "tabindex": 0,
      "size": "",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#form-wizard\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "#!report\r\nform = '{{form:SE}}'\r\n\r\n# Create Wizard button\r\n10 {\r\n  sql = SELECT CONCAT('p:{{pageSlug:T}}?form=FormWizard&formId={{id:R0}}&tableName={{tableName:R}} |s|b|t:Wizard') AS _link\r\n}",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "virtual": "",
      "deleted": "no",
      "modified": "2024-06-26 12:56:41",
      "created": "2024-05-15 10:44:51",
      "containerName_ff": "basic"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "parameterLanguageA",
      "label": "Language: {{formLanguageALabel:YE}}",
      "mode": "show",
      "modeSql": "{{SELECT IF(\"{{formLanguageAId:YE}}\"=\"\",\"hidden\",\"show\" ) }}",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "none",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 90,
      "tabindex": 0,
      "size": "80,1,350",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#multiple-languages\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "virtual": "",
      "deleted": "no",
      "modified": "2024-06-26 10:46:29",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "basic"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "parameterLanguageB",
      "label": "Language: {{formLanguageBLabel:YE}}",
      "mode": "show",
      "modeSql": "{{SELECT IF(\"{{formLanguageBId:YE}}\"=\"\",\"hidden\",\"show\" ) }}",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "none",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 100,
      "tabindex": 0,
      "size": "80,1,350",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#multiple-languages\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "virtual": "",
      "deleted": "no",
      "modified": "2024-06-26 10:46:29",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "basic"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "parameterLanguageC",
      "label": "Language: {{formLanguageCLabel:YE}}",
      "mode": "show",
      "modeSql": "{{SELECT IF(\"{{formLanguageCId:YE}}\"=\"\",\"hidden\",\"show\" ) }}",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "none",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 110,
      "tabindex": 0,
      "size": "80,1,350",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#multiple-languages\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "virtual": "",
      "deleted": "no",
      "modified": "2024-06-26 10:46:29",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "basic"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "parameterLanguageD",
      "label": "Language: {{formLanguageDLabel:YE}}",
      "mode": "show",
      "modeSql": "{{SELECT IF(\"{{formLanguageDId:YE}}\"=\"\",\"hidden\",\"show\" ) }}",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "none",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 120,
      "tabindex": 0,
      "size": "80,1,350",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#multiple-languages\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "virtual": "",
      "deleted": "no",
      "modified": "2024-06-26 10:46:29",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "basic"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "formelement",
      "label": "Formelement",
      "mode": "show",
      "modeSql": "",
      "class": "container",
      "type": "pill",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 130,
      "tabindex": 0,
      "size": "0",
      "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": "",
      "virtual": "",
      "deleted": "no",
      "modified": "2024-06-26 10:46:29",
      "created": "2021-04-06 12:05:41"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "jsonImport",
      "label": "",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "note",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "auto",
      "checkPattern": "",
      "onChange": "",
      "ord": 130,
      "tabindex": 0,
      "size": "",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,input,\/input,note,\/note,\/row",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "#!report\r\n\r\n10.sql = SELECT CONCAT('p:{{pageSlug:T}}?form=formElementJson&r=',id,'&feid=0|s|b|G:glyphicon-plus|t:json') AS _link FROM Form WHERE id = {{id:R0}}",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2023-03-30 11:52:14",
      "created": "2023-03-30 11:44:39",
      "containerName_ff": "formelement"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "",
      "label": "FormElements",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "subrecord",
      "subrecordOption": "edit,delete,new",
      "encode": "none",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 160,
      "tabindex": 0,
      "size": "0",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "{{!SELECT fe.ord AS _ord, IF( fe.enabled=\"yes\", IF( fe.enabled=\"yes\" AND fe.feIdContainer=0 AND !ISNULL(feCX.id) AND fe.class=\"native\", \"danger\", IF( fe.class=\"container\", \"text-info\",  IF( fe.class=\"action\", \"text-success\", \"\"))), \"text-muted\") AS _rowClass, IF( fe.enabled=\"yes\", IF(fe.feIdContainer=0 AND !ISNULL(feCX.id) AND fe.class=\"native\", \"Please choose a container for this formelement\", fe.class), \"Disabled\") AS _rowTitle, fe.id AS _id, CONCAT('<span id=\"qfq-dnd-ord-id-', fe.id,'\">', fe.ord, '<\/span><br><small class=\"text-muted\">',fe.id, '<\/small>') AS 'Ord|nostrip', CONCAT( IFNULL( CONCAT( feC.name, '<br><small class=\"text-muted\">', fe.feIdContainer, '<\/small>'),'')) AS 'Container|200|nostrip', fe.name AS \"Name|50\", fe.label AS Label, QIFEMPTY(fe.modeSql, fe.mode) AS Mode, fe.class AS Class, \tfe.type AS Type, IF(fe.dynamicUpdate=\"yes\", \"<span class='glyphicon glyphicon-random'><\/span><span style='display: none;'>0<\/span>\",\"<span style='display: none;'>1<\/span>\") AS \"Dyn|nostrip\", CONCAT('p:{{pageSlug:T}}&form=formElementJson&r=',fe.formId,'&feid=',fe.id,'|s|b|G:glyphicon-pencil|t:json') AS 'link|json' FROM FormElement AS fe LEFT JOIN FormElement AS feC ON feC.id=fe.feIdContainer AND feC.formId=fe.formId LEFT JOIN FormElement AS feCX ON feCX.class=\"container\" AND feCX.enabled=\"yes\" AND feCX.type=\"pill\" AND feCX.formId=fe.formId WHERE fe.formId={{id:R0}} GROUP BY fe.id ORDER BY fe.ord, fe.id}}",
      "parameter": "form=formElement\r\ndetail=id:formId\r\nsubrecordTableClass=table table-hover qfq-subrecord-table qfq-color-grey-2 tablesorter tablesorter-filter tablesorter-column-selector",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2025-04-23 14:16:35",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "formelement"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "showButton",
      "label": "Show button",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "checkbox",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 150,
      "tabindex": 0,
      "size": "0",
      "maxLength": "5",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#showbutton\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "checkBoxMode = multi\norientation=vertical",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "virtual": "",
      "deleted": "no",
      "modified": "2024-06-26 10:46:29",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "layout"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "labelAlign",
      "label": "Label Align",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "radio",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "alnumx",
      "checkPattern": "",
      "onChange": "",
      "ord": 160,
      "tabindex": 0,
      "size": "0",
      "maxLength": "5",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#form-label-align\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "buttonClass",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "virtual": "",
      "deleted": "no",
      "modified": "2024-06-26 10:46:29",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "layout"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "parameter",
      "label": "Parameter",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "editor",
      "subrecordOption": "",
      "encode": "none",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 170,
      "tabindex": 0,
      "size": "",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#form-parameter\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "editorType=codemirror\ncodemirror-keywords-qfq-base=uploadType btnCustom btnTopLeftOrder btnTopRightOrder btnFooterLeftOrder btnFooterRightOrder btnTopWrap btnTopLeftWrap btnTopRightWrap btnFooterWrap btnFooterLeftWrap btnFooterRightWrap bsColumns maxVisiblePill class classTitle classPill classBody extraDeleteForm data-pattern-error data-required-error data-match-error data-error buttonOnChangeClass ldapServer ldapBaseDn ldapAttributes ldapSearch ldapTimeLimit typeAheadLdap typeAheadLdapSearch typeAheadLdapValuePrintf typeAheadLdapIdPrintf typeAheadLdapSearchPerToken typeAheadLimit typeAheadMinLength mode activateFirstRequiredTab enterAsSubmit submitButtonText saveButtonActive saveButtonText saveButtonTooltip saveButtonClass saveButtonGlyphIcon closeButtonText closeButtonTooltip closeButtonClass closeButtonGlyphIcon deleteButtonText deleteButtonTooltip deleteButtonClass deleteButtonGlyphIcon newButtonText newButtonTooltip newButtonClass newButtonGlyphIcon extraButtonInfoClass extraButtonInfoMinWidth fillStoreVar showIdInFormTitle formSubmitLogMode sessionTimeoutSeconds maxFileSize requiredPosition clearMe rememberLastPill doNotLogColumn fieldSetClass showHistory showHistoryTitle showHistoryFeUserSet e: recentLog multiMsgNoRecord",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "virtual": "",
      "deleted": "no",
      "modified": "2024-06-26 10:46:29",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "layout"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "bsLabelColumns",
      "label": "BS Label Columns",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 180,
      "tabindex": 0,
      "size": "0",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#form-layout\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "{{bsLabelColumns:Y}}",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "virtual": "",
      "deleted": "no",
      "modified": "2024-06-26 10:46:29",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "layout"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "bsInputColumns",
      "label": "BS Input Columns",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 190,
      "tabindex": 0,
      "size": "0",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "{{bsInputColumns:Y}}",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "virtual": "",
      "deleted": "no",
      "modified": "2024-06-26 10:46:29",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "layout"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "bsNoteColumns",
      "label": "BS Note Columns",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 200,
      "tabindex": 0,
      "size": "0",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "{{bsNoteColumns:Y}}",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "virtual": "",
      "deleted": "no",
      "modified": "2024-06-26 10:46:29",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "layout"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "layout",
      "label": "Layout",
      "mode": "show",
      "modeSql": "",
      "class": "container",
      "type": "pill",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 210,
      "tabindex": 0,
      "size": "0",
      "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": "",
      "virtual": "",
      "deleted": "no",
      "modified": "2024-06-26 10:46:29",
      "created": "2021-04-06 12:05:41"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "forwardMode",
      "label": "Forward",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "radio",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 220,
      "tabindex": 0,
      "size": "0",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#form-forward\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "buttonClass=btn-default",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "virtual": "",
      "deleted": "no",
      "modified": "2024-06-26 10:46:29",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "access"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "forwardPage",
      "label": "Forward URL \/ Page",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "none",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 230,
      "tabindex": 0,
      "size": "0",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#form-forward\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "virtual": "",
      "deleted": "no",
      "modified": "2024-06-26 10:46:29",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "access"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "requiredParameterNew",
      "label": "Required Parameter NEW",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 240,
      "tabindex": 0,
      "size": "0",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#required-parameter-new-edit\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "virtual": "",
      "deleted": "no",
      "modified": "2024-06-26 10:46:29",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "access"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "requiredParameterEdit",
      "label": "Required Parameter EDIT",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 250,
      "tabindex": 0,
      "size": "0",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#required-parameter-new-edit\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "virtual": "",
      "deleted": "no",
      "modified": "2024-06-26 10:46:29",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "access"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "permitNew",
      "label": "Permit New",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "radio",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 260,
      "tabindex": 0,
      "size": "0",
      "maxLength": "10",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#form-permitnewedit\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "buttonClass=btn-default",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "virtual": "",
      "deleted": "no",
      "modified": "2024-06-26 10:46:29",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "access"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "permitEdit",
      "label": "Permit Edit",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "radio",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 270,
      "tabindex": 0,
      "size": "0",
      "maxLength": "10",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#form-permitnewedit\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "buttonClass=btn-default",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "virtual": "",
      "deleted": "no",
      "modified": "2024-06-26 10:46:29",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "access"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "restMethod",
      "label": "Permit REST",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "checkbox",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 280,
      "tabindex": 0,
      "size": "0",
      "maxLength": "10",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#rest\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "buttonClass=btn-default\nitemList=get,post:insert,put:update,delete",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "virtual": "",
      "deleted": "no",
      "modified": "2024-06-26 10:46:29",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "access"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "escapeTypeDefault",
      "label": "Escape type default",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "radio",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 290,
      "tabindex": 0,
      "size": "0",
      "maxLength": "10",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Variable.html#variable-escape\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "itemList=c:config,s:single,d:double,l:ldap search,L:ldap value,m:mysql realEscapeString,-:none\nbuttonClass=btn-default",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "virtual": "",
      "deleted": "no",
      "modified": "2024-06-26 10:46:29",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "access"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "dirtyMode",
      "label": "Record Locking",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "radio",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 300,
      "tabindex": 0,
      "size": "0",
      "maxLength": "10",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#locking-record\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "buttonClass=btn-default",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "virtual": "",
      "deleted": "no",
      "modified": "2024-06-26 10:46:29",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "access"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "access",
      "label": "Access",
      "mode": "show",
      "modeSql": "",
      "class": "container",
      "type": "pill",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 310,
      "tabindex": 0,
      "size": "0",
      "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": "",
      "virtual": "",
      "deleted": "no",
      "modified": "2024-06-26 10:46:29",
      "created": "2021-04-06 12:05:41"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "recordLockTimeoutSeconds",
      "label": "Lock timeout (seconds)",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 320,
      "tabindex": 0,
      "size": "0",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#locking-record\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "{{SELECT IF(\"{{recordLockTimeoutSeconds:R0}}\"=0,\"{{recordLockTimeoutSeconds:Y0}}\",\"{{recordLockTimeoutSeconds:R0}}\")}}",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "virtual": "",
      "deleted": "no",
      "modified": "2024-06-26 10:46:29",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "access"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "primaryKey",
      "label": "Primary Key",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 330,
      "tabindex": 0,
      "size": "0",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#form-primary-key\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "id",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "virtual": "",
      "deleted": "no",
      "modified": "2024-06-26 10:46:29",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "access"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "multi",
      "label": "Multi",
      "mode": "show",
      "modeSql": "",
      "class": "container",
      "type": "pill",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 340,
      "tabindex": 0,
      "size": "0",
      "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": "",
      "virtual": "",
      "deleted": "no",
      "modified": "2024-06-26 10:46:29",
      "created": "2021-04-06 12:05:41"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "multi",
      "label": "Multi",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "fieldset",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 350,
      "tabindex": 0,
      "size": "0",
      "maxLength": "0",
      "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": "",
      "virtual": "",
      "deleted": "no",
      "modified": "2024-06-26 10:46:29",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "multi"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "multiMode",
      "label": "Multi Mode",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "radio",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 360,
      "tabindex": 0,
      "size": "0",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#layout-table\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "buttonClass",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "virtual": "",
      "deleted": "no",
      "modified": "2024-06-26 10:46:29",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "multi"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "multiSql",
      "label": "Multi SQL",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "editor",
      "subrecordOption": "",
      "encode": "none",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 370,
      "tabindex": 0,
      "size": "",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#multi-form\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "editorType=codemirror",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "virtual": "",
      "deleted": "no",
      "modified": "2024-06-26 10:46:29",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "multi"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "multiDetailForm",
      "label": "Multi Detail Form",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 380,
      "tabindex": 0,
      "size": "0",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#multi-form\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "virtual": "",
      "deleted": "no",
      "modified": "2024-06-26 10:46:29",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "multi"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "multiDetailFormParameter",
      "label": "Multi Detail Form Parameter",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "none",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 390,
      "tabindex": 0,
      "size": "0",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#multi-form\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "virtual": "",
      "deleted": "no",
      "modified": "2024-06-26 10:46:29",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "multi"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "TableDefinition",
      "label": "Table Definition",
      "mode": "show",
      "modeSql": "",
      "class": "container",
      "type": "pill",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "auto",
      "checkPattern": "",
      "onChange": "",
      "ord": 400,
      "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": "",
      "virtual": "",
      "deleted": "no",
      "modified": "2024-06-26 10:46:29",
      "created": "2022-06-03 15:17:24"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "Table",
      "label": "",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "note",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "auto",
      "checkPattern": "",
      "onChange": "",
      "ord": 410,
      "tabindex": 0,
      "size": "",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "col-md-12",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,input,\/input,\/row",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "#!report\r\n#\r\n# Form: Tabledefinition\r\n#\r\ngetDbIndex {\r\n  sql = SELECT IF(f.tableName='formElement' OR f.tableName='form'\r\n            , {{indexQfq:Y}}\r\n            , {{indexData:Y}} ) AS _idx,\r\n            IF(f.tableName='formElement' OR f.tableName='form'\r\n            , '{{dbNameQfq:Y}}'\r\n            , '{{dbNameData:Y}}' ) AS _dataBase\r\n          FROM Form AS f \r\n          WHERE f.id='{{id:R0}}'\r\n            \r\n  tableDefinition {\r\n    dbIndex={{idx:R}}\r\n    sql = SELECT COLUMN_NAME, COLUMN_TYPE, COLUMN_KEY, COLUMN_DEFAULT, EXTRA\r\n          FROM information_schema.columns\r\n          WHERE table_schema = '{{dataBase:RE}}'\r\n            AND table_name = '{{tableName:RE}}';\r\n              \r\n    \r\n    head = <h3>Table: <code>[{{DB_{{idx:R}}_SERVER:Y}}] {{DB_{{idx:R}}_NAME:Y}}.{{tableName:RE}}<\/code><\/h3><table class=\"table table-hover qfq-table-50\"><thead><tr><th>Field<\/th><th>Type<\/th><th>Null<\/th><th>Key<\/th><th>Default<\/th><th>Extra<\/th><\/tr><\/thead>\r\n    tail = <\/table>\r\n    rbeg = <tr>\r\n    rend = <\/tr>\r\n    fbeg = <td>\r\n    fend = <\/td>\r\n  }\r\n}",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "virtual": "",
      "deleted": "no",
      "modified": "2024-06-26 10:46:29",
      "created": "2022-06-03 15:06:55",
      "containerName_ff": "TableDefinition"
    }
  ]
}