Deleted alert records are shown in the Unified Worklist web part

When users delete alert records, the records continue to display in the unified worklist on the users Role Center page. When records in EventInbox are deleted, they are not always physically removed from the database.  If the ''SendEmail'' field is selected, then the records are soft deleted.  In such a case the ''Deleted'' field is flagged and the record is update.  When the ”SendEmail” field is false, the records would instead be removed from the database. This is an after effect of the Data Set used by the worklist using the following query when building its temporary table.


This is from line 64 of \Data Sets\UnifiedWorkListTmp\Data Sources\TmpUnifiedWorkList\Methods\init.


while select alert where alert.UserId == curuserid()


This issue can  easily be worked around by implementing the code as shown below. This code this prevents the worklist from displaying alerts that users have deleted.


while select alert where alert.UserId == curuserid() && alert.Deleted == false


Ensure to restart the AOS so that any cached records can be cleared. Also recommended but not required is an IIS reset to a obtain a new IIS application pool and .NET BC.


Comments (2)

  1. Andre Boekestijn says:

    Thanks for this information.

  2. Andre Boekestijn says:

    Dear Brian, for your information:
    After adding the code “&& alert.Deleted == false” in a Test environment and restarting the AOS (twice) I still saw the cached records in the Work list of the Role Center. It took an iisreset to get ride of them.
    After putting the code live in our Production environment (Without restarting the AOS off course) a single iisreset did hide the records…
    It seems the iisreset is necessary and not the AOS restart.

Skip to main content