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=_z759MkcnQGnqCwqContent-Type: text/plain; charset="iso-8859-6"Content-Transfer-Encoding: 7bitYes, 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=_z759MkcnQGnqCwqContent-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=_z759MkcnQGnqCwqContent-Type: text/plain; charset="iso-8859-6"Content-Transfer-Encoding: 7bitYes, 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=_z759MkcnQGnqCwqContent-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:
WebCat2: Found Items syntax, etc. (1997)
Nested [xxx] contexts & Bad Suffix (1998)
Grant, please help me ... (1997)
Search in 2 or more catalogs (1997)
Orderfile Encryption (2007)
Document Contains No Data! (1997)
RE: Upload (1998)
Error: this shopping cart has already been submittedm (2004)
RE: New WebCatalog Version !!! (1997)
cart file creation (2003)
problems with 2 tags (1997)
Re:Searching for ALL / empty form field (1997)
SiteGuard Use Question (1997)
Keep away (1997)
Showif vs. IF/then/else (2001)
2nd WebCatalog2 Feature Request (1996)
Search as error page (2002)
Frames and WebCat (1997)
[WebDNA] WebDNA programmers for hire? (2010)
For those of you not on the WebCatalog Beta... (1997)