Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3

...

A simple example that uses a table that has a description and url column

Code Block
xml
xml
linenumberstruexml
<data:datadefinition id="property_doclink">
	<datasourcedataconnection datasource="docsource" table="PROPERTY_DOCLINK" key="PID">
		<parameter column="description"/>
		<parameter column="url"/>
	</datasourcedataconnection>
</data:datadefinition>

<dbdms:dms id="old_docs">
	<name>Uploaded Documents</name>
	<entity>property</entity>
	<datadefinition>property_doclink</datadefinition>
</dbdms:dms>

Creating a list of documents to display properties in google maps.
The data definition constructs the url by concatenating a the first part of a google maps search to a pre-formatted address column from the database.

Code Block
xml
xml
linenumberstruexml
<data:datadefinition id="property_google">
	<datasourcedataconnection datasource="docsource" table="PROPERTY_DOCLINK" key="PID">
		<parameter name="url" type="url" text="Display in Google Maps" url="'http://maps.google.com.au/?q='|address"/>
		<parameter column="address"/>
	<datasourcedataconnection>
</data:datadefinition>

<dbdms:dms id="google">
	<name>Google Maps</name>
	<entity>property</entity>
	<datadefinition>property_google</datadefinition>
</dbdms:dms>