XML Fragment Property Populated from SQL Query

I'm investigating using Opencities Map to connect to various business properties utilising the DB Property value.... these would all be read only and "live linked via an sql query..."

I'm having trouble finding documentation on how to accomplish this.
I can't get the xml fragment to be populated with the DB property.... 

The XML for a feature definition below seems to be populating both NestedBusinessProp and BusinnessStringProp directly onto the Feature....

I'd expect it to have the following.....

<MyBusinessPropertyFeature>
  <ObjectId/>
  <BP>
    <NestedBusinessProp />
  </BP>
  <BusinnessStringProp/>
</MyBusinessPropertyFeature>

However it ends up
<MyBusinessPropertyFeature>
  <ObjectId/>
  <BP/>
  <NestedBusinessProp />
  <BusinnessStringProp/>
</MyBusinessPropertyFeature>

<feature name="MyBusinessPropertyFeature" 
	alias="MyBusinessPropertyFeature" 
	collectionName="MyBusinessPropertyFeature" 
	type="polygon" 
	minOccurs="0" 
	maxOccurs="1" 
	category="TestFeatures" 
	propogateToParent="never" 
	propogateFromParent="never" 
	propogateDeleteToParent="never" 
	propagateFromRoot="never" 
	propagateCopyFromRoot="never" 
	propagateCopyToParent="never" 
	propagateCopyFromParent="never" 
	description="Testing Business Properties" 
	schemaVersion="http://www.portbris.com.au/spatial.data/3.5.0">
	<Symbology type="linear">
		<ApplyDrawingScale>false</ApplyDrawingScale>
		<ApplyScaleOnEdit>false</ApplyScaleOnEdit>
		<OverrideScale useCriteria="" />
		<Color>0</Color>
		<Level>MyBusinessPropertyFeature</Level>
		<Style>0</Style>
		<StyleScale>1.0</StyleScale>
		<Weight>0</Weight>
		<Class>0</Class>
		<Priority>0</Priority>
		<Transparency>0</Transparency>
		<FillType genAssocRegions="false">ColorFilled</FillType>
		<FillMode>2</FillMode>
		<FillColor>16</FillColor>
		<FillColor>0</FillColor>
		<AreaType>0</AreaType>
	</Symbology>
	<Properties>
		<property name="ObjectId" alias="ObjectId" preferenceType="session" type="String" dbProp="">
			<initialValue key="placing" synch="true" valueType="blank" />
			<dataSpec numChars="40" min="1" minExclusive="false" max="40" maxExclusive="false" />
			<itemSpec type="textBox" label="" labelColor="black">
				<textBox formatToDisplay="%s" formatToInternal="%s" />
			</itemSpec>
			<hookOptions upperCase="false" readOnly="false" dontclear="false" required="false" synchOnChangeKey="" />
			<toolTip>For linking to bussiness property.</toolTip>
		</property>
		<property name="BP" alias="Businness Properties" preferenceType="none" type="xmlfragment">
			<dataSpec numChars="-1" />
			<initialValue key="placing" synch="true" valueType="xml">
				<BP />
			</initialValue>
			<property name="NestedBusinessProp" preferenceType="none" type="string" dbProp="true" dbTable="test.BusinnessProperties">
				<initialValue key="placing" synch="true" valueType="value" />
				<dataSpec numChars="50" min="" minExclusive="false" max="" maxExclusive="false" />
				<itemSpec type="textBox" label="NestedBusinessProp:" labelColor="black">
					<textBox formatToDisplay="%s" formatToInternal="%s" />
				</itemSpec>
			</property>
		</property>
		<property name="BusinnessStringProp" preferenceType="none" type="string" dbProp="true" dbTable="test.BusinnessProperties">
			<initialValue key="placing" synch="true" valueType="value" />
			<dataSpec numChars="50" min="" minExclusive="false" max="" maxExclusive="false" />
			<itemSpec type="textBox" label="BusinnessStringProp:" labelColor="black">
				<textBox formatToDisplay="%s" formatToInternal="%s" />
			</itemSpec>
		</property>
	</Properties>
	<Database valueStartDelimiter="" valueEndDelimiter="" defaultTable="">
		<insertList />
		<copyList />
		<updateList />
		<queryList>
			<query>SELECT BusinnessStringProp, NestedBusinessProp FROM test.BusinnessProperties WHERE test.BusinnessProperties.ObjectId = '[ObjectId]'</query>
		</queryList>
		<deleteList />
		<dbLinkList />
	</Database>
</feature>

I currently get around all this geospatial admin project setup by importing the data, I'd rather use in-built function.

Hopefully this will expose the properties to be used in theming and reports.... 

Parents Reply Children
No Data