Re: [WebDNA] reverse rank=off
This WebDNA talk-list message is from 2008
It keeps the original formatting.
numero = 100406
interpreted = N
texte = Webdna isn't really set up to do what you want to do. You are asking to have the results ordered by most relevant, but also my most recent. if you want it by most relevant, then the "rank=off" in your code is fine if you want it ordered by date, then "deskusort=1" would do if you want it ordered by most relevant, but grouped by year then you could do the following: [search db=/forum/db/ l4text.db&wsl4_txt1data=[forumsearch]&deyearsort=1&yearsumm=T][!][/!] [founditems]
[year]
[search db=/forum/db/ l4text .db &wsl4_txt1datarq = [forumsearch ]&eqyeardatarq =[year]&max=[_searchvalue]&rank=off&startat=[start]&allreqd=T] [founditems] search results here... [/founditems] [/search] [/founditems] [/search] However, from a usability point of view, I think I would find that confusing - I either want most relevant or I want most recent, not a mish mash of the two. Why not sort by either rank or date, and then give users the choice to reorder their results with a drop down saying order by: date or relevance TC On 28 Jul 2008, at 18:46, Palle Bo Nielsen wrote: > Can't make it work... > > My search context now looks like this > > [search db=/forum/db/ > l4text > .db > &wsl4_txt1data > = > [forumsearch > ]&max=[_searchvalue]&rank=off&from=end&startat=[start]&allreqd=T] > > The result from execution of the search context look like this... > > http://www.macnyt.dk/forum/?page=forumsearch_result > > If you eg. search for the word powerpalle it should show the result > from 2008 first and the 2007 and 2006... sorry about the speed. More > than 400.000 records (user entries) in this forum database. > > Anyway. I want the result in this order >>> 2008 >>> 2007 >>> 2006 > > Remember it's euro date format. > > Hope for help > > Palle > > > > > On 28/07/2008, at 04.31, Gary Krockover wrote: > >> I believe it should be: >> >> &rank=off&from=end >> >> :) >> >> GJK >> >> At 02:15 PM 7/27/2008, you wrote: >>> Hi all, >>> >>> In a search context you are able to set rank=off which can give a >>> result where the first record ever written in the DB gets first and >>> the last record ends out at the end. >>> >>> How can I reverse this? >>> >>> Unfortunately the DB in this scenario does not have a unique >>> index... > > Venlig hilsen > > Palle Bo Nielsen > (PowerPalle) >
Associated Messages, from the most recent to the oldest:
Webdna isn't really set up to do what you want to do. You are asking to have the results ordered by most relevant, but also my most recent. if you want it by most relevant, then the "rank=off" in your code is fine if you want it ordered by date, then "deskusort=1" would do if you want it ordered by most relevant, but grouped by year then you could do the following: [search db=/forum/db/ l4text.db&wsl4_txt1data=[forumsearch]&deyearsort=1&yearsumm=T]
[!][/!]
[founditems] [year]
[search db=/forum/db/ l4text .db &wsl4_txt1datarq = [forumsearch ]&eqyeardatarq =[year]&max=[_searchvalue]&rank=off&startat=[start]&allreqd=T]
[founditems] search results here... [/founditems] [/search] [/founditems] [/search] However, from a usability point of view, I think I would find that confusing - I either want most relevant or I want most recent, not a mish mash of the two. Why not sort by either rank or date, and then give users the choice to reorder their results with a drop down saying order by: date or relevance TC On 28 Jul 2008, at 18:46, Palle Bo Nielsen wrote: > Can't make it work... > > My search context now looks like this > > [search db=/forum/db/ > l4text > .db > &wsl4_txt1data > = > [forumsearch > ]&max=[_searchvalue]&rank=off&from=end&startat=[start]&allreqd=T] > > The result from execution of the search context look like this... > > http://www.macnyt.dk/forum/?page=forumsearch_result > > If you eg. search for the word powerpalle it should show the result > from 2008 first and the 2007 and 2006... sorry about the speed. More > than 400.000 records (user entries) in this forum database. > > Anyway. I want the result in this order >>> 2008 >>> 2007 >>> 2006 > > Remember it's euro date format. > > Hope for help > > Palle > > > > > On 28/07/2008, at 04.31, Gary Krockover wrote: > >> I believe it should be: >> >> &rank=off&from=end >> >> :) >> >> GJK >> >> At 02:15 PM 7/27/2008, you wrote: >>> Hi all, >>> >>> In a search context you are able to set rank=off which can give a >>> result where the first record ever written in the DB gets first and >>> the last record ends out at the end. >>> >>> How can I reverse this? >>> >>> Unfortunately the DB in this scenario does not have a unique >>> index... > > Venlig hilsen > > Palle Bo Nielsen > (PowerPalle) >
Toby Cox
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:
Navigator 4.01 (1997)
RE: [WebDNA] What does PHP(5) has, that Webdna hasn't (2009)
Mac WebCat 4.0 Day Planner Hang (2000)
OT: auto restart MySQL (2006)
sorting problem for sku=0? (1998)
Colors in cart (2002)
Not really WebCat- (1997)
Interesting speed comparison .. (2003)
2.0Beta Command Ref (can't find this instruction) (1997)
WebCat2 - Getting to the browser's username/password data (1997)
[WebDNA] JSONStore Levels (2020)
[sendmail] and [formvariables] (1997)
WebCat 4.0 (2000)
Running a store on BOTH http and https (1998)
WebDelivery: One step closer !! (1997)
Multiple Merchant Accounts? (1997)
[WebDNA] how to make webroot the start of path (2017)
Version f1 status (1997)
WebSite and *NO* Authentication Dialog Box!!? (1998)
Logging purchases (1997)