Problem after update - new field flashed

[ilbassa]

The notification aren't shown, seems that is missing 'flashed' in the rules()
[['id', 'key_id', 'created_at'], 'safe'],
changed in
[['id', 'key_id', 'created_at', 'flashed'], 'safe'],
now it shows all the notification

[machour]

Could you give a complete reproduce case ? this works for me, flashed gets set to 1 without being in rules() (so does seen)

[ilbassa]

Hi, we have tested deeper the code.
The problem isn't in the model, but in the poll action.
ORACLE doesn't manage boolean value in the db so we must use INTEGER dataType with 0/1 values.

The notification are displayed with this modifications:

        $seen = $seen ? 1 : 0;
        /** @var Notification $class */
        $class = $this->notificationClass;
        $models = $class::find()
            ->where(['user_id' => $this->user_id])
            ->andWhere(['or', '"seen"='.$seen, '"flashed"=0'])
            ->orderBy('created_at DESC')
            ->all();

[ilbassa]

Hi, finally we have figured it out.

The double quotes are required from ORACLE but it is better that the management of this is demanded to connection to the db, so the first correction we made is wrap the condition around []
``
$seen = $seen ? 1 : 0;

   ->andWhere(['or',` ['seen'=>$seen] ,['flashed'=>0]])

``

I have override the notify() function because I needed to return the instance of the notfication, so I have added the 'flashed'=>0 default value when saving a new notification.
And now it works.