Re: Summing results of a nested search
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 67880
interpreted = N
texte = Perhaps this (untested):[search db=orders.db&nefilledata=T] [founditems] [search db=lineitems.db&neskudata=[blank]] [founditems] [search db=lineitems.db&eqskudatarq=[sku]] [founditems] [sku] [sum field=quantity] [/founditems] [/search] [/founditems] [/search] [/founditems][/search]GaryAt 11:29 AM 8/7/2006, you 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:
Perhaps this (untested):[search db=orders.db&nefilledata=T] [founditems] [search db=lineitems.db&neskudata=[blank]] [founditems] [search db=lineitems.db&eqskudatarq=[sku]] [founditems] [sku] [sum field=quantity] [/founditems] [/search] [/founditems] [/search] [/founditems][/search]GaryAt 11:29 AM 8/7/2006, you 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/
Gary Krockover
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:
Duplicate Carts (2000)
Calendar sample (1998)
can WC render sites out? (1997)
RE: WebCatalog2 for NT Beta Request (1997)
Upgrading old WebCat Database Files (1997)
Security Question (1997)
Error:Too many nested [xxx] contexts (1997)
WebCat2b15MacPlugin - [protect] (1997)
Non-technical messages ... (1997)
Opening 'order file'. (1999)
Server Freeze (1998)
Error Log.db --however (1997)
Mac 2.1b4 unknown error: BadSuffix (1997)
Cookies and webcat (1997)
Fun with Dates - finally resolved but.... (1997)
PCS Frames (1997)
starting news site + small store (2000)
[OT] HTML Table Cell Problem (2003)
Cookies not setting on IE (2002)
[WebDNA] CSS Advice (2008)