Report to show data from archived table and current table

jakehford
Kilo Contributor

‎02-13-2018 02:27 PM

I have a custom created table and an archive table for that custom table.

We have a need to show all data from both tables. We want to see everything, archived or not.

Tried creating a database view, but there are really no fields that we can use for the WHERE clause.. Tables aren't exactly related, archive table just flattens everything so that it saves space later on. However, we really need an aggregated list from   both tables..

Labels:
0 Helpfuls
  • 1,605 Views
1 REPLY 1

Adam Stout
ServiceNow Employee
ServiceNow Employee

‎02-17-2018 09:51 PM

Views work to JOIN data, but not to UNION it.  I think the best you'll be able to do is use two reports.  Alternatively, you can setup Performance Analytics to track your key measures on the data you are archiving and build a history that you can measure.  In many cases, that should remove the need to run actual reports on the data.