Marking Everyone in the Database Gives Incorrect Counts

RootsMagic
,
1

RM 10.0.0.0, 64 bit, Windows 10.        I have freshly run all the database tools.

I have been playing with group creation. For groups with complex rules, the easiest way to enter the rules seems to be to mark everybody in the database and then to unmark everybody not in the group.

  • My database contains 41164 people.
  • When I create a group where the only rule is Select Everyone In File, the group says it contains 62024 people.
  • When I create a group where the only rule is the criterion Birth Exists Is True OR Birth Exists Is False, the group says it contains 41164 people.
  • The person in my database with the highest Record Number has a Record Number of 62024.

I think the sleuthing is done. The biggest reason this needs to be fixed is that if my first rule is Select Everyone In File and if I add subsequent rules to unmark people from a group being created, the number of people unmarked is subtracted from 62024 rather than being subtracted from 41164. As a result, even after unmarking some people, the number of people in the group is greater than the number of people in my database.

1 Like
2

Confirming issue has been reported to development.

1 Like
3

nice catch – sounds like counting people not distinct counts or similar issue

Kevin

4

It’s doing the equivalent of SELECT MAX(PersonID) instead of SELECT COUNT(PersonID).

1 Like
5

why would it do that for that scenario?

6

I’m sure Tom is right, and it’s surely just a bug.

7

It shouldn’t. It’s a programming error.

1 Like