Hi,
I'm looking to add recipient_name and recipient_id to the Order Export Utility. Does anyone have an example you'd be willing to share of how you've edited LP_ORDER_EXPORT to do this, or even something else? I'm having a brain freeze and just need an example to work from.
Thanks!Kathleen
The basic idea is that you're going to UPDATE rows in TW_ORDER_IMPORT WHERE session_id = @session_id. The import_ref_no column will contain the order_no from T_ORDER so that you can pull in your recipient information.
The problem that you're going to have to solve is that there is a 1:many relationship between T_ORDER and T_SUB_LINEITEM, which contains your recipient_no. (To get recipient_name, I would recommend joining that column to dbo.FT_CONSTITUENT_DISPLAY_NAME().) You'll need to decide the best way to solve this problem to accomplish your business need — do you pick just one recipient out of the bunch somehow, and by what criteria? If you want to include multiple recipients, you still have to contend with the fact that you only have 10 local use fields, and with two fields being used per recipient, what will you do when you have more than five?