You can construct a query SQL statement to query data from a local database. You can create a TestCriteria object (in this example, AttributeTest) to filter results. You can also query across multiple tables (MBOs) when using the executeQuery API.
Query query2 = new Query(); query2.select("c.fname,c.lname,s.order_date,s.region"); query2.from("Customer", "c"); // // Convenience method for adding a join to the query // Detailed construction of the join criteria query2.join("Sales_order", "s", "c.id", "s.cust_id"); AttributeTest ts = new AttributeTest(); ts.setAttribute("fname"); ts.setValue("Beth"); query2.where(ts); QueryResultSet qrs = SMP101DB.executeQuery(query2);