Hello, we need to do some realtime re****ting on orders that have been
processed, and doing this through the CS API was taking far too long. So,
we
are doing direct queries from the OrderFormLineItems and other tables.
The
one thing we need that I can't seem to get at is the equivalent of
LineItem["discounts_applied"]. I'm assuming that this is stashed
somewhere
in the marshaled_data column(s), but can't find how to get at it.
What I'm looking to do is have a single query that returns a dataset with
rows from the OrderFormLineItems table, including the marshaled_data
column.
Once I have that, how can I grab meaningful values out of the marshaled
data?
I'm also open to any other way to grab the discounts_applied field,
without
using the CS API to fetch orders from the database.
Thanks,
Dave
|
