Notification not queriable without operator cookie

[ignazio-bovo]

Problem

Currently any account is not able to access his own notifications because notification are hidden entities.
Specifically the notification, notification in app and in mail delivery are inside the admin schema and not exposed through any view

orion/db/migrations/2000000000000-Views.js

Line 74 in 9395557

notification_email_delivery: ['FALSE'],

Temporary solution

make them non-hidden on atlas-dev so the testing can progress.
Because at the moment notificatification are inside the admin schema and not expos

Permanent solution

Create a bespoke resolver allowing atlas to query notifications via the in app delivery table

[ignazio-bovo]

I have discovered that setting up an appropriate resolver that satisfies Atlas requirement:

• open crud where clause with logical conditionals, eg:

where: {
  account: { joystreamAccount_eq: accountId },
  OR: [
    { createdAt_gt: "2023-09-22 12:00:00", recipient: { isTypeOf_eq: 'ChannelRecipient', channelId_eq: "channel1" },
    { createdAt_gt: "2023-09-22 13:00:00", recipient: { isTypeOf_eq: 'ChannelRecipient', channelId_eq: "channel2" }
  ]
}

• supports pagination

Is a complex task, also I have established that account information leakage due to joins on account private entity starting from notification is not possible if notification is a public entity

Which means that we can safely roll out publicly accessible notifications in v1 and then make it private and queriable via an appropriate resolver in v2