{
  "title": "autoCron",
  "noteInternal": "",
  "tableName": "Cron",
  "primaryKey": "",
  "permitNew": "sip",
  "permitEdit": "sip",
  "restMethod": "",
  "escapeTypeDefault": "c",
  "render": "bootstrap",
  "requiredParameterNew": "",
  "requiredParameterEdit": "",
  "dirtyMode": "none",
  "showButton": "new,delete,close,save",
  "multiMode": "none",
  "multiSql": "",
  "multiDetailForm": "",
  "multiDetailFormParameter": "",
  "forwardMode": "auto",
  "forwardPage": "",
  "labelAlign": "default",
  "bsLabelColumns": "",
  "bsInputColumns": "",
  "bsNoteColumns": "",
  "parameter": "dbIndex={{indexQfq:Y}}",
  "parameterLanguageA": "",
  "parameterLanguageB": "",
  "parameterLanguageC": "",
  "parameterLanguageD": "",
  "recordLockTimeoutSeconds": 900,
  "deleted": "no",
  "modified": "2021-04-06 12:05:41",
  "created": "2021-04-06 12:05:41",
  "FormElement_ff": [
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "status",
      "label": "Enabled",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "checkbox",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "alnumx",
      "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": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41"
    },
    {
      "dynamicUpdate": "yes",
      "enabled": "yes",
      "name": "type",
      "label": "Type",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "radio",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "alnumx",
      "checkPattern": "",
      "onChange": "",
      "ord": 20,
      "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": "buttonClass=btn-default",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41"
    },
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "nextRun",
      "label": "Next run",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "alnumx",
      "checkPattern": "",
      "onChange": "",
      "ord": 30,
      "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": "extraButtonInfo = Cronjob will be started if specified timestamp is over. If timestamp=0: Job will never be started<br>Every time the jobs runs, this timestamp will be increased automatically by \"frequency\".",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41"
    },
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "frequency",
      "label": "Frequency",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "alnumx",
      "checkPattern": "",
      "onChange": "",
      "ord": 40,
      "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": "extraButtonInfo = Repeat AutoCron-job with the specified interval. If empty: no repeating.<br>E.g.: \"1 DAY\", \"15 MINUTE', \"6 MONTH\" - used directly in SQL-Function \"DATE_ADD(&lt;nextrun&gt;, INTERVAL &lt;frequency&gt;)\"",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41"
    },
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "comment",
      "label": "Comment",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "allbut",
      "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": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41"
    },
    {
      "dynamicUpdate": "yes",
      "enabled": "yes",
      "name": "sql1",
      "label": "Mail",
      "mode": "show",
      "modeSql": "{{SELECT IF(\"{{type:FR:alnumx}}\"=\"mail\",\"show\",\"hidden\") }}",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "none",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 60,
      "tabindex": 0,
      "size": "80,1,350",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "extraButtonInfo = Query: &#123;&#123;!SELECT ... as sendMailTo...&#125;&#125;<br><b>sendMailTo \/ sendMailCc \/ sendMailBcc<\/b>: Separate multiple by comma.<br><b>sendMailFrom<\/b><br><b>sendMailSubject<\/b><br><b>sendMailReplyTo<\/b>: Optional<br><b>sendMailFlagAutoSubmit<\/b>: Optional. on|off. Default on - if \"on\", suppresses OoO answers from receivers.<br><b>sendMailGrId<\/b>: Optional<br><b>sendMailXId<\/b>: Optional",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41"
    },
    {
      "dynamicUpdate": "yes",
      "enabled": "yes",
      "name": "content",
      "label": "{{SELECT IF(\"{{type:FR:alnumx}}\"=\"mail\",\"Mail body\",\"URL\") }}",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "none",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 70,
      "tabindex": 0,
      "size": "80,1,350",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "Website: URL absolute like \"http:\/\/...\" or relative like \"[pageSlug]...\"<br>Mail: Static Body or &#123;{SELECT ...&#125;}",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41"
    },
    {
      "dynamicUpdate": "yes",
      "enabled": "yes",
      "name": "outputFile",
      "label": "Log output to file",
      "mode": "show",
      "modeSql": "{{SELECT IF(\"{{type:FR:alnumx}}\"=\"mail\",\"hidden\",\"show\") }}",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "none",
      "checkType": "pattern",
      "checkPattern": "^(?!\\/fileadmin\\/)(?!.*\\/fileadmin\\/).*",
      "onChange": "",
      "ord": 80,
      "tabindex": 0,
      "size": "",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "CWD: Site installation directory",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "data-pattern-error=Beginning slash before fileadmin is not allowed",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41"
    },
    {
      "dynamicUpdate": "yes",
      "enabled": "yes",
      "name": "outputMode",
      "label": "Mode output",
      "mode": "show",
      "modeSql": "{{SELECT IF(\"{{type:FR:alnumx}}\"=\"mail\",\"hidden\",\"show\") }}",
      "class": "native",
      "type": "radio",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "alnumx",
      "checkPattern": "",
      "onChange": "",
      "ord": 90,
      "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": "buttonClass=btn-default",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41"
    },
    {
      "dynamicUpdate": "yes",
      "enabled": "yes",
      "name": "outputPattern",
      "label": "Pattern to look for on output",
      "mode": "show",
      "modeSql": "{{SELECT IF(\"{{type:FR:alnumx}}\"=\"mail\",\"hidden\",\"show\") }}",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "none",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 100,
      "tabindex": 0,
      "size": "",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "If pattern isn't found, return an error.<br>Check <a tabindex=\"-1\" href=\"https:\/\/secure.php.net\/manual\/en\/pcre.pattern.php\">pcre<\/a> \/ <a tabindex=\"-1\" href=\"https:\/\/regex101.com\/\">Regex101<\/a> ",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41"
    },
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "lastRun",
      "label": "Last run",
      "mode": "readonly",
      "modeSql": "",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "alnumx",
      "checkPattern": "",
      "onChange": "",
      "ord": 120,
      "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": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41"
    },
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "lastStatus",
      "label": "Laststatus",
      "mode": "readonly",
      "modeSql": "",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 130,
      "tabindex": 0,
      "size": "80,1,350",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "3",
      "bsInputColumns": "9",
      "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": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41"
    },
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "inProgress",
      "label": "In progress since",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "alnumx",
      "checkPattern": "",
      "onChange": "",
      "ord": 140,
      "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": "extraButtonInfo = Start time of a running job. When job is finished, this will be set back to 0. A new job will only be started, if this is 0. A progress duration >10mins will be treated as an error.",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41"
    }
  ]
}