How does ObjectSight perform queries?
Queries are performed using the TSQLFilterList and TSQLFilter objects that are always available to Business Objects and Business Object Datasets. The TSQLFilterList will support any complex query including sub queries, ANDing logic, and ORing logic. The Add[DataType]Filter methods such as AddIntFilter allow for the specification of filters on the TosDataset Load or Append operation and on the TosDbRecord Fetch operation. The filters are converted to SQL WHERE clauses during Load, Append and Fetch operations. The following complex query uses two date filters and a subquery using the AddFreeFilter method to load requests that are DUE today lsViewRequests.AddDateFilter(loAnd, ncreqtDueOn, opGE, Date, True); lsViewRequests.AddDateFilter(loAnd, ncreqtDueOn, opLT, Date + 1, True); lsViewRequests.AddFreeFilter(loAnd, ncreqtRequestStatusCd, opIn, ‘(SELECT rs.request_status_cd from request_states rs WHERE rs.request_type_cd = reqt.request_type_cd AND rs.request_status_cd = reqt.request_status_c