Custom Status column for the BizTalk Orders Receive Adapter

When the BizTalk – CS Orders Adapter retrieves orders, it updates the Status of an order (usually from “NewOrder” to “Submitted”). Once it retrieves the Orders, it updates the status of the OrderForm so that the next time it runs, it only gets New Orders.

However the adapter works on the “Status” column – which is not used in our firm – instead of which we use a custom status columncalled “OurCompanyOrderStatus”. Hence it currently won’t run when I try to set the “from” and “to” status values. The Orders Adapter offers no way to go look for a custom column, so I am not aware how to do this.

Please advise how to tackle this...?

[1173 byte] By [CodeDigger] at [2008-2-8]