Page Comparison

...


onSubmit.type	Must be `SQL`
onSubmit.connection	name of the SQL connection - see SQL connections
onSubmit.query	The SQL query you want to execute. The form values are accessible via the form field names as handlebars. If required, you can use Field Processors to manipulate the data before executing the query.
onSubmit.fieldProcessor	See https://portrait.atlassian.net/wiki/spaces/PA7/pages/1029112649/Post+Processing+onSubmit#Field-Processors
onSubmit.conditions	See https://portrait.atlassian.net/wiki/spaces/PA7/pages/1029112649/Post+Processing+onSubmit#Conditions
onSubmit.source	Used for Mode UPDATE details see https://portrait.atlassian.net/wiki/spaces/PA7/pages/1029112649/Post+Processing+onSubmit#Mode-Update-(new-for-SQL-and-Python) and to automatically reindex a given source

Example

Excerpt

name	sql marketing

Code Block

- id: createNewCompany
  onSubmit:
    type: SQL
    connection: organigram
    source: demo-organigram
    fieldProcessor:
      - field: Name
        value: "{{Name}}"
      - field: PARENT_IDS
        value: "{{PARENT_IDS}}"
      - field: PARENT_LABELS
        value: "{{PARENT_LABELS}}"
    query: |
      INSERT INTO DemoOrganigram (Name, PARENT_IDS, PARENT_LABELS)
        VALUES (:Name, :PARENT_IDS, :PARENT_LABELS);
  dialog: config/forms/createNewCompany.json

In this given example, the form-data will be inserted into the table DemoOrganigram via the connection organigram.

The FieldProcessors can either be used to format fields or as a fallback in case of an optional field in the form. If not supplied the Query would fail as there would be no valid parameter :Name if not set previously. With the given FieldProcessor the fallback is an empty String.

Variables

The query can be customized with variables. Available parameters see https://portrait.atlassian.net/wiki/x/DQBwPQ

Versions Compared

Old Version 3

New Version Current

Key

Example

Variables