...
| 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 |
Examples
| Code Block | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
<data:datadefinition id="roadDetails"> <datasourcedataconnection datasource="datasource.main" table="ROADS" key="RD_NAME" prefix="DISTINCT"/> </data:datadefinition> |
...
| Code Block | ||||
|---|---|---|---|---|
| ||||
<data:datadefinition id="roadDetails"> <datasourcedataconnection datasource="datasource.main" table="ROADS" key="RD_NAME" prefix="DISTINCT"> <join type="left" table="PLANS" on="PLANS.ID=ROADS.PLAN_ID"/>> <clause>PLANS.ACTIVE=TRUE</clause> </join> <parameter name="name" label="Name" column="RD_NAME"/> <parameter name="suffix" label="Suffix" column="RD_SUFFIX"/> <parameter name="type" label="Type" column="RD_TYPE"/> <parameter name="altname" label="Alt. Name" column="ALT_NAME"/> <parameter name="altsuffix" label="Alt. Suffix" column="ALT_SUFFIX"/> <parameter name="alttype" label="Alt. Type" column="ALT_TYPE"/> <parameter type="integer" name="class" label="Class" column="CLASS_CODE"/> <parameter type="url" name="plan" label="Plan" column="'http://imgsvr:8080/gis/documents/plan_'||PLANS.PLAN_CODE||'.pdf'" text="Open"/> </datasourcedataconnection> </data:datadefinition> |
...