• Toll-free  888-665-8637
  • International  +1 717-220-0012
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

TKatch
#1 Posted : Thursday, February 7, 2013 1:50:34 PM(UTC)
TKatch

Rank: Member

Joined: 1/23/2013(UTC)
Posts: 267
Location: Joliet, IL

Thanks: 64 times
I need to search for specific sku numbers on the Admin Order Manager page. How do I add that to the search criteria?
Steve95
#2 Posted : Friday, February 8, 2013 7:16:28 AM(UTC)
Steve95

Rank: Member

Joined: 4/29/2010(UTC)
Posts: 256

Thanks: 4 times
Was thanked: 11 time(s) in 10 post(s)
Hi Tom

Unfortunately you cannot search for specific SKU from the order manager pages out of the box. Do you wish to develop the the functionality yourself ? If this is the case I have added a few pointers below

The Order Details page uses a Gridview which is populated from the FindOrder method which creates the criteria for the Object Data Source which in turn calls BVSoftware.Bvc5.Core.Orders.Order.

The above retrieve the data through the stored procedure dbo.bvc_Order_ByCriteria_s

From here you now have two options

1. Modify the dbo.bvc_Order_ByCriteria_s stored procedure to return the data you have requested. Warning you will have to pay particular attention to not affecting other areas of the application which also use this functionality, This would be the quickest way to get the functionality you want, but it does carry a degree of risk.

2. Modify the object data source to call one of your own methods which retrieves the information by your own SQL statement/stored procedure. This is less of a risk as the default BV code is retained. Less regression testing is required and the potential future upgrade path with regards to the database remains untouched.

If you have any further questions feel fee to send me a PM

Edited by user Friday, February 8, 2013 7:18:41 AM(UTC)  | Reason: Not specified

Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

©2024 Develisys. All rights reserved.
  • Toll-free  888-665-8637
  • International  +1 717-220-0012