Systems and methods for facilitating searches involving multiple indexes

A computer-implemented method for searching a set of objects stored in one or more repositories, the objects being data objects each having an associated identifier value and a unique-identifier value stored in one or more search indexes, the method comprising:

• receiving a query, the query including at least a first set of criteria, a second set of criteria, and one or more logical operators;
• querying a first index based on the first set of criteria to generate a first result, the first result including a first set of first-identifier values;
• querying a second index based on the second set of criteria to generate a second result, the second result including a first set of second-identifier values;
• retrieving, from the second index, a set of unique-identifier values corresponding to the first set of second-identifier values;
• mapping the retrieved set of unique-identifier values to their corresponding first-identifiers in the first index to generate a second set of first-identifier values;
• and
• determining a set of matched objects to be included in a search result based on one or more logical operations performed on the first set of first-identifier values and the second set of first-identifier values, the set of match objects being a unified result generated by joining the first result and the second result.

A computer-implemented method comprising:

• assigning to a plurality of documents stored in one or more repositories a plurality of unique-identifier values, a plurality of first-identifier values, and a plurality of second-identifier values, the plurality of documents comprising content and metadata;
• creating for the plurality of documents a first index comprising a first field, a second field, and a third field, the first field storing a unique-identifier value assigned to a document, the second field storing a first-identifier value assigned to the document, and the third field storing content from the document;
• creating for the plurality of documents a second index comprising a fourth field, a fifth field, and a sixth field, the fourth field storing the unique-identifier value assigned to the document, the fifth field storing a second-identifier value assigned to the document, and the sixth field storing metadata from the document;
• receiving a query comprising at least a first set of criteria, a second set of criteria, and one or more logical operators;
• querying the third field of the first index using the first set of criteria to generate a first result, the first result including a first set of first-identifier values, each of the first set of first-identifier values identifying a document having content that satisfies the first set of criteria;
• querying the sixth field of the second index using the second set of criteria to generate a second result, the second result including a first set of second-identifier values, each of the first set of second-identifier values identifying a document having metadata that satisfies the second set of criteria;
• retrieving, from the second index, a set of unique-identifier values corresponding to the first set of second-identifier values;
• mapping the retrieved set of unique-identifier values to their corresponding first-identifiers in the first index to generate a second set of first-identifier values;
• and
• determining a set of matched objects to be included in a search result based on one or more logical operations performed on the first set of first-identifier values and the second set of first-identifier values.