Re: Summing results of a nested search
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 67885
interpreted = N
texte = Oyyy... Just for the sake of completeness, the [writefile] should look like [writefile]sku title quantity category [/writefile] It wrapped wrong in Apple Mail... -Will On Aug 7, 2006, at 3:20 PMCDT, WJ Starck wrote: > 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]sku title quantity category > [/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 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:
Oyyy... Just for the sake of completeness, the [writefile] should look like [writefile]sku title quantity category [/writefile] It wrapped wrong in Apple Mail... -Will On Aug 7, 2006, at 3:20 PMCDT, WJ Starck wrote: > 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]sku title quantity category > [/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 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:
database consultant needed (1998)
raw=T is broken in [include] (1997)
PCS Frames-Default page is solution! (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
[protect] on NT? (1997)
Can you do this??? and other stuff (1997)
RePost: NAT and the CART (1999)
WCS Newbie question (1997)
WebCat editing, SiteGuard & SiteEdit (1997)
WebCat2b12 forgets serial # (1997)
database freeze (1997)
# fields limited? (1997)
CommandSecurity? (1997)
FYI: virus alert (1996)
[WebDNA] Fails to recognize comma-separated db (2010)
Balancing randomness (2000)
Location of Browser Info.txt file (1997)
Gremlins, huh? (2000)
database size? (1997)
WebCatalog can't find database (1997)