Vote up!
Vote down!

Views Search Filter On Commerce Payment Transaction: Message

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.

Asked by: Kepford
on August 18, 2012

1 Answer

Vote up!
Vote down!

Looks like the reason filters do not work on the transaction message field is that it's stored as a Blob in the DB. I have created a check number fapi field and I'm trying to figure out how to added that to the payment form.

Answer by: Kepford
Posted: Aug 19, 2012