search

THE-BWC / OpServ-Issues

Repository for all OpServ issues
MIT License
0 stars 0 forks source link

[BUG] - Custom roster report query returning duplicate entries #32

Open tkhu1 opened 3 months ago

tkhu1 commented 3 months ago

Description

When running the following report, the DB query is returning duplicate table rows. Maybe needs a SELECT Distinct or equivalent clause by default?

image

image

Browsers

Chrome

OS

Windows

PatrickPedersen commented 3 months ago

That would be because of the taskforces. Since certain members are part of multiple taskforces, you end up with what seems like duplicate lines. But if you select Battlegroup, the taskforces they are a part of show up.

An example would be Aniron: image With Battlegroup on, it shows all three taskforces he is a part of.

The only real solution I could provide would be yet another checkbox for "Unique Selection" only. You just need to remember to turn it off, if you want to see all taskforces a member is part of.

tkhu1 commented 3 months ago

Ok so the workaround is to turn off battlegroup. Could we have battlegroup default to false when loading the report, perhaps?