W3C home > Mailing lists > Public > public-interledger@w3.org > April 2017

Request for assistance - Contract Law for Computers

From: Andrew Bransford Brown <andrewbb@gmail.com>
Date: Sat, 15 Apr 2017 23:48:39 -0400
Message-ID: <CAPS+YFKqXMsAP0JuUyo7HaNVHwG4s4x2BHdvZJv+Pz9vNLM-hA@mail.gmail.com>
To: Interledger Community Group <public-interledger@w3.org>
Can someone good with SQL help write some functions?

Raw event data:
http://34.208.7.206/ContractsPage.aspx

Bad example of 'flattening' that data:
select
Seller = (select top 1 CommerceID from ContractItem where ContractID =
@ContractID and ItemType = 'Offer' order by ItemID),
Buyer = (select top 1 CommerceID from ContractItem where ContractID =
@ContractID and ItemType = 'Agree'),
Amount = (select top 1 Description from ContractItem where ContractID =
@ContractID and ItemType = 'Terms'),
Status = (select top 1 ItemType from ContractItem where ContractID =
@ContractID order by ItemID desc)
Received on Sunday, 16 April 2017 03:49:12 UTC

This archive was generated by hypermail 2.3.1 : Sunday, 16 April 2017 03:49:12 UTC