Skip to Content
Former Member
Oct 10, 2017 at 10:22 PM

How to extract all alert results into a table



I have built an alert that returns multiple records in the result. I wanted to export/extract the result into some sort of table format so the users can look at them at a holistic view instead of clicking through them on the web browser. The problem I'm having is that when I select all records from the alert and click "Go to Excel", all it does is building a data view and using all Prod and Loc that appeared in the alert as filter in the data view. The result is that it'll return all Prod and Loc combination instead of just the combinations that are in the alert. For example, I've selected all alert records and click "Go to excel" and the data view is pulling using the filters of 6 prod ID and 2 Loc, which resulted 12 prod/loc combination whereas in the alert itself there's 6 records (first 3 prod from Loc 2360 and last 3 prod from Loc 2355).

So the question here is what's a practical way to export/extract the alert results from WebUI?