EXT: Table for Connector service SQL¶

Database sheet¶

All fields on this sheet must be filled except field “init”.

Fetch mode field may have “Both” value. This extension doesn't work good if both values are send. In case of “mysql” database driver you may see repeated table balues. In general you have to test how it works with your db driver.

Table sheet¶

On this sheet you can set some table parameters. Most fields are self explanatory.

• Column names list - coma delimited list. Column names used in table header.
• Column formats list – coma delimited list. List of column data formats. Available formats are: string, int, dec, date and time. String is the default so you can skip the “string” name.
• List of hidden column numbers - coma delimited list, starting from zero.
• Row classes and Column classes – coma delimited list of classes.
• Caption in first column – if you select this then table caption will be taken from the first field of the first row. Value of the Caption field will not be used.
• Number of column containing change. Values fom this column are compared to 0. You can use this for additional styling. I used this in the table presenting quotations data. Values bigger than 0 was green color, lower than zero was red and values equal 0 was blue ;-) See formatOutputHook hook.

Cache sheet¶

Here you can only set amount of seconds the output table is kept in cache (caching lifetime).

dateFormat¶

timeFormat¶

decimals¶

dec_point¶

thousands_sep¶

plugin.tx_tksvconsqltable_pi1.db

driver¶

server¶

user¶

password¶

database¶

query¶

init¶

fetchMode¶

plugin.tx_tksvconsqltable_pi1.table

templateFile¶

Border¶

cellPadding¶

cellspasing¶

class¶

caption¶

caption_as_span¶

colNames¶

colFormats¶

hiddenCols¶

rowClasses¶

colClasses¶

captionInFirstCol¶

change_col¶

lugin.tx_tksvconsqltable_pi1.cache

lifetime¶

((generated))¶

page = PAGE
page.typeNum = 0
page.10 < plugin.tx_tksvconsqltable_pi1
page.10 {
  cache.lifetime = 3600

  formating {
    dateFormat = Y-m-d
    timeFormat = G:i
    decimals = 4
    dec_point = .
    thousands_sep = ,
  }
  db {
    driver = mssql
    server = 10.20.30.40
    user = SomeUser
    password = your-secret-password
    database = SomeDB
    query = select field1, field2, field3 from sometable
    init >
    fetchMode = 1
  }
  table {
    cellPadding = 2
    cellSpacing = 1
    class = someTableClass
    caption = This is my table
    colNames = Field1 Title, Field2 Title, Field3 Title, Field4 Title
    colFormats = ,date,time,dec
    hiddenCols = 1
    rowClasses = ,alt
    colClasses = ,f1,f2,f3
    captionInFirstCol = 0
    change_col >
  }
}