The Asset table MUST always retain the information about disposed assets, otherwise the reports will not have the historical information they need. If you connect a label to that table without filtering, it will show the disposed assets. We have built several different things into the database to facilitate label printing that account for this.
The main thing is that there is an entirely different table (actually a view, if you are familiar with SQL databases) named dbo.vLabelerAsset_AssetTag. This is the table that is used for the default labels. It includes only active objects, and the serial number is one of the available columns. We recommend using this table, because it alleviates the need to set up filters.
If you must use dbo.assets because it has a column that is not available on dbo.vLabelerAsset_AssetTag, you could use both tables, and create a link through asset_tag on the table linking. That way, you would still only get the assets from dbo.vLabelerAsset_AssetTag without filtering, but would have access to the columns from both tables. Also, depending on the column, you could submit a feature request to ask that the column be added to dbo.vLabelerAsset_AssetTag and we will see if that is feasible.
And finally, dbo.asset now has 2 columns you can use to filter. It has always had a column called record_status, with values 1 for active and 2 for disposed. In the current version (5.3 or newer), it also has a column named is_disposed, with T for true and F for false. If your label is using only dbo.asset, you will need to set up a filter so it shows only record_status = 1 or is_disposed = F.
The main thing is that there is an entirely different table (actually a view, if you are familiar with SQL databases) named dbo.vLabelerAsset_AssetTag. This is the table that is used for the default labels. It includes only active objects, and the serial number is one of the available columns. We recommend using this table, because it alleviates the need to set up filters.
If you must use dbo.assets because it has a column that is not available on dbo.vLabelerAsset_AssetTag, you could use both tables, and create a link through asset_tag on the table linking. That way, you would still only get the assets from dbo.vLabelerAsset_AssetTag without filtering, but would have access to the columns from both tables. Also, depending on the column, you could submit a feature request to ask that the column be added to dbo.vLabelerAsset_AssetTag and we will see if that is feasible.
And finally, dbo.asset now has 2 columns you can use to filter. It has always had a column called record_status, with values 1 for active and 2 for disposed. In the current version (5.3 or newer), it also has a column named is_disposed, with T for true and F for false. If your label is using only dbo.asset, you will need to set up a filter so it shows only record_status = 1 or is_disposed = F.