View Order Group results empty - How to override view
Hi,
I have a situation where I have an order status where nothing will appear in the order status group view - but they show in the order tree on the left under the status.
I think its because it is for orders which have not been paid therefore there are some empty fields which is preventing the results being returned.
I am seeing no error messages though.
How do I override the ViewOrderGroupOrders to enable my status to show - and is this the best thing to do?
Here is my custom status which will not display
OrderStatusId Name Sort RenderChildren RenderInMenu NextOrderStatusId ExternalId IncludeInAuditTrail Order AllowUpdate AlwaysAvailable Pipeline AllowOrderEdit
1000008 Non-paid Questionnaire 1 1 1 NULL NULL 1 NULL 1 1 NULL 1
And another custom one which displays fine
1000007 Order Completed 9 True True NULL NULL True NULL True True NULL True
Sorry for late reply. I have the exact same issue as you do. It also seems if I remove CompletedDate on a purchase order it dissapears from my order list. So I believe it's a bug in uCommerce. Can you verify that the other OrderStatus you have (where orders are listed correctly) all have a CompletedDate set?
I will try to point Søren or someone else from the uCommerce team to look further into this.
Yes all my other order statuses which have completedDate set are all fine and working as expected.
Whilst we are looking at this View. Is there a way to pass any further fields into the view as I would like to display the payment Transaction ID on this screen next to the order ID to make it fast for the administrator to check against the clients other systems.
View Order Group results empty - How to override view
Hi,
I have a situation where I have an order status where nothing will appear in the order status group view - but they show in the order tree on the left under the status.
I think its because it is for orders which have not been paid therefore there are some empty fields which is preventing the results being returned.
I am seeing no error messages though.
How do I override the ViewOrderGroupOrders to enable my status to show - and is this the best thing to do?
Thanks
Hi Cathy,
How is your custom order status configured?
I have tried to configure a custom orderstatus myself and it seems to work.
Best regards Martin
Hi,
Here is my custom status which will not display OrderStatusId Name Sort RenderChildren RenderInMenu NextOrderStatusId ExternalId IncludeInAuditTrail Order AllowUpdate AlwaysAvailable Pipeline AllowOrderEdit 1000008 Non-paid Questionnaire 1 1 1 NULL NULL 1 NULL 1 1 NULL 1
And another custom one which displays fine 1000007 Order Completed 9 True True NULL NULL True NULL True True NULL True
An example order with this status: OrderId OrderNumber CustomerId OrderStatusId CreatedDate CompletedDate CurrencyId ProductCatalogGroupId BillingAddressId Note BasketId VAT OrderTotal ShippingTotal PaymentTotal TaxTotal SubTotal OrderGuid ModifiedOn CultureCode Discount DiscountTotal 2004 XRG-1000312 NULL 1000008 2013-07-24 12:40:25.000 NULL 6 14 368 NULL 00000000-0000-0000-0000-000000000000 NULL NULL NULL NULL NULL NULL CFCF3B02-2EEE-41B7-A96B-2BC49686C5A9 2013-07-24 12:40:25.000 NULL NULL NULL
Note the CompletedDate is null as the order is not yet complete.
Thanks
Cathy
Hi Cathy
Sorry for late reply. I have the exact same issue as you do. It also seems if I remove CompletedDate on a purchase order it dissapears from my order list. So I believe it's a bug in uCommerce. Can you verify that the other OrderStatus you have (where orders are listed correctly) all have a CompletedDate set?
I will try to point Søren or someone else from the uCommerce team to look further into this.
Best regards Martin
I will try out the repro tomorrow and do a fix if it turns out to be an undocumented feature :)
Hi,
Yes all my other order statuses which have completedDate set are all fine and working as expected.
Whilst we are looking at this View. Is there a way to pass any further fields into the view as I would like to display the payment Transaction ID on this screen next to the order ID to make it fast for the administrator to check against the clients other systems.
Thanks
Cathy
It's already in there. You can grab it from:
Hi,
So will the bug/undocumented feature on orders not showing when they have no CompletedDate be resolved?
Thanks
Cathy
is working on a reply...