Abstract: Provide a system for automatically building a query statement for a database. The system includes an electronic processor. The electronic processor is configured to provide a user interface displayed by a display device and including a plurality of tabs. The electronic processor is also configured to provide a first list of a plurality of data fields included in the database. The electronic processor is configured to receive, via the user interface, a first selection of one of the plurality of data fields from the first list and a second selection of a criterion for one of the plurality of data fields from the first list. The electronic processor is configured to automatically build the query statement for the database. The electronic processor is further configured to execute the query statement on the database and output results of executing the query statement.

Abstract: A non-transitory computer readable medium storing instructions that, when executed by an electronic processor, perform a set of functions. The set of functions include extracting a report including a markup language document from a system. The set of functions also includes, for each of a plurality of processing tasks, determining whether the markup language document includes a path contained in a virtual table assigned to the processing task. The set of functions also includes, in response to the markup language document including the path contained in the virtual table, extracting data from the markup language document and executing the processing task to manipulate and queue the data for insertion into the combined database. The set of functions further includes, in response to each of the plurality of processing tasks completing without failure, inserting the data queued into one or more tables included in a database.

Abstract: A non-transitory computer readable medium storing instructions that, when executed by an electronic processor, perform a set of functions. The set of functions include extracting a report including a markup language document from a system. The set of functions also includes, for each of a plurality of processing tasks, determining whether the markup language document includes a path contained in a virtual table assigned to the processing task. The set of functions also includes, in response to the markup language document including the path contained in the virtual table, extracting data from the markup language document and executing the processing task to manipulate and queue the data for insertion into the combined database. The set of functions further includes, in response to each of the plurality of processing tasks completing without failure, inserting the data queued into one or more tables included in a database.

Abstract: Provide a system for automatically building a query statement for a database. The system includes an electronic processor. The electronic processor is configured to provide a user interface displayed by a display device and including a plurality of tabs. The electronic processor is also configured to provide a first list of a plurality of data fields included in the database. The electronic processor is configured to receive, via the user interface, a first selection of one of the plurality of data fields from the first list and a second selection of a criterion for one of the plurality of data fields from the first list. The electronic processor is configured to automatically build the query statement for the database. The electronic processor is further configured to execute the query statement on the database and output results of executing the query statement.