Re: Summing results of a nested search
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 67884
interpreted = N
texte = Here's another way using a temp database (I'm bored today ;)[!]##### This sections fills a temp db with the skus and quantities of all the unfilled orders #######[/!][search db=../catalog.db&eqinstockdatarq=T] [founditems] [math show=f]quantity[sku]=0[/math] [/founditems][/search][writefile ../dbs/filledtemp.db]skutitlequantitycategory[/writefile] [search db=../orders.db&neshippeddatarq=T&eqapproveddatarq=T] [founditems] [search db=../lineitems.db&eqordernamedatarq=[ordername]] [founditems] [math show=f]quantity[sku]=([interpret][quantity[sku]] [/interpret]+[quantity])[/math] [replace db=../dbs/filledtemp.db&eqskudatarq=[sku] &append=T]sku=[sku]&quantity=[interpret][quantity[sku]][/interpret] &title=[lookup db=../catalog.db&value=[sku] &lookinfield=sku&returnfield=title]&category=[lookup db=../ catalog.db&value=[sku]&lookinfield=sku&returnfield=category][/replace] [/founditems] [/search] [/founditems] [/search]
[search db=../dbs/filledtemp.db&neskudata=[blank] &ascategorysort=1&astitlesort=2&asskusort=3] [founditems] [sku] [title] [quantity][/founditems] [/search][!]############ end section ##############[/!]Cheers,WillOn Aug 7, 2006, at 1:54 PMCDT, WJ Starck wrote:> Thanks.>> I don't think it's possible to do what I want because it appears to > be a database design issue.>> So, instead, I add a field [filled] to the lineitems database, > which gets toggled to "T" when an order is filled.>> Then, in my template:>> [!]###--------Initialize variable quantity[sku]-------###[/!]>> [search db=../catalog.db&eqinstockdatarq=T]> [founditems]> [math show=f]quantity[sku]=0[/math]> [/founditems]> [/search]> > [!]###-------do the math-------###[/!]>> [search db=../lineitems.db&nefilleddatarq=T]> [founditems]> [math show=f]quantity[sku]=([interpret][quantity[sku]][/ > interpret]+[quantity])[/math]> [/founditems]> [/search]> >> [!]###-------Display results-------###[/!]>> [search db=../lineitems.db&nefilleddatarq=T&skusumm=T]> [founditems]> [sku] [title] [interpret][quantity[sku]][/interpret]> [/founditems]> [/search]>> That did the trick.>> Thanks all....>> --> Will Starck> NovaDerm Skincare Science> http://www.novaderm.com> helpdesk@novaderm.com> 866-892-4149>>>>> On Aug 7, 2006, at 11:43 AMCDT, Gary Krockover wrote:>>> 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]>>>> Gary>>>> At 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 > digest@talk.smithmicro.com>>> Web Archive of this list is at: http://webdna.smithmicro.com/>>>>>>>> -------------------------------------------------------------> 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 digest@talk.smithmicro.com>> Web Archive of this list is at: http://webdna.smithmicro.com/--Will StarckNovaDerm Skincare Sciencehttp://www.novaderm.comhelpdesk@novaderm.com866-892-4149-------------------------------------------------------------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:
Here's another way using a temp database (I'm bored today ;)[!]##### This sections fills a temp db with the skus and quantities of all the unfilled orders #######[/!][search db=../catalog.db&eqinstockdatarq=T] [founditems] [math show=f]quantity[sku]=0[/math] [/founditems][/search][writefile ../dbs/filledtemp.db]skutitlequantitycategory[/writefile] [search db=../orders.db&neshippeddatarq=T&eqapproveddatarq=T] [founditems] [search db=../lineitems.db&eqordernamedatarq=[ordername]] [founditems] [math show=f]quantity[sku]=([interpret][quantity[sku]] [/interpret]+[quantity])[/math] [replace db=../dbs/filledtemp.db&eqskudatarq=[sku] &append=T]sku=[sku]&quantity=[interpret][quantity[sku]][/interpret] &title=[lookup db=../catalog.db&value=[sku] &lookinfield=sku&returnfield=title]&category=[lookup db=../ catalog.db&value=[sku]&lookinfield=sku&returnfield=category][/replace] [/founditems] [/search] [/founditems] [/search]
[search db=../dbs/filledtemp.db&neskudata=[blank] &ascategorysort=1&astitlesort=2&asskusort=3] [founditems] [sku] [title] [quantity][/founditems] [/search][!]############ end section ##############[/!]Cheers,WillOn Aug 7, 2006, at 1:54 PMCDT, WJ Starck wrote:> Thanks.>> I don't think it's possible to do what I want because it appears to > be a database design issue.>> So, instead, I add a field [filled] to the lineitems database, > which gets toggled to "T" when an order is filled.>> Then, in my template:>> [!]###--------Initialize variable quantity[sku]-------###[/!]>> [search db=../catalog.db&eqinstockdatarq=T]> [founditems]> [math show=f]quantity[sku]=0[/math]> [/founditems]> [/search]> > [!]###-------do the math-------###[/!]>> [search db=../lineitems.db&nefilleddatarq=T]> [founditems]> [math show=f]quantity[sku]=([interpret][quantity[sku]][/ > interpret]+[quantity])[/math]> [/founditems]> [/search]> >> [!]###-------Display results-------###[/!]>> [search db=../lineitems.db&nefilleddatarq=T&skusumm=T]> [founditems]> [sku] [title] [interpret][quantity[sku]][/interpret]> [/founditems]> [/search]>> That did the trick.>> Thanks all....>> --> Will Starck> NovaDerm Skincare Science> http://www.novaderm.com> helpdesk@novaderm.com> 866-892-4149>>>>> On Aug 7, 2006, at 11:43 AMCDT, Gary Krockover wrote:>>> 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]>>>> Gary>>>> At 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 > digest@talk.smithmicro.com>>> Web Archive of this list is at: http://webdna.smithmicro.com/>>>>>>>> -------------------------------------------------------------> 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 digest@talk.smithmicro.com>> Web Archive of this list is at: http://webdna.smithmicro.com/--Will StarckNovaDerm Skincare Sciencehttp://www.novaderm.comhelpdesk@novaderm.com866-892-4149-------------------------------------------------------------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/
WJ Starck
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:
CSV import suggestions (2007)
4.5.1 download link (2003)
Best way to handle 404 errors with WebDNA and Web* V (2003)
Beta List (1998)
[Q] Novice's question (1997)
Combining search criteria in a context? (1998)
Username/Password with [Protect] (2000)
RE: type 2 errors with ssl server (1997)
Credit card types (1997)
founditems and setheader (2000)
Generating unique SKU from [cart] - Still Stumped... (1997)
Mixing and/or in searches (1998)
Robots fill event log (1997)
Getting Emailer to send mail (1997)
Contain in search (2005)
Running _every_ page through WebCat-error.html (1997)
More on the email templates (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
Stopping NT WebCat service (1998)
Limiting user access to .tmpl files (1997)