Query in Multiple Categories |
Scroll |
TheMultiQuery allows you to specify and execute queries in multiple categories. It can be seen as a list of TheQuery objects returning a list of TheQueryResult objects. .
1 |
Connect to the Thereforeâ„¢ server (see "Server - Connect and Disconnect" for Details) |
2 |
Declare and initialize a new TheMultiQuery. |
3 |
Create and add two or more queries (see "Query in One Category" for more details on query specification). |
4 |
Execute the multi-query on the server. |
5 |
Optional. Display multi-query definition and results. |
Requirements and Assumptions: Category number 4. Category number 5 with string fields named "Supplier" and "InvoiceNo". At least one document in each category matching the search criteria for that category. If these assumptions do not apply to your system or configuration please replace them with appropriate values when copying the code samples below. |
Advanced SQL Features Advanced SQL features such as grouping and joining tables are not yet supported by the Thereforeâ„¢ system.
Performance Note Combining several TheQuery instances in an TheMultiQuery and executing them together is more efficient than executing the queries individually. |