GraphQL distinct query help

Questions and Answers
1
System Information
  • Strapi Version: 3.4.6
  • Operating System:
  • Database: MariaDB 10.5
  • Node Version: v14.15.4
  • NPM Version:
  • Yarn Version:

Hello! I’m having difficulties figuring out how to solve the task of finding new unique entries within a single table.

A simplified example may be explained this way:

  • there is an activity / check-in table, containing 2 fields - date and email
  • I need to compare filtered activities for 2 dates (let’s say today and 1 week before) with a goal to list and get a number of new unique emails that were not logged in the activity table 1 week ago (on that specific date)

For each date there are about 700 emails.

The question is if this is doable with GraphQL / on strapi side. Alternatives - external middleware or SQL query on DB side are already under consideration.

And one additional question, if allowed - can I somehow just do a custom SQL query initiated by GraphQL call?

Thanks in advance!