Problems with VOLT Filters - "Error: Failed to fetch the forms" and general searching

We keep getting the error - "Failed to fetch the forms" when our search criteria use a date field.

For example:

  • where date field after 01/01/2020
  • where date field between 01/01/2019 and 01/01/2020

We can create Filters on TEXT and Dropdown fields (Although it would be helpful if the filter prompted the user for options available to search for when it’s a dropdown field)

**Note** We imported records into the Volt applications from a spreadsheet.

Not all records imported have dates (the date column was left empty on multiple rows). When we check the field type with the HCL Notes client, the field is showing as TEXT where cell imported were blank and where a date has been imported they are correctly showing as DATE/TIME fields. (Unsure if this is related to the problem).

Also related to filters, is it possible to search a MULTI-LINE-TEXT field where it 'CONTAINS' a particular value, filters only offer 'Equals' or 'Does Not Equal' and Wildcards don't seem to work. Would be great if we could add a search bar like the Notes Client.

We have Domino 11.x installed on Windows with Volt 1.0.1.

Thanks in advance for any suggestions...

We've upgraded to Volt 1.0.2.9, this has fixed the date search issue.

Also in the features list for 1.0.2.9 it states that 'Added a new "contains" search operator option', however post upgrade we can't find this. Any ideas?

https://support.hcltechsw.com/csm?id=kb_article&sysparm_article=KB0077974&sys_kb_id=f47651e11b0ed01c086dcbfc0a4bcb20

Kind regards

The "contains" operator requires a full text index. Edit your application and go to the Settings tab. Check the box labeled "Create full-text index". Then save and deploy your application.

Now when you go to the View Data page and click Create Filters, you should see "Contains word" in the list of operators.

Thankyou David

I'd thought it would need a full-text Index, so I'd already created one from the database properties via the Notes Client.

Deleted this, then let Volt recreate by checking 'Create full-text index' in the settings tab of the application.

Make sure you install Domino 11.0.1 FP2 - this contains a fix which enables the Domino Full Text Search to currently identify field types (Text, Number & Dates)

Kind regards

Kevin Lee