Sitemap

• General
• Installation
  • Preparation
    • Report & Form
    • wkhtmltopdf
      • Checklist wkhtml problems
      • HTML to PDF conversion
      • Print
    • Send Email
    • Thumbnail
  • Setup
    • Setup CSS & JS
  • FormEditor
  • Installation: Check List
  • Configuration
    • qfq.project.path.php
    • qfq.json
    • config.qfq.php
    • Extension Manager: QFQ Configuration
    • Custom variables
    • Fill STORE_SYSTEM by SQL
      • periodId
    • DB USER privileges
    • Exception for SECURITY_GET_MAX_LENGTH
    • FE-User: Session timeout seconds
    • Cron Job: Remove Form Backup Files
• Concept
  • SIPs
  • Access privileges
  • Typo3 QFQ content element
    • QFQ Keywords (Bodytext)
  • Report: render
  • QFQ Database
    • System tables
    • Multi Database
      • Base: T3 & QFQ
      • QFQ: System & Data
      • Data: Data1, Data2, …, Data n
    • Different QFQ versions, shared database
• Debug
  • QFQ Log
  • SQL Log
  • MAIL Log
  • Mail Log page (Table MailLog)
  • Redirect all mail to (catch all)
  • Show log files realtime
  • Form Submit Log page
• Variable
  • Store variables
    • Variable name
    • Store
    • Sanitize class
    • Escape/Action class
      • Escape
      • Action
    • Default
    • Type message violate
  • SQL variables
    • Result: string
    • Result: row
    • Database index
  • Row column variables
  • Link column variables
• Security
  • Get Parameter
  • Post Parameter
  • $_SERVER
  • Honeypot
  • Violation
  • Client Parameter via SIP
  • Secure direct file access
  • File upload
  • Typo3 Setup - best practice
• Store
  • Store: FORM - F
  • Store: SIP - S
  • Store: RECORD - R
  • Store: BEFORE - B
  • Store: CLIENT - C
  • Store: TYPO3 (Bodytext) - T
  • Store: VARS - V
    • QFQ values
    • Custom values (via fillStoreVar)
  • Store: LDAP - L
  • Store: SYSTEM - Y
  • Store: USER - U
• LDAP
  • Typeahead (TA) - LDAP
    • Pedantic
    • Prefetch
    • PerToken
  • Fill STORE LDAP (FSL)
• Form
  • General
  • Form process order
  • Record locking
    • Exclusive
    • Advisory
    • None
  • Comment- and space-character
  • Form Settings
    • permitNew & permitEdit
    • Required Parameter New|Edit
    • showButton
    • Forward: Save / Close
      • Forward (=forwardMode)
      • Forward URL / Page (=forwardPage)
    • Example forwardPage
    • Type: combined dynamic mode & URL/page
    • Form.parameter
      • submitButtonText
      • class
      • classPill
      • classBody
      • extraDeleteForm
      • Form mode global
        • Mode
        • Extra
        • Usage example
  • FormElements
  • Class: Container
    • Type: fieldset
    • Type: pill (tab)
    • Type: templateGroup
      • Column: primary record
      • Column: non primary record
        • Load
        • Insert / Update / Delete
  • Class: Native
    • FormElement.value
    • FormElement: ‘Report’ notation
    • FormElement.parameter
      • slaveId, sqlBefore, sqlAfter, …
      • Native FormElements
        • autofocus
        • extraButtonLock
        • extraButtonPassword
        • extraButtonInfo
    • Checkbox / Radio: minWidth
    • Required Position
    • Type: checkbox
    • Type: date
    • Type: datetime
    • Type: extra
    • Type: text
      • Type Ahead
        • Configuration via Form / FormElement
        • SQL
        • LDAP
      • Type Ahead Tag
        • Mode: Tag
        • Mode: Glue
    • Type: editor
    • Type: annotate
      • Grafic
      • Code
    • Type: imageCut
    • Type: note
    • Type: password
    • Type: radio
    • Type: select
    • Type: subrecord
    • Type: time
    • Type: upload
      • FormElement.parameter
      • Deleting a record and the referenced file
      • Upload simple mode
      • Upload advanced mode
      • Split PDF Upload
  • Class: Action
    • FormElement.type: before… | after…
      • FormElement.parameter: sqlValidate
      • FormElement.parameter: slaveId
      • FormElement.parameter: sqlBefore / sqlInsert / sqlUpdate / sqlDelete / sqlAfter
      • Example
      • FormElement.parameter: saveFormJson, saveFormJsonName (System)
    • Type: sendmail
    • Type: paste
  • Form Magic
    • Parameter
    • Variables
    • Action
  • Multi Form
    • Simple
    • Advanced
  • Multiple languages
    • Example
  • Dynamic Update
    • Examples
      • Content of a select list
      • Show / Hide a FormElement
  • Form Layout
    • Custom field width
    • Multiple Elements per row
  • Copy Form
    • Concept
    • Table self referencing records
  • Delete Record
  • Locking Record / Form
  • Best practice
    • View: List vs. Detail
    • Custom default value only for ‘new records’
      • Method 1
      • Method 2
    • Central configured values
    • Debug Report
    • More detailed error messages
    • Form search
    • Form: compute next free ‘ord’ automatically
      • Version 1
      • Version 2
    • Form: Person Wizard - firstname, city
    • Form: Person Wizard - firstname, single note
    • Icons Template Group
    • Chart
    • Upload Form Simple
    • Upload Form Advanced 1
    • Upload Form Advanced 2
    • Typeahead: SQL
    • Typeahead: LDAP with additional values
  • Import/merge form
  • Form As File
    • Json Form Editor
    • Auto Sync
• Report
  • QFQ Report Keywords
  • QFQ content element
    • A simple example
      • Format output: mix style and content
        • Variant 1: pure SQL
        • Variant 2: SQL plus QFQ helper
      • Format output: separate style and content
  • Syntax of report
  • Using Twig
    • Specifying a Template
    • Links
    • Json Decode
    • Available Store Variables
    • Example
  • Debug the bodytext
  • Inline Report editing
  • Structure
    • Text across several lines
      • Join mode: SQL
      • Join mode: strip whitespace
    • Nesting of levels
    • Leading / trailing spaces
    • Braces character for nesting
    • Access column values
  • Wrapping rows and columns: Level
  • Processing of columns in the SQL result
  • Special column names
    • Column: _link
    • Render mode
    • Link Examples
    • Alert: Question
    • Columns: _page[X]
    • Column: _paged
      • Mode: table
      • Mode: form
      • Examples
    • Columns: _Page[X]
    • Column: _Paged
    • Column: _vertical
    • Column: _mailto
    • Column: _sendmail
      • Attachment
    • Column: _img
    • Column: _exec
    • Column: _script
    • Column: _pdf | _file | _zip
    • Column: _savePdf
    • Column: _thumbnail
      • Dimension
      • Cleaning
      • Render
      • Thumbnail: secure
      • Thumbnail: public
    • Column: _monitor
    • Copy to clipboard
    • API Call QFQ Report (e.g. AJAX)
    • REST Client
  • Special SQL Functions (prepared statements)
    • QBAR: Escape QFQ Delimiter
    • QCC: Escape colon / coma
    • QNL2BR: Convert newline to HTML ‘<br>’
    • QMORE: Truncate Long Text - more/less
    • QIFEMPTY: if empty show token
    • QDATE_FORMAT: format a timestamp, show ‘-’ if empty
    • QSLUGIFY: clean a string
    • QENT_SQUOTE: convert single tick to HTML entity &apos;
    • QENT_DQUOTE: convert double tick to HTML entity &quot;
    • QESC_SQUOTE: escape single tick
    • QESC_SQUOTE: escape double tick
    • strip_tags: strip html tags
  • QFQ Function
  • Download
    • Parameter and (element) sources
    • Rendering PDF letters
    • Export area
    • Excel export
      • Setup
      • Best practice
  • Dropdown Menu
  • WebSocket
  • Drag and drop
    • Order elements
      • Part 1: Display list
        • Show / update order value in the browser
      • Part 2: Order records
  • QFQ Icons
  • QFQ CSS Classes
  • Bootstrap
  • Tablesorter
    • Customization of tablesorter
  • Monitor
  • Calendar View
  • Report As File
  • Report Examples
    • Basic Queries
    • Accessing the database
    • Formatting Examples
    • Recent List
    • Table: vertical column title
    • STORE_USER examples
      • Two pages (pass variable)
      • One page (collect variables)
      • Simulate/switch user: feUser
      • Semester switch (remember last choice)
• REST
  • Endpoint
  • GET - Read
  • POST - Insert
  • PUT - Update
  • DELETE - Delete
  • Authorization
    • Token based authorization
• System
  • AutoCron
    • Setup
    • Create / edit AutoCron jobs
    • Usage
      • Job: repeating
      • Job: asynchronous
      • Type: Mail
      • Type: Website
        • Access restriction
        • AutoCron / website: HTTPS protocol
• Application Test
  • Form
  • Report
• General Tips
  • Typo3 Debug Mode
  • Errors
  • Procedure to Find an Irreproducible Error
  • Caching
  • QFQ specific
    • A variable {{<var>}} is empty
    • Page is white: no HTML code at all
    • Problem with query or variables
    • Error read file config.qfq.php: syntax error on line xx
    • Output a text, substitute embedded QFQ variables
    • TypeAhead list with T3 page alias names - use of the T3 DB
    • Set FE-User password
  • Logging
    • General webserver error log
      • Call to undefined function qfq\mb_internal_encoding()
  • Error Messages
    • Internal Server Error
    • Oops, an error occurred! Code: 20180612205917761fc593
    • sendEmail: Error => TLS setup failed
    • sendEmail: ‘random’ injected spaces
  • Javascript problem
  • TinyMCE
    • Glyph Icons in ‘<span>’
  • FE User
• Coding Guideline
  • Constants
  • QFQ content record
  • QFQ Form
• Use Case
  • Self Registration
    • Table: Person
    • Registration
      • Page: Registration
      • Form: registration
    • Request password reset link
      • Page: reset
      • Form: passwordReset
    • Set new password
      • Page: set
      • Form: passwordSet
• License
  • Software distributed together with QFQ
• Sitemap
• Searching Documentation
  • Search query syntax
    • Exact phrase search
    • Exact phrase search with slop value
    • Prefix query
    • Fuzzy query
    • Build complex queries
• Release
  • Version 21.x.x
    • Notes
    • Features
    • Bug Fixes
  • Version 21.6.0
    • Notes
    • Features
    • Bug Fixes
  • Version 21.5.1
    • Notes
    • Features
    • Bug Fixes
  • Version 21.5.0
    • Features
    • Bug Fixes
  • Version 21.4.0
    • Notes
    • Features
    • Bug Fixes
  • Version 21.3.2
    • Features
    • Bug Fixes
  • Version 21.3.1
    • Notes
    • Features
    • Bug Fixes
  • Version 21.3.0
    • Notes
    • Features
    • Bug Fixes
  • Version 21.2.0
    • Notes
    • Features
    • Bug Fixes
  • Version 20.11.0
    • Features
    • Bug Fixes
  • Version 20.9.0
    • Notes
    • Features
    • Bug Fixes
  • Version 20.6.2
    • Bug Fixes
  • Version 20.6.1
    • Features
  • Version 20.6.0
    • Notes
    • Features
    • Bug Fixes
  • Version 20.4.1
    • Notes
    • Features
  • Version 20.4.0
    • Notes
    • Features
    • Bug Fixes
  • Version 20.2.0
    • Notes
    • Features
    • Bug Fixes
  • Version 20.1.1
    • Bug Fixes
  • Version 20.1.0
    • Notes
    • Features
    • Bug Fixes
  • Version 19.12.0
    • Notes
    • Features
    • Bug Fixes
  • Version 19.11.3
    • Features
    • Bug Fixes
  • Version 19.11.2
    • Notes
    • Features
    • Bug Fixes
  • Version 19.11.1
    • Bug Fixes
  • Version 19.11.0
    • Notes
    • Features
    • Bug Fixes
  • Version 19.10.0
    • Notes
    • Features
    • Bug Fixes
  • Version 19.9.1
    • Notes
    • Features
    • Bug Fixes
  • Version 19.9.0
    • Notes
    • Features
    • Bug Fixes
  • Version 19.8.0
    • Features
    • Bug Fixes
  • Version 19.7.1
    • Notes
    • Features
    • Bug Fixes
  • Version 19.7.0
    • Notes
    • Features
    • Bug Fixes
  • Version 19.6.2
    • Notes
    • Features
    • Bug Fixes
  • Version 19.6.1
    • Notes
    • Features
    • Bug Fixes
  • Version 19.6.0
    • Notes
    • Bug Fixes
  • Version 19.5.1
    • Notes
    • Features
    • Bug Fixes
  • Version 19.5.0
    • Notes
    • Features
    • Bug Fixes
  • Version 19.3.2
    • Notes
    • Features
    • Bug Fixes
  • Version 19.3.1
    • Bug Fixes
  • Version 19.3.0
    • Notes
    • Features
    • Bug Fixes
  • Version 19.2.3
    • Notes
    • Features
    • Bug Fixes
  • Version 19.2.2
    • Notes
    • Features
    • Bug Fixes
  • Version 19.2.1
    • Notes
    • Features
    • Bug Fixes
  • Version 19.2.0
    • Bug Fixes
  • Version 19.1.3
    • Notes
    • Features
    • Bug Fixes
  • Version 19.1.2
    • Notes
    • Features
    • Bug Fixes
  • Version 19.1.1
    • Bug Fixes
  • Version 19.1.0
    • Features
    • Bug Fixes
  • Version 18.12.3
    • Features
    • Bug Fixes
  • Version 18.12.2
    • Notes
  • Version 18.12.1
    • Notes
    • Features
    • Bug Fixes
  • Version 18.12.0
    • Notes
    • Features
    • Bug Fixes
  • Version 18.10.3
    • Notes
    • Features
    • Bug Fixes
  • Version 18.10.2
    • Features
    • Bug Fixes
  • Version 18.10.1
    • Features
    • Bug Fixes
  • Version 18.10.0
    • Features
    • Bug Fixes
  • Version 18.9.2
    • Notes
    • Features
  • Version 18.9.1
    • Notes
    • Features
    • Bug Fixes
  • Version 18.9.0
    • Features
    • Bug Fixes
  • Version 18.8.2
    • Features
    • Bug Fixes
  • Version 18.8.1
    • Features
    • Bug Fixes
  • Version 18.8.0
    • Notes
    • Features
    • Bug Fixes
  • Version 18.6.1
    • Notes
    • Features
    • Bug Fixes
  • Version 18.6.0
    • Notes
    • Features
    • Bug Fixes
  • Version 18.4.4
    • Bug Fixes
  • Version 18.4.3
    • Bug Fixes
  • Version 18.04.1
    • Bug Fixes
  • Version 18.04.0
    • Notes
    • Features
    • Bug Fixes
  • Version 0.25.15
    • Features
    • Bug Fixes
  • Version 0.25.14a
    • Features
    • Bug Fixes
  • Version 0.25.14
    • Features
    • Bug Fixes
  • Version 0.25.13
    • Features
    • Bug Fixes
  • Version 0.25.12
    • Notes
    • Features
    • Bug Fixes
  • Version 0.25.11
    • Notes
    • Features
    • Bug Fixes
  • Version 0.25.10
    • Notes
    • Features
    • Bug Fixes
  • Version 0.25.9
    • Features
    • Bug Fixes
  • Version 0.25.8
    • Features
    • Bug Fixes
  • Version 0.25.7
    • Notes
    • Features
    • Bug Fixes
  • Version 0.25.6
    • Notes
    • Bug Fixes
  • Version 0.25.5
    • Bug Fixes
  • Version 0.25.4
    • Notes
    • Features
    • Bug Fixes
  • Version 0.25.3
    • Notes
    • Features
    • Bug Fixes
  • Version 0.25.2
    • Notes
    • Features
    • Bug Fixes
  • Version 0.25.1
    • Bug Fixes
  • Version 0.25.0
    • Notes
    • Features
  • Version 0.24.0
    • Notes
    • Features
    • Bug Fixes
  • Version 0.23.1
    • Bug Fixes
  • Version 0.23.0
    • Features
    • Bug Fixes
  • Version 0.22
    • Notes
    • Features
    • Bug Fixes
  • Version 0.21.0
    • Notes
    • Features
  • Version 0.20.0
    • Changes
    • Features
    • Bug Fixes
  • Version 0.19.7
    • Changes
    • Features
    • Bug Fixes
  • Version 0.19.6
    • Features
    • Bug Fixes
  • Version 0.19.5
    • Features
    • Bug Fixes
  • Version 0.19.4
    • Features
    • Bug Fixes
  • Version 0.19.3
    • Changes
    • Bug Fixes
    • Open
  • Version 0.19.2
    • Features
  • Version 0.19.1
    • Features
    • Bug Fixes
  • Version 0.19.0
    • Changes
    • Features
    • Bug Fixes
  • Version 0.18.7
    • Changes
    • Features
    • Bug Fixes
  • Version 0.18.6
    • Features
  • Version 0.18.5
    • Features
    • Bug Fixes
  • Version 0.18.4
    • Bug Fixes
  • Version 0.18.3b
    • Features
    • Bug Fixes
  • Version 0.18.3a
    • Changes
    • Bug Fixes
  • Version 0.18.3
    • Features
  • Version 0.18.2
    • Changes
    • Bug Fixes
  • Version 0.18.1
  • Version 0.18.0
    • Changes
    • Features
    • Bug Fixes
  • Version 0.17.0
    • Changes
    • Features
    • Bug Fixes
  • Version 0.16
    • Changes
    • Features
    • Bug Fixes
  • Version 0.15
    • Changes
    • Features
    • Bug Fixes
  • Version 0.14
    • Changes
    • Features
    • Bug Fixes
  • Version 0.13
    • Changes
    • Features
    • Bug Fixes
  • Version 0.12
    • Changes
    • Features
    • Bug fixes
  • Version 0.11
    • Features
    • Bug fixes
  • Version 0.10
    • Features
    • Bug fixes
  • Version 0.9
    • Features
    • Bug fixes