Sort found set by first field then second field

Discussion created by cillion on Aug 5, 2016
Latest reply on Aug 17, 2016 by cillion

Hi there!

Am trying to sort a found set after when search string has been found in first field and then in a second field. Example: when searching for "filemaker" the result should be sorted by "found in current_employer" first and then "found in previus_employer" after. How could this be done?


The search is working as expected, but not the sort.


my search script has one sort records at the end where I sort by current_employer ASC and previus_employer ASC. and that does almost do the job but some record show up at the bottom where the current_employer="filemaker"