Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 3 Next »

Se BAL användarhandledning för allmän information

Installation

Skapa databaser

Först skapas BAL databas med stöd av scriptet nedan. Ändra  detta så att det passar för lokala förhållanden.

BAL databas 
Select * from a.a

Lägg in Weave konfigurationer

Grundläggande konfiguration för dataslag BAL och för applikationen BAL

BAL konfiguration 
<?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>

  File Modified
No files shared here yet.


  • No labels