Inventory utilizes OpenSearch while FQM utilizes PostgreSql. Functional differences between inventory search and FQM should be noted so documentation can be provided to end users.

Similarly constructed queries for Instances in Inventory often return different results than queries from FQM. We need to investigate and determine what, if any, issues are present. Based on the findings, we can determine if any issues need to be resolved in a future release. By not addressing account counts and results, we risk customers becoming frustrated with Lists and Bulk Edit apps.

Questions/items to investigate:

• In FQM, the ‘CONTAINS’ operator is a regex search that looks for substring matches. is there an equivalent way to search for a substring that’s anywhere within the title in inventory?

• by default, does inventory do any filtering of results?

• are the FQM/inventory queries using the same indexes?

• are there alternative ways to query in inventory to get a more similar result set? if so, document details

  • basic or advanced search

  • operator(s) used

  • wildcards or truncation

• are there alternative ways to query in FQM to get a more similar result set?

The following examples are from the Quesnelia bugfest environment