Navigate
Wasp Helpdesk
  • Register

  • or
  • Login
    Need a password reminder?
or
Contact Us
  • Get in touch

    Send us an email

  • Start a chat session

  • Knowledgebase Read help articles
  • News News & updates
  • Contact Us We are here to help
  • Training View our options
  • Product Sunsets Non-Supported Products
Barcode System Consult
Barcode Printer Consult
Barcode Label Consult
  • Portal
  • Knowledgebase
  • Discontinued Products
  • Mobile Asset v6 and older
  • MobileAsset - Labels print for disposed assets
Subscribe Download PDF

MobileAsset - Labels print for disposed assets

Internal User
2017-04-10
in Mobile Asset v6 and older
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.

Rate the quality of this page

This page was helpful :) :( This page was not helpful

4 of 16 people found this page helpful


Quick Jump
  • Wasp Helpdesk
  • Knowledgebase
  • News
  • Contact Us
Top
Helpdesk software provided by Deskpro