Client is running ZC v1.37 with Super Orders mod (super_orders)

Products have an attribute which are a text field that the customer fills in when populating the shopping cart.

Client asked if I can provide a way to search through the orders and return orders that have matching attributes of the orders placed.

Example, customer's name is an attribute of a product option. It is displayed in the details of the order when looking at that particular order, but if you don't know the order ID or the actual customer's name, (one customer could have many orders with different names as product attributes), then locating the particular order is not an option in the search area of the administration panel.

I am looking at the super_orders.php file,
[ on or around lline 1140 in the file ]

and found where the search filter is located, and want to be able to simply join the orders_products_attributes table to the query, and search for a LIKE on the products_options_values field.

My skills at MySQL queries is rather rusty, and I would appreciate any assistance with my task at hand.

Thank you in advance for your help.

Scott