Complicated Find

[nelliott]

Users on our database search an Address Field and a CV / Resume field and want to be able to create complicated searches, an example of which is given below:

Address Field: Birmingham OR Coventry OR West Midlands OR Nottingham OR Leicester

CV/Resume Field: Java AND J2EE AND (C++ OR C) NOT Embedded.

Has anybody come up with a simple interface for performing these type of searches

Thanks

Nick

[trevorg]

The way to carry out such a find (without creating an "interface" which could be done through scripting) would be this:

You would need to enter find mode and enter the single city. Then enter the "AND" criteria in the CV field. e.g. ( Java J2EE C++ "C" ) No brackets of course, but the quotes around "C" would be required to find JUST C and not every word that has a c in it.

Then duplicate the request and change the city. (this effectively creates the OR portion)

Then create one more request (CTRL-N) and type "embedded" in the CV field and click the omit button.

[SteveB]

Check John Mark Osborne's site www.databasepros.com . In his Scriptolgy book he has an interface that might get you part of the way there.