[jira-card-creator] different platforms in sutton are combined into one record

[weizhenwu]

Summary

See below logs Happed in Sutton

{
                "platform_tag": "jellyfish-bartlett",
                "status": "in-flight",
                "pm": "",
                "fe": "",
                "swe": "andch",
                "qa": "weichenwu",
                "bug_link": "https://bugs.launchpad.net/sutton/+bugs?field.tag=jellyfish-bartlett",
                "start_date": [
                    "2023-08-25",
                    "2023-09-15",
                    "2023-09-29"
                ],
                "prts": false,
                "platform_name": [
                    "P3 Tower Ref2.0",
                    "P3 Ultra Ref2.0",
                    "Stealth",
                    "Falcon",
                    "Hornet",
                    "Tomcat"
                ],
                "product_name": [
                    "P3 Tower Ref2.0",
                    "P3 Ultra Ref2.0",
                    "P620 Ref7.0",
                    "P5",
                    "P7",
                    "PX"
                ],
                "lp_tag": ""
            },

Root cause

previously in sutton project book, there was a official tag which we used as primary_key but this colume is hidden now, and haven't been updated since Following the code logic, it will combine all records with the same official tag into one and all of them are blank hence they are combined

Fix

Use platform_tag as primary_key instead

[stanley31huang]

@weizhenwu @baconYao and I had a discussion with Gabriel and Eugene half years ago, they request to have a separate Jira cards for the platform share the same platform tag. Likes X13 Gen4 and X13 Yoga Gen4, so I would suggest we modify the mapping in pc_paltform_tracker. https://github.com/canonical/oem-qa-tools/blob/main/Tools/PC/jira-card-creator/pc_platform_tracker.py#L276

5 | 2022 | ThinkPad | Missouri | X13 G4 | Released | 1 | 1 | 1 | 0 | 1 | 0 | Laptop | Intel | 13th Gen Intel(R) CoreT i7-1360P | VGA compatible controller [0300]: Intel Corporation Device [8086:a7a0] (rev 04) (prog-if 00 [VGA controller]) | 22.04 | 2023-02-10 | 2023-02-10 | N/A | 2023.3 | 6.1 | missouri |   |   |   | https://bugs.launchpad.net/sutton/+bugs?field.tag=missouri | https://bugs.launchpad.net/certify-planning/+bug/2009368 | https://ubuntu.com/certified/202306-31717 |   |   | 2023-02-13 | 2023-02-13 | 2023-07-07 | 2023-06-30 | 2023-08-18 | 2023-06-30 | N3O | jellyfish-aitland
-- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | --
6 | 2022 | ThinkPad | Rhone | X13 Yoga G4 | Released | 1 | 1 | 1 | 0 | 1 | 0 | Laptop | Intel | 13th Gen Intel(R) Core(TM) i7-1365U | VGA compatible controller [0300]: Intel Corporation Device [8086:a7a1] (rev 04) (prog-if 00 [VGA controller]) | 22.04 | 2023-01-19 | 2023-02-06 | 2023-05-30 | 2023.3 | 6.1 | rhone |   |   |   | https://bugs.launchpad.net/sutton/+bugs?field.tag=rhone | https://bugs.launchpad.net/certify-planning/+bug/2009409 | https://ubuntu.com/certified/202305-31640 |   |   | 2023-02-06 | 2023-02-06 | 2023-06-09 | 2023-06-02 | 2023-06-30 | 2023-06-02 | N3O | jellyfish-aitland

[baconYao]

Rhone (X13 Yoga G4 jellyfish-aitland)

• https://warthogs.atlassian.net/browse/CQT-1742

Missouri (X13 G4 jellyfish-aitland)

• https://warthogs.atlassian.net/browse/CQT-1918