/
Updating EIBO Barcode Values in SSMS

Updating EIBO Barcode Values in SSMS

Owned by Kaitlyn Niemann (Unlicensed)
Last updated: Nov 08, 2022 by Jessica Benoit (Unlicensed)
1 min read

This document defines the process and queries used to update locked Barcodes of Expired events in EIBO using SSMS.

  1. Login to .204

  2. Create a new query.

  3. Copy and Paste the following Query.

DECLARE @TicketGroups TABLE(TicketGroupID int)

 

DECLARE @Production int = /*ProductionID*/ 123456 /*Here*/

 

INSERT INTO @TicketGroups
SELECT DISTINCT
tg.TicketGroupID
FROM TicketGroup tg
LEFT JOIN Ticket t
ON tg.TicketGroupID = t.TicketGroupID
WHERE
tg.ProductionID = @Production  AND
t.OriginalBarcode IS NOT NULL AND
tg.ShareTypeID != 3

 

UPDATE Ticket
SET OriginalBarcode = NULL
WHERE TicketGroupID in (SELECT * FROM @TicketGroups)

 

DELETE FROM @TicketGroups

5. Run the Query

SELECT DISTINCT
eiboxoffice.dbo.TicketGroup.TicketGroupID,
eiboxoffice.dbo.Event.EventName,
eiboxoffice.dbo.Venue.VenueName,
eiboxoffice.dbo.TicketGroup.EventDate,
eiboxoffice.dbo.def_TicketStatusType.TicketStatusTypeName
FROM eiboxoffice.dbo.TicketGroup
LEFT JOIN eiboxoffice.dbo.Ticket
ON eiboxoffice.dbo.TicketGroup.TicketGroupID = eiboxoffice.dbo.Ticket.TicketGroupID
LEFT JOIN eiboxoffice.dbo.Event
ON eiboxoffice.dbo.TicketGroup.PrimaryEventID = eiboxoffice.dbo.Event.EventID
LEFT JOIN eiboxoffice.dbo.Venue
ON eiboxoffice.dbo.TicketGroup.VenueID = eiboxoffice.dbo.Venue.VenueID
LEFT JOIN eiboxoffice.dbo.def_TicketStatusType
ON eiboxoffice.dbo.TicketGroup.TicketStatusTypeID = eiboxoffice.dbo.def_TicketStatusType.TicketStatusTypeID
WHERE
eiboxoffice.dbo.Event.EventName = 'VarChar' AND
eiboxoffice.dbo.TicketGroup.EventDate = 'YYYY-MM-DD HH:MM:SS' AND
eiboxoffice.dbo.Ticket.OriginalBarcode IS NOT NULL AND
eiboxoffice.dbo.def_TicketStatusType.TicketStatusTypeName != 'Sold'

  1. Use this query to identify the TicketGroupID(int) of the Barcodes we want to update.

  1. Plug and play values from the events you need to remove Barcodes for.

  1. Paste the TicketGroupID(int) from the first query into this one.

UPDATE [eiboxoffice].[dbo].[Ticket]

SET [eiboxoffice].[dbo].[Ticket].OriginalBarcode = NULL

WHERE
[eiboxoffice].[dbo].[Ticket].[TicketGroupID] = int

12. Adjust the dates in EIBO as needed.

Related content