Re: [WebDNA] sort parameters in search
This WebDNA talk-list message is from 2015
It keeps the original formatting.
numero = 111844
interpreted = N
texte = As for an example, right now I'm displaying images which are in various libr=aries, added to the site at regular intervals. When someone searches for a c=ategory, I want the results to be by date added, then file name (so they'll b=e in order). Unless the category is big feet. Then I want it to be by shoe s=ize, then date, then file name.A similar scenario plays out when you have sortable headings in a table, whe=n the same search is expected to sort differently under a number of conditio=ns.I realize after my previous email that programmatically it's not a numerical= thing but merely an instruction and sort1 etc are merely instructions, so m=aybe it's not that simple to change.Sent from my iPad> On Jan 12, 2015, at 7:12 AM, Donovan Brooke
wrote:>=20> Hi Terry,>=20> Are you saying later sort params get ignored if prior sort params don=E2=80==99t apply?>=20> Can you post a test template and your desired results?>=20> Donovan>=20>=20>=20>=20>=20>=20>> On Jan 11, 2015, at 11:06 PM, Terry Wilson wrote:>>=20>> I'd really to see the sort parameters in [search] sort regardless of the s=pecified number. How do I explain this.>>=20>> &fieldAsort=3D1&fieldBsort=3D2&fieldCsort=3D3&fieldDsort=3D4>>=20>> But I only need fieldA to lead the sort for one condition. So unless that= comes up, I just hide fieldAsort=3D1 like so:>>=20>> [showif [specialcase]=3Dt]&fieldAsort=3D1[/showif]&fieldBsort=3D2&fieldCs=ort=3D3&fieldDsort=3D4>>=20>> This comes up from time to time, and actually right now it's coming up fo=r me again and as usual, I have to showif/hideif the entire sort string for e=ach condition instead of just slipping in the one that I need for certain ca=ses.>>=20>> [showif [specialcase]=3Dt]&fieldAsort=3D1&fieldBsort=3D2&fieldCsort=3D3&f=ieldDsort=3D4[/showif]>> [hideif [specialcase]=3Dt]&fieldBsort=3D1&fieldCsort=3D2&fieldDsort=3D3[/=hideif]>>=20>> kind of a pain in the ass when you're still deciding what to best sort on= - now you have 2 places to futz with as you refine.>>=20>> Bonus points to also let those numbers be decimal. Let's say sometimes yo=u need an additional sort in the middle. Throw a showif on fieldZsort=3D2.5 a=s needed:>>=20>> &fieldAsort=3D1&fieldBsort=3D2&fieldZsort=3D2.5&fieldCsort=3D3&fieldDsort==3D4--------------------------------------------------------->> This message is sent to you because you are subscribed to>> the mailing list .>> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us>> Bug Reporting: support@webdna.us>=20> ---------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us> Bug Reporting: support@webdna.us
Associated Messages, from the most recent to the oldest:
As for an example, right now I'm displaying images which are in various libr=aries, added to the site at regular intervals. When someone searches for a c=ategory, I want the results to be by date added, then file name (so they'll b=e in order). Unless the category is big feet. Then I want it to be by shoe s=ize, then date, then file name.A similar scenario plays out when you have sortable headings in a table, whe=n the same search is expected to sort differently under a number of conditio=ns.I realize after my previous email that programmatically it's not a numerical= thing but merely an instruction and sort1 etc are merely instructions, so m=aybe it's not that simple to change.Sent from my iPad> On Jan 12, 2015, at 7:12 AM, Donovan Brooke wrote:>=20> Hi Terry,>=20> Are you saying later sort params get ignored if prior sort params don=E2=80==99t apply?>=20> Can you post a test template and your desired results?>=20> Donovan>=20>=20>=20>=20>=20>=20>> On Jan 11, 2015, at 11:06 PM, Terry Wilson wrote:>>=20>> I'd really to see the sort parameters in [search] sort regardless of the s=pecified number. How do I explain this.>>=20>> &fieldAsort=3D1&fieldBsort=3D2&fieldCsort=3D3&fieldDsort=3D4>>=20>> But I only need fieldA to lead the sort for one condition. So unless that= comes up, I just hide fieldAsort=3D1 like so:>>=20>> [showif [specialcase]=3Dt]&fieldAsort=3D1[/showif]&fieldBsort=3D2&fieldCs=ort=3D3&fieldDsort=3D4>>=20>> This comes up from time to time, and actually right now it's coming up fo=r me again and as usual, I have to showif/hideif the entire sort string for e=ach condition instead of just slipping in the one that I need for certain ca=ses.>>=20>> [showif [specialcase]=3Dt]&fieldAsort=3D1&fieldBsort=3D2&fieldCsort=3D3&f=ieldDsort=3D4[/showif]>> [hideif [specialcase]=3Dt]&fieldBsort=3D1&fieldCsort=3D2&fieldDsort=3D3[/=hideif]>>=20>> kind of a pain in the ass when you're still deciding what to best sort on= - now you have 2 places to futz with as you refine.>>=20>> Bonus points to also let those numbers be decimal. Let's say sometimes yo=u need an additional sort in the middle. Throw a showif on fieldZsort=3D2.5 a=s needed:>>=20>> &fieldAsort=3D1&fieldBsort=3D2&fieldZsort=3D2.5&fieldCsort=3D3&fieldDsort==3D4--------------------------------------------------------->> This message is sent to you because you are subscribed to>> the mailing list .>> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us>> Bug Reporting: support@webdna.us>=20> ---------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us> Bug Reporting: support@webdna.us
Terry Wilson
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:
[protect admin] (1997)
[Fwd: Rotating Banners ... (was LinkExchange)] (1997)
Interesting speed comparison .. (2003)
Fun with Dates - finally resolved but.... (1997)
Help name our technology! (1997)
Preserving file creation dates on [copyfile] (2007)
RAM problems, [appendfile] problems (1998)
includes and cart numbers (1997)
[WebDNA] OT: Issue with some clouds (2009)
pop up menu's (1998)
delete some html code (2007)
Stopping bad HTML propagation ? (1997)
ShowNext - This is Killing me! (1998)
[WebDNA] User sessions - cookies only or cookies and a (2016)
$Quit, $CloseDatabase corrections (1997)
Why do extra quotation marks sometimes appear in my databases? (1998)
Summing fields (1997)
oddball sorting problem (2003)
[WebDNA] cron - curl to replace triggers.. (2009)
Help name our technology! (1997)