Tracking Column Usage and Schema Changes from 24.2 to 25.1

In version 24.2, the base table AddressCrossReference included a column named AddressType. However, this column has been removed in version 25.1.
Is there a way to identify all instances where this column was used?

Additionally, is there a method to detect all such missing columns when comparing the new version against the previous one?

If I understand the ask correctly, you’re trying to introspect on all references to that field on that table. The usual starting point for this would be to launch the Asset Usage application and search by Object Name = AddressType. This should find logic references to the data item. You should be able to then look at each logic block and see if it is referencing that data item within the context of the AddressCrossReference table.

There are other places it can be referenced too such as data mappings within applications and similar, but I’m unaware of any search tool that will locate those.

The deprecation of the AddressType field from the AddressCrossReference table was called out as an action required as part of 24.2 release notes.

1 Like