"Station SSIDs" shows other stations with similar callsigns

[arodland]

Basically, it's doing a prefix match, instead of a complete (SSID-insensitive) callsign match.

If I tap on KC2G-9, I will see KC2G and KC2G-15 in "Station SSIDs", which is expected, but I will also see KC2GOW and KC2GYU-9, which is not.

[ge0rg]

Yes, this is a long-standing issue based on the fact that I do not have a dedicated callsign field but only one for callsign + SSID, and I end up doing a LIKE "$callsign%" query to obtain all SSIDs. This is even worse for EchoLink stations because you'll get a very long list of EL-* :(

I really need to add code to properly normalize that data when receiving it, so that I don't need to rely on a database query hack :)

[arodland]

You could still use something like `= '$callsign' OR LIKE '$callsign-%'` I think. Wouldn't fix the "EL-" case but it would help the ordinary one.

…

On Thu, Sep 9, 2021, 9:36 AM Georg Lukas ***@***.***> wrote: Yes, this is a long-standing issue based on the fact that I do not have a dedicated callsign field but only one for callsign + SSID, and I end up doing a LIKE "$callsign%" query to obtain all SSIDs. This is even worse for EchoLink stations because you'll get a very long list of EL-* :( I really need to add code to properly normalize that data when receiving it, so that I don't need to rely on a database query hack :) — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#310 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAABR3BS6YDY5MOKPRIXS7TUBCZ47ANCNFSM5DWETDRQ> . Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.

[ge0rg]

It's now part of the 1.6.2 release, thanks for the suggestion :)