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!