[WebDNA] Search/sort/summ problem
This WebDNA talk-list message is from 2010
It keeps the original formatting.
numero = 106015
interpreted = N
texte = --Apple-Mail-12--563153986 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii I am having a problem where this search result is being broken by the = CATEGORYCODEsumm=3Dt 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=3D^data/TOP3MATRIX.db&eqDEPARTMENTCODEdatarq=3D[url][ThisCATEGORYCODE][= /url]&neCATEGORYCODEdatarq=3D[blank]&neMATRIXDISPLAYORDERdatarq=3D1099&asC= ATEGORYCODEsort=3D1&asMATRIXDISPLAYORDERsort=3D2&MATRIXDISPLAYORDERtype=3D= num&CATEGORYCODEsumm=3DT&allBLNK=3DT] Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au --Apple-Mail-12--563153986 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii I am = having a problem where this search result is being broken by the = CATEGORYCODEsumm=3Dt
I note in the docs " 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=3D^data/TOP3MATRIX.db&eqDEPARTMENTCODEdatarq=3D[url][ThisCATEGORYCO= DE][/url]&neCATEGORYCODEdatarq=3D[blank]&neMATRIXDISPLAYORDERdatar= q=3D1099&asCATEGORYCODEsort=3D1&asMATRIXDISPLAYORDERsort=3D2&M= ATRIXDISPLAYORDERtype=3Dnum&CATEGORYCODEsumm=3DT&allBLNK=3DT]
= --Apple-Mail-12--563153986--
Associated Messages, from the most recent to the oldest:
--Apple-Mail-12--563153986 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii I am having a problem where this search result is being broken by the = CATEGORYCODEsumm=3Dt 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=3D^data/TOP3MATRIX.db&eqDEPARTMENTCODEdatarq=3D
[url][ThisCATEGORYCODE][= /url]&neCATEGORYCODEdatarq=3D[blank]&neMATRIXDISPLAYORDERdatarq=3D1099&asC= ATEGORYCODEsort=3D1&asMATRIXDISPLAYORDERsort=3D2&MATRIXDISPLAYORDERtype=3D= num&CATEGORYCODEsumm=3DT&allBLNK=3DT] Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au --Apple-Mail-12--563153986 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii I am = having a problem where this search result is being broken by the = CATEGORYCODEsumm=3Dt
I note in the docs " 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 = ?