Hi so some back story I created a OBDC User Experience Monitor that grabs data out of a mysql database. One thing the monitor populates is the message field which I found in the database as ErrorMessage in the table APM_CurrentCOmponenetStatus. Next I created a custom page and created a Custom Object Resource that shows all the items. Next what I would like to do is create a resource to filter out items unless to have a specific message. In this case the message is: IN PROGRESS.
I created a resource called Top 10 Components by Statistic Data on a custom page. I would like to create a filter that filters out all items that does not contains in the message IN PROGRESS. Unfortunately, after several tries and research I have no idea how to build this query in this resource. Does anyone has a suggestion on how to create this filter or if there is a better resource to use instead? I like how dynamic this resource is. I did try a custom table, but I don't feel that updates quite as dynamically as the Top 10 resources. I don't need to see the message, just the component name that the message is tied to. Thanks in advance!
