Jump to content

re-sort found set?


This topic is 8351 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

  • Newbies

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. frown.gif" border="0

Link to comment
Share on other sites

  • Newbies

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 ]

Link to comment
Share on other sites

  • 5 weeks later...

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.

Link to comment
Share on other sites

This topic is 8351 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.