Developer forum

Forum » Development » Select all orders where Capture state is 'Captured'

Select all orders where Capture state is 'Captured'

Roald Haahr Jensen
Reply

Hi

I am trying to select all orders with the capture state 'Captured', however there does not seem to be a column in the database presenting this information, other than 'OrderCaptureInfo', which also contains a bunch of XML. I could of course search in the mentioned column for the capture state that I am interested in, but I assume there must be a more straightforward way.

Should I search this column for the desired value or is there, in fact, a better way to get this value for an order?

/ Roald


Replies

 
Vladimir Shushunov Dynamicweb Employee
Vladimir Shushunov
Reply

Hi Roald,

Perhaps this field will suit you: OrderCaptureAmount
OrderCaptureAmount > 0 - some amount was captured
OrderCaptureAmount > 0 & OrderTransactionAmount = OrderCaptureAmount - full capture

Best regards,
Vladimir

 

You must be logged in to post in the forum