Skip to main content
psaxena1-Visitor
1-Visitor
August 1, 2016
Solved

How to remove the duplicate entries (alternate entries) from a grid which displays an infotable.

  • August 1, 2016
  • 11 replies
  • 5441 views

in the alert history table each alert is displayed twice as an alternate entry.

Best answer by ibanham

Use QueryStreamEntries with data rather than Get....

11 replies

CarlesColl1-Visitor
1-Visitor
August 1, 2016

That's strange, did you tried to query for Alerts directly with Test button on the composer to see if maybe you have the Data doubled and it's not a Grid bug.

ibanham1-Visitor
1-Visitor
August 2, 2016

The Alert History table is basically a Stream that records Alerts and what happened to them. It's normal to have multiple entries for a single alert.

You get an entry when the Alert is triggered, and another when it is reset. You will also get an entry when the Alert is acknowledged.

psaxena1-VisitorAuthor
1-Visitor
August 2, 2016

I am displaying the alert history table in a grid in a mashup, so can I eliminate dulicate entries in a grid? Because the difference is in the decimal value of seconds in the timestamp.

ibanham1-Visitor
1-Visitor
August 2, 2016

Look at the Alert History screen under the Monitoring menu - the eventName column should give you something to filter by.

A new alert has an event name of "Alert", when the alert re-sets the event name is "AlertReset".

Terms & ConditionsAccessibility statement