Thanks Tommy,
I used your implementation with a few variations:
1. I use db.FTSearch
2. Instead of text field for search criteria, I use a few combobox for criteria selection(Division, Originator, Description and Status)
I had problems with the array field definition, specifically with the "formula"
type since it only allows simple funcions like @Created, @Modified.
Sometimes you need a @if on there. What I did was to compute the formula
in the computed field on Data table control.
The only issue I see with this approach is that sorting is done on the data you have on screen; for example:
You are on page 1 of 5 and you sort by Date everything works fine, but
if you are on Page 2 and you try to sort using a different column then
sorting is done on that page; it should go to page 1 and make the sort
from there.
Thanks for sharing this elegant solution.
Pablo