Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

parameter

Properties

(default (default (default 'pretty'

Name

Type

Required

Default

Description

column

string

yes


The name of the column within the table that this parameter references (can be an sql function also)

type

'string', 'numeric', 'date' or 'url'

no

'string')

An indicator of how the data should be displayed on the client

name

string

no

lowercase value of column)

A unique identifier for the parameter

label

string

no

"pretty" value of column)

A user displayable label for the column

text

string

no


Only when type is 'url'. Specifies text to be displayed to the user instead of the actual url contents

textcolumn

string

no


Only when type is 'url'. Specifies the column that contains text to be displayed to the user instead of the actual url contents

...

If theĀ type were specified as "left" then the SQL generated would be of the form:

Code Block
languagesql
SELECT columns
FROM primary_table left JOIN secondary_table ON primary_table.column = secondary_table.column

...