I'm setting up my first Commerce site and have a bit of a problem. In addition to credit card payments the store admin needs to be able to key in mail in orders and use a check payment method. They want to record the check number and later be able to search the orders by the check numbers.

I used the example payment module as a guide to write my own check payment module. I'm using the transaction message field to store the check number. The problem is that views does not seem to filter properly on this field. I've modified the orders admin view and added the "Commerce Payment Transaction: Message" as a filter but it doesn't seem to work as I would expect.

If I set the exposed filter to "Contains any word" and search with the term "1234567890" I get nothing. Even though there is a record
with the value "checknumber: 1234567890". This may be a views issue but I thought I would ask here since I really just want to have a searchable record of check numbers. Maybe I should be doing this differently.