ColoredCow / ColoredCow/campaigns

No way to see the valid or invalid subscribers in a list

Open
#40 0 comments 0 reactions 0 assignees View on GitHub
good first issue
Dominant language
PHP
Stars
6
Forks
0
PR merge metrics
No merged PRs in 30d

Description

The numbers can be clickable that takes the user to the list of valid/invalid subscribers.
![image](https://user-images.githubusercontent.com/11808845/126966151-f3a8d680-421a-452a-91d5-5b9e74c93a6e.png)

I used the following sql query to get the list of invalid subscribers for a list

```sql
SELECT b.email
FROM list_subscriber a
LEFT JOIN subscribers b ON a.subscriber_id = b.id
WHERE a.list_id =
AND b.has_verified_email = 0;
```

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by locating the list view that displays the valid and invalid subscriber counts, then review the provided SQL query and the linked screenshot. The work is done when each count links to the corresponding subscriber list and the results distinguish valid from invalid subscribers for the selected list.

Written by the indexing model from the issue text.

Assessment

Tech stack
laravel, php, sql
Domain
databases, frontend
Issue type
Feature
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.