Hello @raj99918 ,
Just wanted to confirm—are you looking to create a report using the old (now deactivated) variable data, or do you want to pull the data via script to use somewhere else? Both are totally possible, just depends on what exactly you need.
We actually had a similar case a while back for our New Hire catalog item. Initially, we had a few different variables, and later we changed the logic and deactivated the old ones. After a few months, our client needed a report to track those old variable values, specifically for audit purposes.
In our case, those were regular variables—not part of any variable set or MRVS—so they were still available to report on without creating any database view or anything, even after being deactivated. I just tested it again to be sure, and yes, you can create a report on the RITM table and include those old/inactive variables in the columns and set the filter condition as that variable value is not empty or you can set the created before date as well so that you can get the old data only the time when those variables were active.
I've attached a screenshot below showing how it looks. Let me know if this is what you were aiming for, or if you had something else in mind!
Please Mark ✅Correct if this solves your query and also mark 👍Helpful if you find my response worthy based on the impact.
Regards,
Aniket
