...
parameter
Properties
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 | (default 'string') | An indicator of how the data should be displayed on the client | |
name | string | no | (default lowercase value of column) | A unique identifier for the parameter | |
label | string | no | (default 'pretty' "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 | ||
---|---|---|
| ||
SELECT columns FROM primary_table left JOIN secondary_table ON primary_table.column = secondary_table.column |
...