New primary view

I added the pieces for the new primary view today. These consist of 2 new automations (ViewBaseIn and ViewBaseNotIn). These set or unset the ViewBaseIn flag based on the same rules that governed the existing Primary view, excluding the ViewFlag rules. ViewBaseIn:

update alerts.status

set ViewBaseIn = 1 where

ViewBaseIn  1

and

Type  0 or Smart24Status >= 20 )

and

Severity <> 1

and

TestFlag <> 1

and

IncidentType

ViewBaseNotIn:

update alerts.status

set ViewBaseIn = 0

where

ViewBaseIn <> 0 and

(Type > 1

or

(Severity = 0 and Smart24Status  1

or

ServerLifeCycle not in (0, 2));

In addition, there are a couple of new Menu items:

• Override to include in Primary View
• Override to exclude from Primary View
• Cancel Overrides
• Move to Pending View (new)
• Move out of Pending View (new)

The override menu items are in a new submenu called “Override Views”.
The move to pending now works from any view, not only pending. Move out of pending just unsets the pending flag and does not necessarily mean the item will show up in Primary.
The “Override to include in Primary” and “Override to exclude from Primary” items just set the corresponging ViewOverrideIn and ViewOverrideEx flags. Cancel overrides, conversely, just clears these flags.
Finally, there is a new primary view definition, that works off the view attributes. And naturally there is very simple new pending view definition.