Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Minor
-
Resolution: Won't Fix
-
Affects Version/s: 1.3.0
-
Fix Version/s: 1.3.0
-
Component/s: Admax Deployment Service
-
Labels:None
-
Environment:
Optus dev environment AND Optus SIT environment
Description
We need to populate the googleLocationTargetMap table if useSEDefinedTargets=1 and status='active'.
Why do we have a "Queensland" and a "Queensland - Outback"? Same for Western Australia and Northern Territory.
Do we need "Other Territories?"
select businessLocations.id, description, status, isSellable, useSEDefinedTargets, usePointRadiusTargets from businessLocations left join pointRadius on locationID=businessLocations.id where locationID is null and status='active';
-----------------------------------------------------------------------------------------+
| id | description | status | isSellable | useSEDefinedTargets | usePointRadiusTargets |
-----------------------------------------------------------------------------------------+
| 1 | Australia | active | 1 | 1 | 0 |
| 2 | New South Wales | active | 1 | 1 | 0 |
| 3 | Victoria | active | 1 | 1 | 0 |
| 4 | Queensland | active | 1 | 1 | 0 |
| 5 | South Australia | active | 1 | 1 | 0 |
| 6 | Western Australia | active | 1 | 1 | 0 |
| 7 | Tasmania | active | 1 | 1 | 0 |
| 8 | Northern Territory | active | 1 | 1 | 0 |
| 9 | Australian Capital Territory | active | 1 | 1 | 0 |
| 107 | Queensland - Outback | active | 0 | 0 | 1 |
| 126 | Western Australia - Outback | active | 0 | 0 | 1 |
| 133 | Northern Territory - Outback | active | 0 | 0 | 1 |
| 135 | Other Territories | active | 0 | 0 | 1 |
-----------------------------------------------------------------------------------------+
13 rows in set (0.17 sec)
Update: the parent locations of the four in question are deprecated.
select a.childBusinessLocationID 'acid', ba.description, ba.status, a.parentBusinessLocationID 'apid', bb.description, bb.status, b.parentBusinessLocationID 'bpid', bc.description, bc.status, c.parentBusinessLocationID 'cpid' from businessLocationMap a join businessLocationMap b on (a.parentBusinessLocationID = b.childBusinessLocationID) join businessLocationMap c on (b.parentBusinessLocationID=c.childBusinessLocationID) join businessLocations ba on a.childBusinessLocationID=ba.id join businessLocations bb on b.childBusinessLocationID=bb.id join businessLocations bc on c.childBusinessLocationID=bc.id where a.childBusinessLocationID in (107,126,133,135);
-----------------------------------------------------------------------------------------------------------+
| acid | description | status | apid | description | status | bpid | description | status | cpid |
-----------------------------------------------------------------------------------------------------------+
| 107 | Queensland - Outback | active | 22 | Rest of Qld | deprecated | 4 | Queensland | active | 1 |
| 126 | Western Australia - Outback | active | 26 | Rest of WA | deprecated | 6 | Western Australia | active | 1 |
| 133 | Northern Territory - Outback | active | 30 | Rest of NT | deprecated | 8 | Northern Territory | active | 1 |
| 135 | Other Territories | active | 32 | Other Territories | deprecated | 10 | Other Territories | deprecated | 1 |
-----------------------------------------------------------------------------------------------------------+
