Hi all, i've a question about this.
I've a form with 4 fields, (call these A,B,C,D)
i want to implement a search on these fields: user have a text field where can put one or more words (blank separated). The result that i want is all documents in database that has words in A or B or C or D, but words could be also in field A and in B, and so on.
My first choice was to use db.search method in agent, where i specify formula like: @contains(A;words1) | @contains(A;words2).... | @contains(B;words1) | @contains(B;words2)....etc
It works fine, but it's very slow. So i opted to use getAllDocumentsByKey method, that is much quicker, but i've to build a view with all permutations of fields in the column (fields also exploded by " "), and all compbinations of them.
Could someone please explain me if it's correct or if there is a trick to perform this?
Thanks in advance to all....
GetAlldocumentsByKey to search in m... (Andrea D. Bagli... 19.Apr.12)
Feedback number WEBB8THKNE created by Andrea D. Baglioni on 04/19/2012
. . Access (Tamir Ben-Shosh... 19.Apr.12)