searchBySQL
Description
Returns a list of features by performing a query on a table using a MapInfo SQL statement. See the MapInfo SQL Language Reference for detailed information on MapInfo SQL functions.
ACL Authorization Flow
To return features in a named table in the repository based on a MapInfo SQL query, the user (or any roles they belong to) will need Execute permission on the named table in the following manner:
- “EXECUTE” for entity type “Location Intelligence.Named Resources”
Note: If the SQL query references more than one table then EXECUTE permissions are needed
on all of the tables included in the query. (please check with team)
Messages
The following table lists the request and response messages for the searchBySQL operation.
Click on a message name to get more information about the message.
| Message | Description |
|---|---|
| SearchBySQLRequest | The request message for the searchBySQL operation. |
| SearchBySQLResponse | The response message for the searchBySQL operation. |