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.