| Page Properties |
|---|
|
| Theme | NHS Choices |
|---|
| Type | URL Links |
|---|
| Available from |
|
|---|
|
...
- Open iShare Studio
- Expand the Workflow node in the Explorer tree
- Expand the Jobs node and find the NHS Choices Job.
- Right click on the NHS Choices Job entry and select New Task.
- Select Stored Procedure Task
- Give the Task a Name, select the DataShare database and the at_wkf_executecmd function.
- In the Edit parameter box enter the following SQL.
| Paste code macro |
|---|
UPDATE nhschoices_all SET link = replace(link, 'http:', 'https:') where lower(link) not like 'https%' and lower(link) like 'http% |
...
If you also wish to change the Image link for the NHS Choices logo in My House to be HTTPS then this is done from your My House NHS Choices Virtual Layer Configuration in the Row Settings e.g.
| Paste code macro |
|---|
<img src="https://www.nhs.uk/img/header/choices-logo.gif" alt="" /><p>Data supplied by <a href="https://www.nhs.uk" target="_blank">NHS Choices</a></p> |