I want to create a dynamic list to run, as a filter in the Batch print set up so I can make sure we are printing orders that are place through TMP with HABO or mail delivery methods.
Mobile App is set up as a sales channel for TNMP
In List manager I don't see Channel as a criteria. So I am trying ( and failing!) to build Ticket Sales Channel as a criteria.
This is what I have in T_Keyword;
· Description Column Tickets-Channel.
· Data Type column String
· Edit Mask Alphanumeric
· Detail Tbl-------I am not sure what if anything
· Detail Col !.key_value
· Ref Tbl TR_SALES_CHANNEL
· Ref IdCol id
· Ref DesCol Descripton
The criteria is available in list manager but when I choose it doesn't filter the Mobile app channel.
Can anyone tell me what I am missing?
Thanks!
If you are on version 12 and use the new T_ticket_history table for ticket histories, you will probably find that channel is not an available as an element of data in list manager. So you are going to use something from the orders table to achieve this. I will try and respond tomorrow when I get in.
The other problem is that using a list will not be as accurate as using an order field to control your print run. (because customers may have orders created in different channels at the same time. So you might be better using a small sql job to update say the order category when these criteria are met.
All though I wouldn't by choice do this way your list would work with
data type; Number, Edit mask; blank, detail Tbl; T_ORDER , Detail column; !.channel ,...and the rest as you had it
Thanks so much. I was indeed able to create a new criteria. Valuable lesson for another application, because it didn't work for this issue. Tickets that are flagged as printed because the buyer viewed them in the My Accounts folder of the Mobile App, yet were NOT printed can not be culled this way.
As Steve pointed out the ability to view tickets in the Mobile app. will be amended. So I will wait to see how that works to resolve our and our customers confusion.
Thanks so much for your help!
Carol