re-sort found set?

[eivind]

I have a tracking database have quite many records and fields, and the information is edited frequently.

Is there a way to include links/buttons in the column header of search_results.htm, so the users can re-sort the "found set" on different fields by just one click?

Thanks,

baktus

[Keith M. Davie]

Yes. One way is that you can provide a button through either a form action or a link action using the cdml "-sort" action tag to perform the task you require. The results page can be the page you are currently viewing or a duplicate of that page, or a page which is formatted differently.

[eivind]

Thanks,

I tried that, but it returns the full database sorted correctly, and not the same, shorter list (eg. "found set") according to the users original search criteria. How do I operate on the same "found set" ?

I may need to get hold of the search criteria / URL used to bring up the search_results.htm the first time, and re-apply the criteria with a different sort parameter.. but I haven't found a way to capture those criteria.

[eivind]

Thanx again, Keith, the following works:

In the header of my tabulated search_results.htm, I put the following link to re-sort the found set using "RPN":

code:

---

<A HREF="FMPro?-db=checklist.FP3&-lay=Layout%20%231

&-format=search_results.htm

[FMP-CurrentFind]

&-OP=[FMP-FindOpItem : short]

&[FMP-FindFieldItem]=[FMP-FindValueItem]

[/FMP-CurrentFind]

&-Max=All&-SortField=RPN

&-SortOrder=descending&-Find">RPN</A></B>

---

[ August 09, 2001: Message edited by: Baktus ]

[ August 09, 2001: Message edited by: Baktus ]

[Keith M. Davie]

Nice of you to post what worked for you. It may be of benefit to others. Thanks.

[Vaughan]

The [FMP-Link] CDML tag is used to perform magic like this. The Link tag reproduces the url that produced the current web page: you use CDML parameters to omit parts of the url and substitute new parts.

To re-sort a list of results you use

[FMP-Link: sa]&-sortfield=xxx&-sortorder=ascending&-Find

Much simpler, isn't it.

For the full info, see the CDML reference.