...
| Page Properties | ||||||
|---|---|---|---|---|---|---|
| ||||||
|
Overview
In the Addressbase AddressBase Premium data some of the Wards and District names contain ampersands (&) and this can result in information not displaying in the My Property tab. For example no councillors showing for the ward below.
...
Step-by-step guide
Locate the table(s) your layer(s) use that contain ampersands
Locate the workflow job Workflow Job in Studio that populates these tables
Add an SQL task a Stored Procedure Task into the workflow jobWorkflow Job. Place it in the list after the tasks Tasks that populate the tables.
...
...
Then select the Workflow radio button as this will limit the list of available Functions and then select the at_wkf_executecmd entry from the list (from v6.0.0 this is called wkf_executecmd under the -Workflow- Function filter)
Enter the following information into the Edit parameter box changing the table and field names as required
| Code Block |
|---|
UPDATE
boundaryline_wards
SET
name = REPLACE(name,'&','and')
WHERE
name like '%&%' |
...
When run this task will replace any instances of '&' with 'and' in the name field of the boundaryline_wards table.
...