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, Will On 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 Starck NovaDerm Skincare Science http://www.novaderm.com helpdesk@novaderm.com 866-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:

    
  1. Re: Summing results of a nested search ( Terry Wilson 2006)
  2. Re: Summing results of a nested search ( WJ Starck 2006)
  3. Re: Summing results of a nested search ( Stuart Tremain 2006)
  4. Re: Summing results of a nested search ( WJ Starck 2006)
  5. Re: Summing results of a nested search ( Gary Krockover 2006)
  6. Re: Summing results of a nested search ( WJ Starck 2006)
  7. Re: Summing results of a nested search ( WJ Starck 2006)
  8. Re: Summing results of a nested search ( WJ Starck 2006)
  9. Re: Summing results of a nested search ( Gary Krockover 2006)
  10. Re: Summing results of a nested search ( Clint Davis 2006)
  11. Summing results of a nested search ( WJ Starck 2006)
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, Will On 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 Starck NovaDerm Skincare Science http://www.novaderm.com helpdesk@novaderm.com 866-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)