Query in Multiple Categories

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:

bullet Category number 4. Category number 5 with string fields named "Supplier" and "InvoiceNo".

bullet 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.

Visual Basic

Imports Therefore.API

'...

' 1. Connect to the Therefore™ server

Dim server As New TheServer

server.Connect(TheClientType.CustomApplication)

' 2. Create a new multi-query

Dim multiQuery As New TheMultiQuery

' 3. Create and add two or more queries

Dim query As New TheQuery

query.Category.Load(5, server)

query.SelectFields.AddAll()

query.Conditions.Add("Supplier", "A*")

query.OrderByFields.Add("InvoiceNo")

multiQuery.Add(query)

Dim query2 As New TheQuery

query2.Category.Load(4, server)

query2.SelectFields.AddAll()

multiQuery.Add(query2)

' 4. Execute the multi-query

Dim multiResults As TheMultiQueryResult = multiQuery.Execute(server)

' Optional 5. Display multi-query definition and results in MessageBox

System.Windows.Forms.MessageBox.Show( multiQuery.ToString() _

+ vbNewLine + "---------------------------------------------------" _

+ vbNewLine + vbNewLine + multiResults.ToString() )

C#

using Therefore.API;

//...

// 1. Connect to the Therefore™ server

TheServer server = new TheServer();

server.Connect(TheClientType.CustomApplication);

// 2. Create a new multi-query

TheMultiQuery multiQuery = new TheMultiQuery();

// 3. Create and add two or more queries

TheQuery query = new TheQuery();

query.Category.Load(5, server);

query.SelectFields.AddAll();

query.Conditions.Add("Supplier", "A*"); // using the column

query.OrderByFields.Add("InvoiceNo");

multiQuery.Add(query);

TheQuery query2 = new TheQuery();

query2.Category.Load(4, server);

query2.SelectFields.AddAll();

multiQuery.Add(query2);

// 4. Execute the multi-query

TheMultiQueryResult multiResults = multiQuery.Execute(server);

// Optional 5. Display multi-query definition and results in MessageBox

System.Windows.Forms.MessageBox.Show (multiQuery.ToString()

+ "\r\n---------------------------------------------------\r\n\r\n"

+ multiResults.ToString());

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.

TheDocument class

TheDocument.Archive method

TheDocument.Retrieve method

TheDocument.View method

TheServer class

Therefore Programming Interface 3.0