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
  • Mobile Asset v6
  • MobileAsset - Need to remove some Reasons from the drop down list that were entered in error
Subscribe Download PDF

MobileAsset - Need to remove some Reasons from the drop down list that were entered in error

Internal User
2023-01-19
in Mobile Asset v6

If you have entered some Reasons in error and want to remove them from the drop down list on the Dispose screen, do the following:

 

Download https://dl.waspbarcode.com/wasp/supportfiles/DeleteRemoveReason.zip and extract it on the server machine.

Edit DeleteRemoveReason.wql in Notepad. On this line:

update reasons set record_status = 2 where description = 'REASON'

change REASON to the reason you need removed, i.e.,

where description = 'Whatever'

 

If you need to remove multiple reasons at once, change the above to instead be

where description in ('REASON1', 'REASON2', 'REASON3')

You can add as many reasons as needed into the list, enclosing each with single quotes '.

 

You should not remove the default reasons from the list, just ones that have been added.

Rate the quality of this page

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

5 of 17 people found this page helpful


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