Overview: Implementation of Advanced search in Inventory will support search using boolean operators. The Advanced Search modal is already implemented in the MARC Authority app (https://folio-snapshot.dev.folio.org/marc-authorities). Elasticsearch does support search across all record types in Inventory (Instance, Holdings, Item - )

In scope:

• Advanced search modal in Inventory search on Instance / Holdings / Item toggles

Out of scope:

• Selecting record type in modal

• Use case: A staff user want to combine searches across all one or two record types, and have more advanced search options than provide with the simple Search and filter screen; one example is be able to mix item material type search with an instance search.

Requirements (see attached mockup):

• Add new "Advanced search" button to the right of the "Reset all" button for Instance, Holdings, and Item toggles

• Add boolean operator dropdown for AND, OR, and NOT

• Include all search options (with the exception of Query search)

• Additional dropdown that supports: starts with, exact phrase, and contains all and contains all should be the default value in the dropdown

Scenarios:

1. Scenario - Modal

   • Given the user is in the Inventory app and

   • When the user selects the "Advanced search" button to the right of the "Reset all" button

   • Then the Advanced search modal should appear

2. Scenario - Modal options

   • Given the user has selected the "Advanced search" button to the right of the "Reset all" button

   • When the Advanced search modal appears

   • Then the modal should contain 6 rows of four fields:

     • Boolean operator dropdown

     • Search for term

     • Search type

     • Search field

3. Scenario - AND operator

   • Given the user has selected the Advanced search button and the Advanced search modal appeared

   • When the user uses the AND operator

   • Then the search query should return Instances that meet both criteria

4. Scenario - OR operator

   • Given the user has selected the Advanced search button and the Advanced search modal appeared

   • When the user uses the OR operator

   • Then the search query should return Instances that meet any of the criteria

5. Scenario - NOT operator

   • Given the user has selected the Advanced search button and the Advanced search modal appeared

   • When the user selects the NOT operator

   • Then the search query should return Instances that do not meet the entered criteria

6. Scenario - Starts with 

   • Given the user has selected the Advanced search button and the Advanced search modal appeared

   • When the user selects the Starts with search type

   • Then the search query should return Instances that match the left-anchored search term

7. Scenario - Exact match

   • Given the user has selected the Advanced search button and the Advanced search modal appeared

   • When the user selects the Exact phrase search type

   • Then the search query should return Instances that exactly match the search term entered

8. Scenario - Contains

   • Given the user has selected the Advanced search button and the Advanced search modal appeared

   • When the user selects the Contains type

   • Then the search query should return Instances that contain the entered search term 

Additional Information:

• Mockup: 1-inventory-advanced-search-modal.png

• Spike: https://folio-org.atlassian.net/wiki/pages/viewpage.action?pageId=1400532 

• Authority control advanced search modal: https://folio-org.github.io/stripes-components/?path=/story/components-advancedsearch--with-custom-query-builder