Evergreen

Deleting an item will not remove the item from bookable resources

Bug #1175766 reported by Dale Rigney
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Evergreen
Confirmed
Low
Unassigned

Bug Description

When you delete an item that is listed as a bookable resource, the item will remain in the list for bookable items. You can even select the barcode and confirm a reservation for that item even though the item is marked as deleted in asset.copy.

To make a reservation on the deleted item you need to enter a barcode of the same resource type in the "Create Reservations" screen click on Next and then select the deleted barcode off the list provided. If you enter the deleted barcode on the "Create Reservations" screen you will receive a "Could not locate that resource." error.

Tags: booking
Ben Shum (bshum)
tags: added: booking
Changed in evergreen:
status: New → Triaged
Revision history for this message
Michele Morgan (mmorgan) wrote :

Confirming that this can still happen in 3.2. Not sure if this will be addressed as part of bug 1816475, but will reference it there.

Changed in evergreen:
status: Triaged → Confirmed
Rogan Hamby (rogan-hamby)
Changed in evergreen:
assignee: nobody → Rogan Hamby (rogan-hamby)
Revision history for this message
Rogan Hamby (rogan-hamby) wrote :

I was just brainstorming with someone on this and the current setup for bookable resources that are also cataloged items is complicated. Bookable resources only have an indirect link to the cataloged item. So, right now we could only update through a trigger on asset.copy but that is very expensive on every copy update for how much booking resources are used. A related issue is cascading updates - right now a barcode could change on an item and it would not change the barcode on the booked resource.

Right now I'm unsure of the best path forward but would be glad to hear thoughts.

Changed in evergreen:
importance: Undecided → Low
Revision history for this message
Jane Sandberg (sandbergja) wrote :

Having a more solid link between booking.resource and asset.copy would also probably help with a solution to https://bugs.launchpad.net/evergreen/+bug/1085263

Revision history for this message
Rogan Hamby (rogan-hamby) wrote :

Even with something like a copy/resource map we would still need a trigger for updates and that kind of makes my right eye twitch. Purely in the spirit of brainstorming it seem like it would be conceptually easiest to have resources become a child table of asset.copy. There would be some upgrade hurdles but I'm imagining that would be a major set of workflow changes for people using these resources since copies have a lot more requirements than resources. And thus a lot of UI changes too. There would also be a need to audit various logic. I'm assuming that is not a realistic option at this time.

Revision history for this message
Jane Sandberg (sandbergja) wrote :

Just out of curiosity, what would be the drawback to simply adding a nullable "copy" column to booking.resource that references asset.copy? It seems like the easiest way to have a nice solid link, but I'm guessing there has to be some reason nobody has done that.

Rogan Hamby (rogan-hamby)
Changed in evergreen:
assignee: Rogan Hamby (rogan-hamby) → nobody
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.