Duplicate pool reports #73

New issue

Closed

opened 2026-07-09 18:13:29 +00:00 by eliribble · 3 comments

eliribble commented

2026-07-09 18:13:29 +00:00

Owner

Good morning!

So I haven't had this happen before but there are two pool reports from the same person, one is from yesterday and the other is from a month ago. They have the same first name but the phone numbers are different. The reports are also doubled, one of them even shows different ID numbers. I'm going to attach some screenshots also.

ID numbers for the two separate pools:

#4LEMGF4KFEAD
#8P8UJ6KMAD5V

-Alysia Davis
Delta MVCD

Good morning! So I haven't had this happen before but there are two pool reports from the same person, one is from yesterday and the other is from a month ago. They have the same first name but the phone numbers are different. The reports are also doubled, one of them even shows different ID numbers. I'm going to attach some screenshots also. ID numbers for the two separate pools: #4LEMGF4KFEAD #8P8UJ6KMAD5V -Alysia Davis Delta MVCD

eliribble added the

customer

label

2026-07-09 18:13:29 +00:00

eliribble self-assigned this

2026-07-09 18:13:29 +00:00

eliribble commented

2026-07-09 18:14:17 +00:00

Author

Owner

Email had screenshots

Screenshot 2026-07-09 093337.png

18 KiB

Screenshot 2026-07-09 093344.png

19 KiB

eliribble commented

2026-07-09 18:18:12 +00:00

Author

Owner

nidus-sync=# select public_id, created, address_raw, address_id, reporter_contact_id from publicreport.report where public_id in ('4LEMGF4KFEAD', '8P8UJ6KMAD5V');
  public_id   |          created          |                                 address_raw                                 | address_id | reporter_contact_id
--------------+---------------------------+-----------------------------------------------------------------------------+------------+---------------------
 4LEMGF4KFEAD | 2026-07-09 03:15:12.28501 | 1982 Autumn Drive, Dinuba, California 93618, United States of America       |       2926 |                 489
 8P8UJ6KMAD5V | 2026-06-01 00:32:15.86732 | 1437 South Clark Court, Visalia, California 93292, United States of America |       2329 |                  55

``` nidus-sync=# select public_id, created, address_raw, address_id, reporter_contact_id from publicreport.report where public_id in ('4LEMGF4KFEAD', '8P8UJ6KMAD5V'); public_id | created | address_raw | address_id | reporter_contact_id --------------+---------------------------+-----------------------------------------------------------------------------+------------+--------------------- 4LEMGF4KFEAD | 2026-07-09 03:15:12.28501 | 1982 Autumn Drive, Dinuba, California 93618, United States of America | 2926 | 489 8P8UJ6KMAD5V | 2026-06-01 00:32:15.86732 | 1437 South Clark Court, Visalia, California 93292, United States of America | 2329 | 55 ```

eliribble commented

2026-07-09 19:14:26 +00:00

Author

Owner

Resolved over email. The screenshots were accidentally included, and not germane. Essentially this is confirmed to be two separate reporters, which is fine.

eliribble closed this issue

2026-07-09 19:14:26 +00:00