Re: [WebDNA] Search/sort/summ problem
This WebDNA talk-list message is from 2010
It keeps the original formatting.
numero = 106016
interpreted = N
texte = --Boundary-01=_z759MkcnQGnqCwq Content-Type: text/plain; charset="iso-8859-6" Content-Transfer-Encoding: 7bit Yes, this seems to be the best way to deal with the issue. Sincerely, Kenneth Grome > I am having a problem where this search result is being > broken by the CATEGORYCODEsumm=t > > I note in the docs "Note: it is important to sort by the > same field you wish to summarize -- this sorting enables > WebDNA to easily see when a field changes from one value > to another in the sequence of found items." > > Obviously this can't be done in my situation as I need to > sort the MATRIXDISPLAYORDER after the CATEGORYCODE has > been summarised. > > Do you think that the best way to overcome this would be > to put the results into a table and then search and > summarise ? > > > [Search > db=^data/TOP3MATRIX.db&eqDEPARTMENTCODEdatarq=[url][This > CATEGORYCODE][/url]&neCATEGORYCODEdatarq=[blank]&neMATRIX > DISPLAYORDERdatarq=1099&asCATEGORYCODEsort=1&asMATRIXDISP > LAYORDERsort=2&MATRIXDISPLAYORDERtype=num&CATEGORYCODEsum > m=T&allBLNK=T] > > Regards > > Stuart Tremain > IDFK Web Developments > AUSTRALIA > webdna@idfk.com.au --Boundary-01=_z759MkcnQGnqCwq Content-Type: text/html; charset="iso-8859-6" Content-Transfer-Encoding: 7bit
Yes, this seems to be the best way to deal with the issue.
Sincerely,
Kenneth Grome
> I am having a problem where this search result is being
> broken by the CATEGORYCODEsumm=t
>
> I note in the docs "Note: it is important to sort by the
> same field you wish to summarize -- this sorting enables
> WebDNA to easily see when a field changes from one value
> to another in the sequence of found items."
>
> Obviously this can't be done in my situation as I need to
> sort the MATRIXDISPLAYORDER after the CATEGORYCODE has
> been summarised.
>
> Do you think that the best way to overcome this would be
> to put the results into a table and then search and
> summarise ?
>
>
> [Search
> db=^data/TOP3MATRIX.db&eqDEPARTMENTCODEdatarq=[url][This
> CATEGORYCODE][/url]&neCATEGORYCODEdatarq=[blank]&neMATRIX
> DISPLAYORDERdatarq=1099&asCATEGORYCODEsort=1&asMATRIXDISP
> LAYORDERsort=2&MATRIXDISPLAYORDERtype=num&CATEGORYCODEsum
> m=T&allBLNK=T]
>
> Regards
>
> Stuart Tremain
> IDFK Web Developments
> AUSTRALIA
> webdna@idfk.com.au
--Boundary-01=_z759MkcnQGnqCwq--
Associated Messages, from the most recent to the oldest:
--Boundary-01=_z759MkcnQGnqCwq Content-Type: text/plain; charset="iso-8859-6" Content-Transfer-Encoding: 7bit Yes, this seems to be the best way to deal with the issue. Sincerely, Kenneth Grome > I am having a problem where this search result is being > broken by the CATEGORYCODEsumm=t > > I note in the docs "Note: it is important to sort by the > same field you wish to summarize -- this sorting enables > WebDNA to easily see when a field changes from one value > to another in the sequence of found items." > > Obviously this can't be done in my situation as I need to > sort the MATRIXDISPLAYORDER after the CATEGORYCODE has > been summarised. > > Do you think that the best way to overcome this would be > to put the results into a table and then search and > summarise ? > > > [Search > db=^data/TOP3MATRIX.db&eqDEPARTMENTCODEdatarq=
[url][This > CATEGORYCODE][/url]&neCATEGORYCODEdatarq=[blank]&neMATRIX > DISPLAYORDERdatarq=1099&asCATEGORYCODEsort=1&asMATRIXDISP > LAYORDERsort=2&MATRIXDISPLAYORDERtype=num&CATEGORYCODEsum > m=T&allBLNK=T] > > Regards > > Stuart Tremain > IDFK Web Developments > AUSTRALIA > webdna@idfk.com.au --Boundary-01=_z759MkcnQGnqCwq Content-Type: text/html; charset="iso-8859-6" Content-Transfer-Encoding: 7bit
Yes, this seems to be the best way to deal with the issue.
Sincerely,
Kenneth Grome
> I am having a problem where this search result is being
> broken by the CATEGORYCODEsumm=t
>
> I note in the docs "Note: it is important to sort by the
> same field you wish to summarize -- this sorting enables
> WebDNA to easily see when a field changes from one value
> to another in the sequence of found items."
>
> Obviously this can't be done in my situation as I need to
> sort the MATRIXDISPLAYORDER after the CATEGORYCODE has
> been summarised.
>
> Do you think that the best way to overcome this would be
> to put the results into a table and then search and
> summarise ?
>
>
> [Search
> db=^data/TOP3MATRIX.db&eqDEPARTMENTCODEdatarq=[url][This
> CATEGORYCODE][/url]&neCATEGORYCODEdatarq=[blank]&neMATRIX
> DISPLAYORDERdatarq=1099&asCATEGORYCODEsort=1&asMATRIXDISP
> LAYORDERsort=2&MATRIXDISPLAYORDERtype=num&CATEGORYCODEsum
> m=T&allBLNK=T]
>
> Regards
>
> Stuart Tremain
> IDFK Web Developments
> AUSTRALIA
> webdna@idfk.com.au
--Boundary-01=_z759MkcnQGnqCwq--
Kenneth Grome
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:
clean(); (2004)
How To question on setting up downloads (1997)
Custom WebCat Prefs ... (1997)
Locking up with WebCatalog... (1997)
Database Options (1997)
WebTen and WebCat (1997)
WebDNA permissions? (2002)
WebCatalog dying in NT (1998)
Where's Cart Created ? (1997)
Error Log.db --however (1997)
using showpage and showcart commands (1996)
Major bug report on rootbeer (1997)
What abobut variables named max ??? (2000)
Robert Minor duplicate mail (1997)
Comparing two fields so the match (1998)
Error Log (2000)
$append (1998)
NetSplat and WebCat2 (1997)
Buying sans cart (1997)
japanese characters (1997)