[ts-gen] cross session orders, client ids

Nils Gebhardt mail at ngebhardt.de
Wed Dec 31 03:04:21 EST 2008



On Tue, 2008-12-30 at 13:41 -0500, pippin at owlriver.net wrote:
[...]
> Part way through answering your question, I realized that it probably
> didn't have anything to do with the new mark aka label aka brand aka
> order_ref attribute.  The key point was probably the phrase:
> 
> > ... what might be the right candidate for a common key [?]
> 
> In brief, you need to match using (acc, client_id, order_tag)
> triples.  Such triples occur in the tables CreateEvent,
> OrderStatus, ActiveOrder, and OrderReport.  Records of the first
> reflect commands to, and the other three, messages from, the api.
> These three attributes --- the account code, connection id, and
> order id --- together work to identify a unique order line item.
> Although there are other unique keys for order line items, no
> other unique key tuple is as widely available across the various
> journal tables.
> 
[...]

Yes, that helps. 

Thanks, 

Nils



More information about the ts-general mailing list