Hi
What is your solutions to display your search lists by relevance please ?
For instance if you have a field1 in the search tab with the PERMISSIVE search criterion on it , if you type in 'ref' in the search form , the list will display:
1ref
ref
ref1
aref
...
but how can we order the list so that the EXACT matching items are displayed first and the LIKE matching items are displayed after to give :
ref
1ref
ref1
aref1
in other words, how can we define the ORDER BY SQL statement ?
thanks
Cyril