HCL Notes and Domino 9.0 Social Edition Forum - View Search for Multi-Value Field

Aug 7, 2015, 11:02 AM

48 Posts

re View Search for Multi-Value Field

Hi Andrew

Have you created a Full test index for the database ?

Once the Database FTI is created you can expand your search options

The Database must have a full-text index to be searchable using conditions.

When you add a condition to a search query in the More section of search, it focuses your search on more specific results. For example, you can specify that you want to find only documents that have a particular number in a particular field, or that contain certain specified words.

When you add a condition to a search query, it appears as a "token" in the Search field. To edit an existing condition in the search field, click the token twice to open the dialog box for the condition. To delete a condition, click the token once to select it, then press Delete.

To add a condition to a search query, follow these steps:

Open the application view you want to search.
Click the search drop-down arrow and then click More Searches > Search This View.
Click the More twistie in the Search in View form.
Click one of the following buttons to specify the condition you want to use:

Table 1. Search query condition options Condition
Description

Date
Focuses your search on documents that were created or modified according to a specific date or time period.

Author
Focuses your search on documents that were created or modified (or not created or modified) by the specified author(s). This condition searches the $UpdatedBy field.

Field
Focuses your search on documents that contain specified text, numbers, or a date in a particular field.

Form
Focuses your search on documents that were created using one of the forms listed. This condition is most useful when searching in a view that contains several different forms.

Multiple words
Focuses your search on documents that contain (or do not contain) specified terms.

Example form
Focuses your search on documents that contain specified values in fields in an example form.

Hope this helps !

~Mary Zentoovitchikle

Aug 7, 2015, 9:03 PM

4 Posts

Re: View Search for Multi-Value Field

G'day Tom,

Yes. I have done all that. It has a FT index and I am already trying to search by field. That's how I got the "DatesSighted is on 25/07/2015" token. It works fine for a single value field but does not work for the multiple value field as per my original post.

Even though it is a multiple value field there's no option for "contains" only the regular date options "is on", "is before", etc.

~Mary Zentoovitchikle

Aug 8, 2015, 6:03 AM

4 Posts

A workaround

I'd still like an answer to my original question but I have come up with a workaround.

I created an extra field on the form "DatesSightedText". It is a text field that is computed using the formula @Text(DatesSighted). It gives me a text field that I can search using "contains". Not great but at least it works.