Re: Summing results of a nested search
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 67878
interpreted = N
texte = I think you'll need another (nested) search in there. You need to find all unfilled orders, a summary of all products, then a quantity for those products. On 8/7/06 11:29 AM, "WJ Starck"
wrote: > Can't get my brain around this one. > > Our orders are written to 2 databases, orders.db and lineitems.db. > > I want to display a summary listing of the quantities of the skus > for all of the orders that haven't been filled so we can pick them > from the warehouse. > > So, if I had several orders like this: > > Order 1: > > sku qty > ----------------- > 001 5 > 003 1 > > Order 2: > sku qty > ----------------- > 001 1 > 004 12 > 006 5 > > My results would look like: > > sku qty > ------------------ > 001 6 > 003 1 > 004 12 > 006 5 > > But how? > > > I can get a non summated listing by doing: > > [search db=orders.db&nefilledata=T] > [founditems] > [search db=lineitems.db&neskudata=[blank]] > [founditems] > [sku] [quantity] > [/founditems] > [/search] > [/founditems] > [/search] > > But how do I get a summated listing? It seems [table] should do what > I want, but I'm not certain how to code this inside a nested search. > > Any ideas? ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
I think you'll need another (nested) search in there. You need to find all unfilled orders, a summary of all products, then a quantity for those products. On 8/7/06 11:29 AM, "WJ Starck" wrote: > Can't get my brain around this one. > > Our orders are written to 2 databases, orders.db and lineitems.db. > > I want to display a summary listing of the quantities of the skus > for all of the orders that haven't been filled so we can pick them > from the warehouse. > > So, if I had several orders like this: > > Order 1: > > sku qty > ----------------- > 001 5 > 003 1 > > Order 2: > sku qty > ----------------- > 001 1 > 004 12 > 006 5 > > My results would look like: > > sku qty > ------------------ > 001 6 > 003 1 > 004 12 > 006 5 > > But how? > > > I can get a non summated listing by doing: > > [search db=orders.db&nefilledata=T] > [founditems] > [search db=lineitems.db&neskudata=[blank]] > [founditems] > [sku] [quantity] > [/founditems] > [/search] > [/founditems] > [/search] > > But how do I get a summated listing? It seems [table] should do what > I want, but I'm not certain how to code this inside a nested search. > > Any ideas? ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Clint Davis
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Umm...about those log files? (Off Topic) (1997)
Re:What file? (1997)
math/text variable limits per page (2001)
WCS Newbie question (1997)
Searchable list mail via wwebcat (1998)
PCS Frames (1997)
Pulling Captions from JPGs (2003)
carriage returns in data (1997)
multipart part 2 (2004)
using showpage and showcart commands (1996)
Applescript error (1998)
The IBC root beer has arrived! (1997)
Bug or syntax error on my part? (1997)
I have observed and I am gone. (1998)
MOD_REWRITE Search Engine Friendly URLs (2008)
WCS Newbie question (1997)
Lost Installer (2000)
[shell] oddity (2002)
Help name our technology! I found it (1997)
[GROUPS] followup (1997)