debug

boolean

Debug mode (see "Debug Mode" on page 8 for any explanation)

Example:

plugin.tx_logicalform_pi1 {

  debug = 1

}

0

special

string:title,register

There are two special values title and register (see "General Explanation" on page 4). In the default mode the special value is empty.

Special value "title": The result of the query will be written in the browsers  page title.

Example 1:

plugin.tx_logicalform_pi1 {

  special = title

  query {

    ...

  }

}

Special value "register": The result of the query will be written in a first step in the register with the name "my_name" and than in a second step in <meta>-tag description.

Example 2:

plugin.tx_logicalform_pi1 {

  special = register

  register = my_name

  query {

    ...

  }

}

page.meta.description {

  # Delete the default value

  field > 

  data = register:my_name

}

empty

keywords

boolean

If set, the result will be changed in a comma seperated list of words

Example:

plugin.tx_logicalform_pi1 {

  keywords  = 1

}

0

keywords.minLength

int

The length of a keyword at least.

Example:

plugin.tx_logicalform_pi1 {

  keywords.minLength = 6

}

4

keywords.amount

int

The maximum amount of keywords

Example:

plugin.tx_logicalform_pi1 {

  keywords.amount = 12

}

10

keywords.positiveList

comma seperated values/string

The positive of possible keywords which hasn't the minimum length.

Example:

plugin.tx_logicalform_pi1 {

  keywords.positiveList = VCD, ABS

}

empty

query

->QUERY

SQL query with typoscript properties.

Example:

plugin.tx_logicalform_pi1.query {

  select = CONCAT(`title`, ': ', `short`)

  from   = `tt_news`

  where  = `uid` = $1

  var.1  = tx_ttnews[tt_news]

}

empty

select

string

SQL select command.

Example 1:

plugin.tx_logicalform_pi1.query {

  select = CONCAT(`title`, ': ', `short`)

  from   = `tt_news`

  where  = `uid` = $1

  var.1  = tx_ttnews[tt_news]

}

Example 2:

plugin.tx_logicalform_pi1.query {

  select = CONCAT(product.title, ' \           (', category.title, ')') as value

  from   = tt_products as product, \           tt_products_cat as category

  where  = product.uid = $1 \           AND product.category = category.uid \           AND product.deleted = 0 \           AND product.hidden = 0

  var.1  = tx_ttproducts_pi1[product]

}

empty

from

string

SQL table name. See example "select" above.

empty

where

string

SQL where expression. See example "select" above.

empty

var

array

Variable in a SQL query.

You can use a variable with any name in your SQL query everywhere.

If you need a post variable see property "method" below.

See the example in the tutorial 'The property "query"' on page 4.

Example:

plugin.tx_logicalform_pi1.query {

  ...

  where             = `uid` = $my_var AND \                      `pid` = $my_other_var

  var.my_var        = tx_ttnews[tt_news]

  var.my_other_var  = tx_ttnews[pid]

}

It's only an example. There is no global var tx_ttnews[pid]

empty

method

string:get, post

You can choose the global array GET or POST for substituting variables in your SQL query.

Example:

plugin.tx_logicalform_pi1.query {

  method = post

}

get

maxLength

integer

If set, the result will be cut after maxLength chars.

Example:

plugin.tx_logicalform_pi1.query {

  maxLength   = 100

}

0

dontStripTags

boolean

If set, the result value won't be stripped of it's HTML-tags.

Example:

plugin.tx_logicalform_pi1.query {

  dontStripTags  = 1

}

0