How can I display Found Records sorted by Relevance?

[Daniel_T]

Hello, I have a web page that makes a find request to a articles DB using a single text field, the value of this field is used to find the articles in the database. I thought that if I captured this value I could then do a calculation field that could give me the number of occurrences of the search term, this could be done with a PatternCount function, and this way I could sort the found articles by their relevance. How can I do this? I have not found a function to catch the current search word. I thought there was a CurrentParthArgs or something with web companion but I can't seem to find it. If you do a Find at the FileMaker web site it brings results with a "Relevance Percentage" Does somebody know how they did it?. Please Help!

Best Wishes,

Daniel T.

[Keith M. Davie]

Not sure what "articles" you are talking about, not that it matters that much.

You say you are searching a single text field. And you want to sort the found articles by their relevance. Not quite sure I follow this. So let me put it a different way, which may shed some light on your problem.

Recently had to work with a db which had a field "category" which had various items described by check boxes and which showed through a second field whether or not the items were available. Was able to create another layout in which the category field showed the checked category as text and the status field also displayed text which had been selected by radio buttons so I could search for "category" and "in" through an exact search of two fields (and not display articles which were out of stock).

This allowed the table display of the found records, which I limited to a -max=5 and then connected with the fmp-linknext and fmp-linkprevious tags.

You may find you need to take a slightly different approach to your database such that you can find by one or two fields and sort by a field which ascends or descends to your "relevance"

Hope you find this suggestion useful.

Peace

Keith M. Davie