...
Name | Type | Cardinality |
|---|---|---|
parameter | 0..n | |
cache | 0..1 | |
| from | urn:com.cohga.server.data.database#1.0:from | 0..n |
| where | urn:com.cohga.server.data.database#1.0:where | 0..n |
| sort | urn:com.cohga.server.data.database#1.0:sort | 0..n |
| join | urn:com.cohga.server.data.database#1.0:join | 0..n |
| options | urn:com.cohga.server.data.database#1.0:options | 0..1 |
Content
None
Notes
- The cache settings are only used for data source data connections that have a key specified, since it's the key that's used as the cache index
- If no
cachetag is specified then the data will still be cached, but it will use the default cache configuration, to disable caching you need to setdisabletotrueinside the cache definition (see example below). - You can completely disable the caching (for all data definitions that don't have cache setting explicitly set) by setting the startup parameter
weave.cache.defaulttotrue(in startup.cmd, startup.sh and/or weave-service.conf). - If no parameters are specified then the server will generate parameters based on the columns in the underlying table, in this case you should also not include any
fromtags since joins are not currently supported,wheretags are ok though.
...
| Name | Type | Required | Description |
|---|---|---|---|
| table | string | yes | The table to join to |
| on | string | yes | The clause used to join the table |
| type | string | no | The type of join to use |
| clause | string | no | Additional clauses that can be added to the join |
...
options
Properties
Name | Type | Required | Description |
|---|---|---|---|
rpad | number | no | If the key value needs to be padded with spaces on the right to make it match the database this specified the total length of the final padded value. For example rpad = 10 would change a key value from "value" to "value....." (where each . is a space) |
lpad | number | no | If the key value needs to be padded with spaces on the left to make it match the database this specified the total length of the final padded value. For example lpad = 10 would change a key value from "value" to ".....value" (where each . is a space) |
| trim | boolean | no | If a key value needs to be trimmed of spaces before being used setting this to true will cause that to be done. |
| maxrows | number | no | Limit the number of rows that will be extracted from the database when generating the data. |
| failOnSubstitutionError | boolean | no | If set to If this is set to The default value for this flag if it is not set is |
Sub-tags
None
Content
None
Examples
| Code Block | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
<data:datadefinition id="roadDetails"> <datasourcedataconnection datasource="datasource.main" table="ROADS" key="RD_NAME" prefix="DISTINCT"/> </data:datadefinition> |
...