To see the most updated note, use this path :
Sales order Item/ Sales order Item Ticket/ Sales order item ticket registrant / Registrant / Notes 

This would go in your queries "Results field to display" box