<?xml version="1.0" encoding="UTF-8"?>
<config xmlns="urn:com.cohga.server.config#1.0" xmlns:acl="urn:com.cohga.server.acl#1.0" xmlns:arcgisws="urn:com.cohga.server.map.arcgis.ws#1.0" xmlns:arcims="urn:com.cohga.server.map.arcims#1.0" xmlns:attrs="urn:com.cohga.server.userattributes.dd#1.0" xmlns:birt="urn:com.cohga.server.report.birt#1.0" xmlns:cache="urn:com.cohga.server.cache#1.0" xmlns:client="urn:com.cohga.html.client#1.0" xmlns:data="urn:com.cohga.server.data.database#1.0" xmlns:edit="urn:com.cohga.spatial.edit#1.0" xmlns:entity="urn:com.cohga.server.entity#1.0" xmlns:index="urn:com.cohga.server.index#1.0" xmlns:jdbc="urn:com.cohga.server.datasource.jdbc#1.0" xmlns:mapper="urn:com.cohga.server.spatial.mapper#1.0" xmlns:options="urn:com.cohga.server.options#1.0" xmlns:parameter="urn:com.cohga.server.parameter#1.0" xmlns:pool="urn:com.cohga.server.pool#1.0" xmlns:search="urn:com.cohga.server.search.database#1.0" xmlns:spatial="urn:com.cohga.server.spatial.geotools#1.0" xmlns:toc="urn:com.cohga.server.map.toc#1.0" xmlns:wms="urn:com.cohga.server.map.wms#1.0" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:bal="urn:se.viamap.lantmateriet.bal">
<!-- bal.addresses -->
<entity:entity id = "entity.bal.msql.addresses" label = "_Adresser" acl="acl.bal.read"/>
<mapper:mapper id="mapper.bal.msql.adresses">
<spatialEngine>spatialengine.bal.msql.bal</spatialEngine>
<mapping>
<entity>entity.bal.msql.addresses</entity>
<table>ADDRESS_PLACE</table>
<key>objectId</key>
</mapping>
</mapper:mapper>
<data:data id="d.bal.msql.address_place" label="Adress" entity="entity.bal.msql.addresses" datadefinition="dd.bal.msql.address_place" >
<column id="address_area" width="130" align="left" />
<column id="designation_number" width="20" align="right" />
<column id="designation_number_letter" width="20" align="left" />
<column id="post_code" width="50" align="left" />
<column id="post_town" width="150" align="left" />
<column id="adressarea" hidden="true" />
</data:data>
<data:datadefinition id='dd.bal.msql.address_place'>
<datasourcedataconnection key='objectId' table='address_place' datasource='ds.bal.msql.bal'>
<join type='left' table='address_area' on='address_area.objectid = address_place.address_area_reference' />
<join type="left" table="part_of_municipality" on="part_of_municipality.objectid = address_area.part_of_municipality_reference" />
<parameter name='adressarea' label='Id' column='address_area.assigned_name' type='string'/>
<parameter name='address' label='Adress' column="(COALESCE(address_area.assigned_name, '') + ' ') + COALESCE(address_place.designation_number, '') + COALESCE(address_place.designation_number_letter, '')" />
<parameter name='post_code' label='Postnummer' column='address_place.post_code' type='int'/>
<parameter name='post_town' label='Post Town' column='address_place.post_town'/>
<parameter name='part_of_municipality' label='Kommundel' column='part_of_municipality.assigned_name'/>
<parameter name='real_property_key' label='Fastighet' column='address_place.real_property_key'>
<dataset>dd.list.bal.msql.properties.name</dataset>
<valuecolumn>value5</valuecolumn>
<labelcolumn>label5</labelcolumn>
<pagesize>0</pagesize>
</parameter>
<parameter name='address_type' label='Adresstyp' column='address_place.address_type' type='int'>
<dataset>dd.bal.msql.adressplatstyp</dataset>
<valuecolumn>value1</valuecolumn>
<labelcolumn>label1</labelcolumn>
<pagesize>0</pagesize>
</parameter>
<parameter name='position_kind' label='Belägenhet' column='address_place.position_kind' type='int' />
<parameter name='location_address_status' label='Belägenhetstatus' column='address_place.location_address_status' type='int'/>
<parameter name='object_status' label='Objektstatus' column='address_place.object_status' type='int' />
<parameter name='common_name' label='Gemensamt namn' column='address_place.common_name'/>
<parameter name='farm_address_area_reference' label='GÃ¥rdsadress' column='address_place.farm_address_area_reference'/>
<parameter name='object_version' label='Objektversion' column='address_place.object_version' type='int'/>
<parameter name='version_valid_from' label='Gäller från' column='address_place.version_valid_from' type='date'/>
<parameter name='idap' label='Id' column='address_place.objectid' type='int'/>
<parameter name='created_at' label='Created At' column='address_place.created_at' type='date'/>
<parameter name='last_sync' label='Last Sync' column='address_place.last_sync' type='date'/>
<parameter name='objectid' label='Objectid' column='address_place.objectid'/>
<parameter name='updated_at' label='Updated At' column='address_place.updated_at' type='date'/>
<parameter name='designation_value' label='Designation Value' column='address_place.designation_value'/>
</datasourcedataconnection>
</data:datadefinition>
<data:data id="d.group.bal.msql.adressarea" label="Summa adressområden" entity="entity.bal.msql.addresses" datadefinition="dd.group.bal.msql.adressarea" />
<data:datadefinition id="dd.group.bal.msql.adressarea">
<groupdataconnection datadefinition="dd.bal.msql.address_place">
<parameter name="adressarea" label="adressarea" column ="adressarea" />
<parameter name="count" label="Antal" column ="count(adressarea)" type='int'/>
<group column="adressarea"/>
<sort parameter="count"/>
</groupdataconnection>
</data:datadefinition>
<data:data id="d.group.bal.msql.part_of_municipality" label="Summa komundelar" entity="entity.bal.msql.addresses" datadefinition="dd.group.bal.msql.part_of_municipality" />
<data:datadefinition id="dd.group.bal.msql.part_of_municipality">
<groupdataconnection datadefinition="dd.bal.msql.address_place">
<parameter name="part_of_municipality" label="Kommundelar" column ="part_of_municipality" />
<parameter name="count" label="Antal" column ="count(part_of_municipality)" type='int'/>
<group column="part_of_municipality"/>
<sort parameter="count"/>
</groupdataconnection>
</data:datadefinition>
<data:data id="d.group.bal.msql.position_kind" label="Summa belägenhet" entity="entity.bal.msql.addresses" datadefinition="dd.group.bal.msql.position_kind" />
<data:datadefinition id="dd.group.bal.msql.position_kind">
<groupdataconnection datadefinition="dd.bal.msql.address_place">
<parameter name="position_kind" label="Belägenhet" column ="position_kind" />
<parameter name="count" label="Antal" column ="count(position_kind)" type='int' />
<group column="position_kind"/>
<sort parameter="count"/>
</groupdataconnection>
</data:datadefinition>
<data:data id="d.group.bal.msql.location_address_status" label="Summa belägenhetsstatus" entity="entity.bal.msql.addresses" datadefinition="dd.group.bal.msql.location_address_status" />
<data:datadefinition id="dd.group.bal.msql.location_address_status">
<groupdataconnection datadefinition="dd.bal.msql.address_place">
<parameter name="location_address_status" label="Belägenhetsstatus" column ="location_address_status" />
<parameter name="count" label="Antal" column ="count(location_address_status)" type='int' />
<group column="location_address_status"/>
<sort parameter="count"/>
</groupdataconnection>
</data:datadefinition>
<data:data id="d.bal.msql.addresses.dwellings" label="Lägenheter" entity="entity.bal.msql.addresses" datadefinition="dd.bal.msql.addresses.dwellings" />
<data:datadefinition id='dd.bal.msql.addresses.dwellings'>
<datasourcedataconnection key='objectid' table='dbo.address_place' datasource='ds.bal.msql.bal'>
<join type='left' table='dbo.address_area' on='dbo.address_area.objectid = address_place.address_area_reference' />
<join type="left" table="dbo.part_of_municipality" on="dbo.part_of_municipality.objectid = dbo.address_area.part_of_municipality_reference" />
<join type='inner' table='dbo.entrance' on='entrance.address_place_reference = address_place.objectid' />
<join type='inner' table='dbo.dwelling' on='dwelling.entrance_reference = entrance.objectid' />
<parameter name='fastighet' label='Fastighet' column='address_place.real_property_key'>
<dataset>dd.list.bal.msql.properties.name</dataset>
<valuecolumn>value5</valuecolumn>
<labelcolumn>label5</labelcolumn>
<pagesize>0</pagesize>
</parameter>
<parameter name='address' label='Adress' column="(COALESCE(dbo.address_area.assigned_name, '') + ' ') + COALESCE(dbo.address_place.designation_number, '') + COALESCE(dbo.address_place.designation_number_letter, '')" />
<parameter name='post_code' label='Postnummer' column='dbo.address_place.post_code' type='int'/>
<parameter name='post_town' label='Post Town' column='dbo.address_place.post_town'/>
<parameter name='dwelling_number' label='Lägenhet' column='dwelling.dwelling_number'/>
<parameter name='dwelling_category' label='Kategori' column='dwelling.dwelling_category'>
<dataset>dd.bal.msql.dewllingcategory</dataset>
<valuecolumn>value1</valuecolumn>
<labelcolumn>label1</labelcolumn>
<pagesize>0</pagesize>
</parameter>
<parameter name='collection_method' label='Insamling' column='dwelling.collection_method'>
<dataset>dd.bal.collectionmethod</dataset>
<valuecolumn>value1</valuecolumn>
<labelcolumn>label1</labelcolumn>
<pagesize>0</pagesize>
</parameter>
<parameter name='type_of_kitchen' label='Kökstyp' column='dwelling.type_of_kitchen'>
<dataset>dd.bal.typeofkitchen</dataset>
<valuecolumn>value1</valuecolumn>
<labelcolumn>label1</labelcolumn>
<pagesize>0</pagesize>
</parameter>
<parameter name='common_kitchen' label='Gemensamt kök' column='dwelling.common_kitchen'>
<dataset>dd.bal.commonkitchen</dataset>
<valuecolumn>value1</valuecolumn>
<labelcolumn>label1</labelcolumn>
<pagesize>0</pagesize>
</parameter>
<parameter name='useful_floor_space' label='Bostadsyta' column='dwelling.useful_floor_space' type='float'/>
<parameter name='number_of_rooms' label='Antal rum' column='dwelling.number_of_rooms' type='integer'/>
<sort parameter="address"/>
<sort parameter="dwelling_number"/>
</datasourcedataconnection>
</data:datadefinition>
<data:data id="d.group.bal.msql.number_of_rooms" label="Summa antal rum" entity="entity.bal.msql.addresses" datadefinition="dd.group.bal.msql.number_of_rooms" >
<column id="sum">
<format xsd:type="xsd:string">0,000.00</format>
</column>
</data:data>
<data:datadefinition id="dd.group.bal.msql.number_of_rooms">
<groupdataconnection datadefinition="dd.bal.msql.addresses.dwellings">
<parameter name="number_of_rooms" label="Antal rum" column ="number_of_rooms" />
<parameter name="sum" label="Suma yta" column ="sum(useful_floor_space)" type='float' />
<parameter name="count" label="Antal" column ="count(number_of_rooms)" type='int' />
<group column="number_of_rooms"/>
<sort parameter="count"/>
</groupdataconnection>
</data:datadefinition>
<data:data id="d.bal.msql.address_place_geometry" label="Adress geometri" entity="entity.bal.msql.addresses" datadefinition="dd.bal.msql.address_place_geometry" >
<column id="x">
<format xsd:type="xsd:string">0,000.00</format>
</column>
<column id="y">
<format xsd:type="xsd:string">0,000.00</format>
</column>
<column id="address_area" width="130" align="left" />
<column id="designation_number" width="20" align="right" />
<column id="designation_number_letter" width="20" align="left" />
<column id="post_code" width="50" align="left" />
<column id="post_town" width="150" align="left" />
</data:data>
<data:datadefinition id='dd.bal.msql.address_place_geometry'>
<datasourcedataconnection key='objectid' table='dbo.address_place' datasource='ds.bal.msql.bal'>
<join type='left' table='dbo.address_area' on='address_area.objectid = address_place.address_area_reference' />
<parameter name='address_area' label='Address' column='address_area.assigned_name'/>
<parameter name='designation_number' label='N' column='address_place.designation_number'/>
<parameter name='designation_number_letter' label='B' column='address_place.designation_number_letter'/>
<parameter name='post_code' label='Postnummer' column='address_place.post_code' type='int'/>
<parameter name='post_town' label='Postort' column="address_place.post_town"/>
<parameter name='horizontal_coordinate_system' label='Kordinatsystem i plan' column='address_place.horizontal_coordinate_system'>
<dataset>dd.bal.msql.kordinatsystem_sweden</dataset>
<valuecolumn>value1</valuecolumn>
<labelcolumn>label1</labelcolumn>
<pagesize>0</pagesize>
</parameter>
<parameter name='x' label='Östlig koordinat' column='shape.STX'/>
<parameter name='y' label='Nordlig koordinat' column='shape.STY'/>
<sort parameter="address_area"/>
<sort parameter="designation_number"/>
<sort parameter="designation_number_letter"/>
</datasourcedataconnection>
</data:datadefinition>
<data:datadefinition id="dd.bal.msql.kordinatsystem_sweden">
<inlinedataconnection>
<parameter type="string" name="value1" label="Key" />
<parameter type="string" name="label1" label="Label" />
<row>
<cell>9ec23aad-8fd1-b149-0a90-c9f6355c3b56</cell>
<cell>SWEREF 99 TM</cell>
</row>
<row>
<cell>9d2d5841-a337-abc9-0a90-c9f6355c3b56</cell>
<cell>SWEREF 99 16 30 </cell>
</row>
</inlinedataconnection>
</data:datadefinition>
<data:datadefinition id='dd.list.bal.msql.common_name'>
<datasourcedataconnection table='dbo.address_place' datasource='ds.bal.msql.bal' prefix="DISTINCT">
<parameter name='value1' column='common_name' type='string'/>
<parameter name='label1' column='common_name' type='string'/>
</datasourcedataconnection>
</data:datadefinition>
<data:datadefinition id='dd.bal.msql.address_place.locationaddressstatus'>
<datasourcedataconnection table='dbo.address_place' datasource='ds.bal.msql.bal' prefix="DISTINCT">
<parameter name='label1' column='location_address_status' type='string'/>
<parameter name='value1' column='location_address_status' type='string'/>
</datasourcedataconnection>
</data:datadefinition>
<data:datadefinition id='dd.bal.msql.address_place.positionkind'>
<datasourcedataconnection table='dbo.address_place' datasource='ds.bal.msql.bal' prefix="DISTINCT">
<parameter name='label1' column='position_kind' type='string'/>
<parameter name='value1' column='position_kind' type='string'/>
</datasourcedataconnection>
</data:datadefinition>
<data:datadefinition id='dd.bal.msql.adressplatstyp'>
<datasourcedataconnection table='dbo.address_place' datasource='ds.bal.msql.bal' prefix="DISTINCT">
<parameter name='label1' column='address_type' type='string'/>
<parameter name='value1' column='address_type' type='string'/>
</datasourcedataconnection>
</data:datadefinition>
<data:datadefinition id='dd.bal.msql.objectstatus'>
<datasourcedataconnection table='dbo.address_place' datasource='ds.bal.msql.bal' prefix="DISTINCT">
<parameter name='label1' column='object_status' type='string'/>
<parameter name='value1' column='object_status' type='string'/>
</datasourcedataconnection>
</data:datadefinition>
<data:datadefinition id='dd.bal.msql.dewllingcategory'>
<datasourcedataconnection table='dbo.dwelling' datasource='ds.bal.msql.bal' prefix="DISTINCT">
<parameter name='label1' column='dwelling_category' type='string'/>
<parameter name='value1' column='dwelling_category' type='string'/>
</datasourcedataconnection>
</data:datadefinition>
<search:attribute id="sa.bal.adresses">
<entity>entity.bal.msql.addresses</entity>
<displayName>Adresser</displayName>
<description>Adresser</description>
<dataSource>ds.bal.msql.bal</dataSource>
<table>dbo.address_place</table>
<key>objectId</key>
<parameter id ="properties" label="Fastigheter">
<dataset>dd.list.bal.msql.properties.name</dataset>
<parameter id ="kommun">
<promptText>Kommun</promptText>
<controltype>listbox</controltype>
<valuecolumn>value1</valuecolumn>
<labelcolumn>label1</labelcolumn>
<column>municipality</column>
<dataType>string</dataType>
</parameter>
<parameter id ="property">
<promptText>Ligger på fastighet</promptText>
<controltype>listbox</controltype>
<valuecolumn>value5</valuecolumn>
<labelcolumn>label5</labelcolumn>
<column>real_property_key</column>
<dataType>string</dataType>
</parameter>
</parameter>
<parameter id ="adress" label="Gatuadress">
<dataset>dd.list.bal.msql.address_place</dataset>
<parameter id ="posttown">
<promptText>Postort</promptText>
<column>post_town</column>
<valuecolumn>posttown</valuecolumn>
<labelcolumn>posttown</labelcolumn>
<dataType>string</dataType>
</parameter>
<parameter id ="area">
<promptText>Gata eller gårdsadress</promptText>
<controltype>listbox</controltype>
<from table='dbo.address_area' />
<where clause = 'address_area.objectid = address_place.address_area_reference' />
<where>
<clause>
<![CDATA[address_area.assigned_name = '${area}' ]]>
</clause>
</where>
<valuecolumn>area</valuecolumn>
<labelcolumn>area</labelcolumn>
<dataType>string</dataType>
</parameter>
<parameter id ="number">
<promptText>Nummer</promptText>
<controltype>listbox</controltype>
<where>
<clause>
<![CDATA[COALESCE(designation_number,'') + COALESCE(designation_number_letter,'') = '${number}' ]]>
</clause>
</where>
<valuecolumn>number</valuecolumn>
<labelcolumn>number</labelcolumn>
<dataType>string</dataType>
</parameter>
</parameter>
<parameter id ="area" label="Andra adressområden">
<parameter id ="common_name">
<promptText>Vanligt namn</promptText>
<controltype>listbox</controltype>
<dataset>dd.list.bal.msql.common_name</dataset>
<valuecolumn>value1</valuecolumn>
<labelcolumn>label1</labelcolumn>
<column>common_name</column>
<dataType>string</dataType>
</parameter>
<parameter id ="farm_address_area">
<promptText>GÃ¥rdsadress</promptText>
<controltype>listbox</controltype>
<dataset>dd.list.bal.msql.farm_address_area</dataset>
<valuecolumn>value1</valuecolumn>
<labelcolumn>label1</labelcolumn>
<column>farm_address_area_reference</column>
<dataType>string</dataType>
</parameter>
</parameter>
<parameter id ="ovrigt" label="Andra adressuppgifter">
<parameter id ="locationaddressstatus">
<promptText>Belägenhetsstatus</promptText>
<controltype>listbox</controltype>
<dataset>dd.bal.msql.address_place.locationaddressstatus</dataset>
<where>
<clause>
<![CDATA[location_address_status = '${locationaddressstatus}' ]]>
</clause>
</where>
<valuecolumn>value1</valuecolumn>
<labelcolumn>label1</labelcolumn>
<dataType>string</dataType>
<allowblank>true</allowblank>
<defaultValue></defaultValue>
</parameter>
<parameter id ="positionkind">
<promptText>Adresspunktläge</promptText>
<controltype>listbox</controltype>
<dataset>dd.bal.msql.address_place.positionkind</dataset>
<where>
<clause>
<![CDATA[position_kind = '${positionkind}' ]]>
</clause>
</where>
<valuecolumn>value1</valuecolumn>
<labelcolumn>label1</labelcolumn>
<dataType>string</dataType>
</parameter>
<parameter id ="adresstyp">
<promptText>Adresstyp</promptText>
<controltype>listbox</controltype>
<dataset>dd.bal.msql.adressplatstyp</dataset>
<where>
<clause>
<![CDATA[address_type = '${adresstyp}' ]]>
</clause>
</where>
<valuecolumn>value1</valuecolumn>
<labelcolumn>label1</labelcolumn>
<dataType>string</dataType>
</parameter>
<parameter id ="objectstatus">
<promptText>Objektstatus</promptText>
<controltype>listbox</controltype>
<dataset>dd.bal.msql.objectstatus</dataset>
<where>
<clause>
<![CDATA[object_status = '${objectstatus}' ]]>
</clause>
</where>
<valuecolumn>value1</valuecolumn>
<labelcolumn>label1</labelcolumn>
<dataType>string</dataType>
</parameter>
</parameter>
<parameter id ="dewelling" label="Lägenhetsuppgifter">
<parameter id ="dewllingcategory">
<promptText>Lägenhetstyp</promptText>
<controltype>listbox</controltype>
<from table='dbo.entrance' />
<where clause = 'entrance.address_place_reference = address_place.objectid' />
<from table='dbo.dwelling' />
<where clause = 'dwelling.entrance_reference = entrance.objectid' />
<dataset>dd.bal.msql.dewllingcategory</dataset>
<where>
<clause>
<![CDATA[dwelling_category = '${dewllingcategory}' ]]>
</clause>
</where>
<valuecolumn>value1</valuecolumn>
<labelcolumn>label1</labelcolumn>
<dataType>string</dataType>
</parameter>
<parameter id ="collectionmethod">
<promptText>Insamlingsmetod</promptText>
<controltype>listbox</controltype>
<from table='bal.entrance' />
<where clause = 'entrance.address_place_reference = address_place.objectid' />
<from table='bal.dwelling' />
<where clause = 'dwelling.entrance_reference = entrance.objectid' />
<dataset>dd.bal.collectionmethod</dataset>
<where>
<clause>
<![CDATA[collection_method = ${collectionmethod} ]]>
</clause>
</where>
<valuecolumn>value1</valuecolumn>
<labelcolumn>label1</labelcolumn>
<dataType>integer</dataType>
</parameter>
<parameter id ="type_of_kitchen">
<promptText>Typ av kök</promptText>
<controltype>listbox</controltype>
<from table='bal.entrance' />
<where clause = 'entrance.address_place_reference = address_place.objectid' />
<from table='bal.dwelling' />
<where clause = 'dwelling.entrance_reference = entrance.objectid' />
<dataset>dd.bal.typeofkitchen</dataset>
<where>
<clause>
<![CDATA[type_of_kitchen = ${type_of_kitchen} ]]>
</clause>
</where>
<valuecolumn>value1</valuecolumn>
<labelcolumn>label1</labelcolumn>
<dataType>integer</dataType>
</parameter>
<parameter id ="common_kitchen">
<promptText>Gemensamt kök</promptText>
<controltype>listbox</controltype>
<from table='bal.entrance' />
<where clause = 'entrance.address_place_reference = address_place.objectid' />
<from table='bal.dwelling' />
<where clause = 'dwelling.entrance_reference = entrance.objectid' />
<dataset>dd.bal.commonkitchen</dataset>
<where>
<clause>
<![CDATA[common_kitchen = ${common_kitchen} ]]>
</clause>
</where>
<valuecolumn>value1</valuecolumn>
<labelcolumn>label1</labelcolumn>
<dataType>integer</dataType>
</parameter>
<parameter id ="number_of_rooms">
<promptText>Antal rum</promptText>
<controltype>listbox</controltype>
<from table='bal.entrance' />
<where clause = 'entrance.address_place_reference = address_place.objectid' />
<from table='bal.dwelling' />
<where clause = 'dwelling.entrance_reference = entrance.objectid' />
<dataset>dd.bal.numberofrooms</dataset>
<where>
<clause>
<![CDATA[number_of_rooms ${number_of_rooms} ]]>
</clause>
</where>
<valuecolumn>value1</valuecolumn>
<labelcolumn>label1</labelcolumn>
<dataType>integer</dataType>
</parameter>
</parameter>
<parameter id ="bostadsyta" label="Bostadsyta">
<parameter id ="max_useful_floor_space">
<promptText>Bostadsyta större/lika med kvm</promptText>
<controltype>textbox</controltype>
<from table='bal.entrance' />
<where clause = 'entrance.address_place_reference = address_place.objectid' />
<from table='bal.dwelling' />
<where clause = 'dwelling.entrance_reference = entrance.objectid' />
<where>
<clause>
<![CDATA[useful_floor_space >= ${max_useful_floor_space} ]]>
</clause>
</where>
<dataType>float</dataType>
</parameter>
<parameter id ="min_useful_floor_space">
<promptText>Bostadsyta mindre/lika med kvm</promptText>
<controltype>textbox</controltype>
<from table='bal.entrance' />
<where clause = 'entrance.address_place_reference = address_place.objectid' />
<from table='bal.dwelling' />
<where clause = 'dwelling.entrance_reference = entrance.objectid' />
<where>
<clause>
<![CDATA[useful_floor_space <= ${min_useful_floor_space} ]]>
</clause>
</where>
<dataType>float</dataType>
</parameter>
</parameter>
<parameter id ="id">
<promptText>ID</promptText>
<controltype>textbox</controltype>
<valuecolumn>value1</valuecolumn>
<labelcolumn>label1</labelcolumn>
<column>id</column>
<dataType>integer</dataType>
</parameter>
<cache disable="true" />
</search:attribute>
</config>
|