QuickBooks Integrator 2020 iOS Edition

Questions / Feedback?

ObjSearch Class

Properties   Methods   Events   Configuration Settings   Errors  

ObjSearch is used to search the QuickBooks database.

Syntax

InQBObjSearch
InQBObjSearchSwift

Remarks

ObjSearch is used to search the QuickBooks database. When ObjSearch is called a QuickBooks search is initiated using the specified search filters.

Example (Querying for Invoices)

ObjSearch1.QueryType = qtInvoiceSearch
ObjSearch1.TransactionDateStart = "10/01/2002"
ObjSearch1.EntityName = "Joe Reckless"
ObjSearch1.PaidStatus = psUnpaid
ObjSearch1.Search()
Invoice1.QBResponseAggregate = ObjSearch1.ResultAggregate(0)
Invoice2.QBResponseAggregate = ObjSearch1.ResultAggregate(1)
' etc.
ObjSearch may only be used to search for one type of object at a time. The type of search should be specified in QueryType before beginning the search. The maximum number of returned objects may also be specified in MaxResults.

The search may be executed by calling the Search method. After Search is called ResultCount will hold the number of results, ResultId will hold the Ids returned and ResultAggregate will hold information for the objects returned. To instantiate an object, set its QBResponseAggregate property to the appropriate ResultAggregate.

One or more search filters may be specified. These filters limit the search to records meeting specified criteria. If no filters are specified, ObjSearch will return all objects in the database, up to the limit specified by MaxResults.

The following filter may be specified in all searches:

ModifiedDate FilterLimits the search to records last modified before/after specified dates. One or both of ModifiedDateStart and ModifiedDateEnd may be specified.

The following filters may be specified when searching for entities (a Customer, Vendor, or Employee). The Name filter may also be specified for Item searches.

Name FilterLimits the search based on the name of the entity. One or both of NameRangeStart or NameRangeEnd may be specified to limit the search to a range of names. Alternatively, one of NameStartsWith, NameEndsWith, or NameContains may be specified.
TotalBalance FilterLimits the search to entities with balances at least TotalBalanceMinimum or at most TotalBalanceMaximum (not defined for Employee).

The following filters may be specified when searching for transactions:

RefNumber FilterLimits the search based on the RefNumber (i.e., check number, invoice number, etc.) of the transaction. One or both of RefNumberRangeStart or RefNumberRangeEnd may be specified to limit the search to a range of RefNumbers. Alternatively, one of RefNumberStartsWith, RefNumberEndsWith, or RefNumberContains may be specified.
TransactionDate FilterLimits the search to transactions with a date before or after specified dates. One or both of TransactionDateStart and TransactionDateEnd may be specified.
Entity FilterLimits the search to transactions associated with the entity specified by EntityName.
Account FilterLimits the search to transactions associated with the account specified by AccountName.

Note that for TimeTracking searches the Account and RefNumber filters are not used.

The following additional filter may be specified for Bill and Invoice objects.

PaidStatus FilterLimits the search either to paid or unpaid bills or invoices only, as specified in PaidStatus.

The additional filters may be specified for Item objects.

Name FilterLimits the search based on the name of the item (see above).
ItemType FilterLimits the search to the type of item specified by ItemType.

Property List


The following is the full list of the properties of the class with short descriptions. Click on the links for further details.

- includeLineItemsIndicates whether to include line items in the response.
- includeLinkedTxnsIndicates whether to include linked transactions in the response.
- iterateResultsIndicates whether to perform iterative searches when QBXMLVersion = 5.0 or greater.
- maxResultsThe maximum number of results to be returned from a search.
- QBConnectionStringAn aggregate consisting of various QuickBooks connection properties.
- QBRequestAggregateThe request aggregate.
- QBRequestModeDefines whether the request is made online or stored offline.
- QBResponseAggregateThe last QBXML response aggregate received from QuickBooks.
- QBXMLVersionThe version of QBXML used in the outgoing message.
- queryTypeThe type of search to perform.
- remainingResultsIndicates the number of results left in an iterative search.
- resultCountThe number of records in the Result arrays.
- resultAggregate:(int)resultIndexXML response aggregate returned from QuickBooks.
- resultId:(int)resultIndexId of the result aggregate stored in Aggregate .
- resultName:(int)resultIndexName of the result aggregate stored in Aggregate .
- retrieveNamesOnlyReturn only the names and Ids in the results.
- accountIdAn account name to search for in a transaction.
- accountNameAn account name to search for in a transaction.
- accountTypeSearch by the type of QuickBooks account.
- activeStatusLimits the search to active or inactive records only.
- entityIdLimits the search to transactions associated with the entity specified by EntityId .
- entityNameAn entity name to search for in a transaction.
- itemTypeThe type of item to search for.
- modifiedDateEndLatest modified date to search for.
- modifiedDateStartEarliest modified date to search for.
- nameContainsString which names are to contain.
- nameEndsWithString which names are to end with.
- nameRangeEndEnding point of a name range.
- nameRangeStartStarting point of a name range.
- nameStartsWithString which names are to start with.
- paidStatusLimits the search to paid or unpaid transactions only.
- refNumberExact RefNumber to search for.
- refNumberContainsString which RefNumbers are to contain.
- refNumberEndsWithString which RefNumbers are to end with.
- refNumberRangeEndEnding point of a RefNumber range.
- refNumberRangeStartStarting point of a RefNumber range.
- refNumberStartsWithString which RefNumbers are to start with.
- totalBalanceMaximumA maximum balance which returned records should have.
- totalBalanceMinimumA minimum balance which returned records should have.
- transactionDateEndLatest transaction date to search for.
- transactionDateStartEarliest transaction date to search for.
- specialQueryTypeThe special query type; for example ItemService.

Method List


The following is the full list of the methods of the class with short descriptions. Click on the links for further details.

- closeQBConnectionCloses a persistent connection to QuickBooks.
- configSets or retrieves a configuration setting.
- getNextResultsRetrieves the next set of results (only applicable for iterative searches).
- importQBXMLImports a QBXML response aggregate.
- openQBConnectionOpens a persistent connection to QuickBooks.
- resetResets all properties to their defaults.
- searchSubmits a query request to QuickBooks.

Event List


The following is the full list of the events fired by the class with short descriptions. Click on the links for further details.

- onErrorInformation about errors during data delivery.
- onSSLServerAuthenticationFired after the server presents its certificate to the client.
- onSSLStatusShows the progress of the secure connection.
- onStatusShows the progress of the QuickBooks connection.
- onWarningFired when a warning occurs.

Configuration Settings


The following is a list of configuration settings for the class with short descriptions. Click on the links for further details.

AuthFlagsConnection Flags (use for QuickBooks Simple Start).
CurrencyIdFilters results by indicated currency.
CurrencyNameFilters results by indicated currency.
DateSearches by exact date.
DeletionTypeThe type of list or transaction from which a member has been deleted.
EnforceMaxLengthIndicates whether to enforce max lengths for QB Fields.
FindWithChildrenInclude children in the results of an entity Name or Id search.
GetHighestVersionHighest QBXMLVersion supported by the installed instance of QuickBooks.
GetRequestProcessorDLLVersionReturns the version of the QB Request Processor that is installed on your system.
GetSupportedVersionsReturns a list of QBXMLVersions that are supported by QuickBooks.
IsReadOnlyThis causes the QuickBooks authorization dialog to display text informing the user that its access will be read-only.
MetaDataTypeControls whether a count of results is returned or not.
ModifiedDateRangeFilterNameThe ModifiedDateRangeFilter tag name to be used in the request.
PersonalDataPrefWhether the connecting application will require access to personal data such as SSN or credit card information.
QBConnectionModeThe mode of connection to QuickBooks.
QBFileStatusThe status of the company file as it pertains to accepting connections.
QBOpenCompanyFileThe file currently open in QuickBooks.
ResultCountA count of results returned via QuickBooks' metaData attribute.
SSLAcceptServerCertThe SSL certificate being used by the Remote Connector.
SSLAcceptServerCertFileThe SSL certificate file being used by the Remote Connector.
StopOnErrorSpecifies how QuickBooks is to proceed if an error occurs in processing of the current request.
TotalBalanceThe balance which returned records should have.
TxnDateRangeFilterNameThe TxnDateRangeFilter tag name to be used in the request.
UnattendedModePrefWhether connecting while QuickBooks is closed is required or optional for the user.
WarningCodesA comma-separated list of QuickBooks warning codes that should not result in an exception.
BuildInfoInformation about the product's build.
CodePageThe system code page used for Unicode to Multibyte translations.
LicenseInfoInformation about the current license.
ProcessIdleEventsWhether the class uses its internal event loop to process events when the main thread is idle.
SelectWaitMillisThe length of time in milliseconds the class will wait when DoEvents is called if there are no events to process.
UseInternalSecurityAPITells the class whether or not to use the system security libraries or an internal implementation.

Copyright (c) 2021 /n software inc. - All rights reserved.
QuickBooks Integrator 2020 iOS Edition - Version 20.0 [Build 7941]