Awhile back I wrote an article on how to UNION two record sets. Since I am asked about this often in my ServiceNow Scripting classes; I thought I would publish the link here.
There are a couple of approaches to implementing this. If you want a resultant recordset to report against then you will have to do it with Database Views. If you want a coding solution to merge recordsets from two different tables then you will need to take the approach I outlined in my article.
ServiceNow Admin 101: How to Do a UNION Query Using GlideRecord
Steven Bell
If you find this article helps you, don't forget to log in and "like" it! I would also like to encourage you to become a member of our blog!
Please Share, Like, Comment this blog if you've found it helpful or insightful.
for Click for More Expert Blogs and also Find Expert Events!
