go back Home

QueryBuilder

Sample XML

The following is only an example of what the XML should look like. The order of fields is not guaranteed and null fields are not included in returned data from the services.

<null aliasName="..." allIndexes="..." allMetaData="..." allowLimitedFieldList="..." boolean="..." boolean="..." boolean="..." currency="..." currency="..." currency="..." dBDriver="..." database="..." databaseCapabilities="..." databaseInfo="..." date="..." date="..." date="..." dateTime="..." dateTime="..." dateTime="..." decimal="..." decimal="..." decimal="..." distance="..." distance="..." field="..." field="..." fieldCount="..." fieldList="..." float="..." float="..." float="..." forExpression="..." groupBy="..." indexes="..." int="..." int="..." int="..." log="..." manualRowArray="..." metaData="..." metaData="..." numRecordsRead="..." orderBy="..." overrideCompany="..." recordCount="..." recordNumber="..." row="..." rowClass="..." sql="..." sqlString="..." string="..." string="..." string="..." tableDescriptor="..." tableForField="..." tableName="..." tableNames="..." tablespaces="..." time="..." time="..." time="..." transactionsIgnored="..." uniqueTransactionId="..." userName="..." whereClause="..."/>

Sample JSON

The following is only an example of what the JSON should look like. The order of fields is not guaranteed and null fields are not included in returned data from the services.

{"aliasName":"...","allIndexes":"...","allMetaData":"...","allowLimitedFieldList":"...","boolean":"...","currency":"...","dBDriver":"...","database":"...","databaseCapabilities":"...","databaseInfo":"...","date":"...","dateTime":"...","decimal":"...","distance":"...","field":"...","fieldCount":"...","fieldList":"...","float":"...","forExpression":"...","groupBy":"...","indexes":"...","int":"...","log":"...","manualRowArray":"...","metaData":"...","numRecordsRead":"...","orderBy":"...","overrideCompany":"...","recordCount":"...","recordNumber":"...","row":"...","rowClass":"...","sql":"...","sqlString":"...","string":"...","tableDescriptor":"...","tableForField":"...","tableName":"...","tableNames":"...","tablespaces":"...","time":"...","transactionsIgnored":"...","uniqueTransactionId":"...","userName":"...","whereClause":"..."}

Fields

name type
aliasName String
allIndexes Hashtable
allMetaData Hashtable
allowLimitedFieldList boolean
boolean boolean
boolean boolean
boolean boolean
currency Currency
currency Currency
currency Currency
dBDriver DBDriver
database Database
databaseCapabilities DatabaseCapabilities
databaseInfo DatabaseInfo
date Date
date Date
date Date
dateTime Date
dateTime Date
dateTime Date
decimal BigDecimal
decimal BigDecimal
decimal BigDecimal
distance Distance
distance Distance
field Field
field Field
fieldCount int
fieldList StringList
float double
float double
float double
forExpression String
groupBy StringList
indexes TableIndex[]
int int
int int
int int
log Log
manualRowArray ReadOnlyRow[]
metaData QueryMetaData
metaData QueryMetaData
numRecordsRead int
orderBy StringList
overrideCompany String
recordCount int
recordNumber int
row ReadOnlyRow
rowClass Class
sql SelectStatement
sqlString String
string String
string String
string String
tableDescriptor TableDescriptor
tableForField String
tableName String
tableNames String[]
tablespaces Hashtable
time Date
time Date
time Date
transactionsIgnored boolean
uniqueTransactionId String
userName String
whereClause StringList