Custom List Criteria - "Available Nearby Seats"

Hi Everyone,

I’m going down a bit of a wormhole with an idea, and thought that this might be a good place to poll and see if anyone has worked on anything similar.

 What I would essentially like to do is create a way for representatives of my organization to pull a list of upcoming show attendees who have open seats to the left or right of their current ones available for sale.

To do this, it appears that I would need to create a customized criteria, so that the list populates correctly.  The overall list with criteria inserted would look something like this:

Ticket Performance Date : <= : (beginning date of interest)

Ticket Performance Date : >= : (end date of interest)

 “Available Nearby Seats” : <= : 1

 Has anyone created something like this, or have a functional way of pulling a list like this?  I'd be curious to know any and all thoughts regarding it.  How laborious might it be to create a custom criteria that would allow me to "see" this information?

Thank you!

Paul Stavish

Patron Services Assistant Manager