Hello everyone

I have had created a jewellery database which currently contains approx 10,000 records.

I am having trouble completing a certain find, and I show an example below:

Cluster rings are entered into the database in the following fashion:

7st diamond cluster

9st diamond cluster

7st sapphire and diamond cluster

13st ruby and diamond cluster

etc etc

If I want to just find all the diamond clusters searching for diamond cluster doesn't work as it will find the ruby and sapphire rings too. Searching on literal text "7st diamond cluster" doesn't work because it omits the 9st rings and searching for literal text "st diamond cluster" returns no results.

Can anyone advise how I should word my find to get the results I want. I would prefer not to have to any refining of an initial find.

Many thanks

Milt

How about "7st diamond cluster" NEW REQUEST "9st diamond cluster" and find. New requests allow for OR finds, Find this OR this.

The best thing you could do is to reorganize your data to comply with the "one fact per field" rule, so that you have separate fields for weight, product type and materials used (the last one could be a checkbox field). Without this, finding anything will be awkward at best.

Based on you example alone, you could find diamond-only clusters by searching for [color:blue]diamond cluster and adding a request to omit records containing [color:blue]and.

Or:

searching for literal text "st diamond cluster" returns no results.

If that's a reliable criteria, you should search for:

[color:blue]*"st diamond cluster"

Thanks very much for that - the text is reliable and *"text" was exactly what I was looking for, and it works perfectly.

Many thanks

Milt