complexType SearchBySQLRequest
diagram feature_p92.png
namespace http://www.mapinfo.com/midev/service/feature/v1
type extension of tns:SearchRequest
properties
base   tns:SearchRequest
children tns:SQL tns:TableList tns:BoundParameterList
used by
element   SearchBySQLRequest
attributes
Name    Type    Use    Default    Fixed    Annotation
id    xsd:string    optional         
A unique identifier that is returned in the response. It is used for debugging or keeping track of asynchronous requests.
locale    xsd:string    optional         
The language and country code of the request, which is defined using [language_code]_[country_code] syntax. The language code is a 2-letter ISO-639 code. The country code is a 2-letter ISO-3166 code. For example: en_US stands for the English language within the United States of America.
pageLength    xsd:int    optional         
The maximum number of features to be returned in the resulting feature collection. If this is not specified, the whole response is returned.
pageNumber    xsd:int    optional    1      
The page to be returned. The page is a subset of the entire response and based on the 'pageLength' attribute. The page count begins at 1. For example, if the response normally contains 35 features and the 'pageLength' attribute is set to 8, there will be 5 pages (numbered 1 through 5).
description
A request to perform a search on one or more tables with a MISQL query.

element SearchBySQLRequest/SQL
diagram feature_p93.png
namespace http://www.mapinfo.com/midev/service/feature/v1
type xsd:string
properties
content   simple
description
The MISQL statement to be executed on one or more tables in the request.

element SearchBySQLRequest/TableList
diagram feature_p94.png
namespace http://www.mapinfo.com/midev/service/feature/v1
type tns:TableList
properties
minOcc   0
maxOcc   1
content   complex
children tns:Table
description
A list of tables referenced in the MISQL query. For example, the MISQL string may reference a table on the server with a named table in this list or a feature collection included in the request with a memory table in this list.

element SearchBySQLRequest/BoundParameterList
diagram feature_p95.png
namespace http://www.mapinfo.com/midev/service/feature/v1
type tns:BoundParameterList
properties
minOcc   0
maxOcc   1
content   complex
children tns:BoundParameter
description
Used to bind a reference in an MISQL string to an actual object. Parameters are referenced in the MISQL using a name starting with '@' or ':'. For example, most geometries cannot be directly placed in an MISQL string so a reference to the geometry is put in the MISQL string and the geometry is bound to the request with a bind parameter.


© 2013 Pitney Bowes Software Inc. Email: pbbi.support@pb.com