Complex filter query of multiple data sets

A non-transitory computer-readable storage medium containing instructions, that when executed, control a computer system to be configured for:

• receiving input for a complex query for a worksheet of entries, the complex query including components that are arranged in a hierarchical structure including a first type of filter and a second type of filter and are connected by a plurality of types of connectors;
• processing the complex query, wherein processing the complex query performs:
• generating, based on the second type of filter, a second data set by processing a first data set, the second data set including outcomes from processing the first data, the outcomes not appearing in the first data set,
• selecting first data from the first data set and selecting second data from the second data set for the components,
• applying the first type of filter to the first data set and the second type of filter to the second data set for the components, wherein the outcomes are used by the second type of filter to filter entries in the worksheet and first type of filter filters entries in the worksheet based on column values in the first data set, and
• combining outputs of the components using the plurality of types of connectors.

An apparatus comprising:

• one or more computer processors;
• and
• a non-transitory computer-readable storage medium comprising instructions, that when executed, control the one or more computer processors to be configured for:
• receiving input for a complex query for a worksheet of entries, the complex query including components that are arranged in a hierarchical structure including a first type of filter and a second type of filter and are connected by a plurality of types of connectors;
• processing the complex query, wherein processing the complex query performs:
• generating, based on the second type of filter, a second data set by processing a first data set, the second data set including outcomes from processing the first data set, the outcomes not appearing in the first data set,
• selecting first data from the first data set and selecting second data from the second data set for the components,
• applying the first type of filter to the first data and the second type of filter to the second data for the components, wherein the outcomes are used by the second type of filter to filter entries in the worksheet and first type of filter filters entries in the worksheet based on column values in the first data set, and
• combining outputs of the components using the plurality of types of connectors.