complexType SearchBySQLRequest

diagram
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         documentation A unique identifier that is returned in the response. It is used for debugging or keeping track of asynchronous requests. locale   xsd:string   optional         documentation 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         documentation 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      documentation 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).
annotation	documentation A request to perform a search on one or more tables with a MISQL query.

element SearchBySQLRequest/SQL

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

element SearchBySQLRequest/TableList

diagram
namespace	http://www.mapinfo.com/midev/service/feature/v1
type	tns:TableList
properties	minOcc  0 maxOcc  1 content  complex
children	tns:Table
annotation	documentation 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
namespace	http://www.mapinfo.com/midev/service/feature/v1
type	tns:BoundParameterList
properties	minOcc  0 maxOcc  1 content  complex
children	tns:BoundParameter
annotation	documentation 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.

© 2007, 2020 Precisely. All rights reserved.

support.precisely.com