Example Queries - EcoSys - Customization & Programming - Hexagon

EcoSys Gateway Web Service API Client

Language
English
Product
EcoSys
Search by Category
Customization & Programming
EcoSys Version
8.7

Since the SQL result set columns (header) must match the configured API column ids, you must either configure the API's column ids to match the JDBC database table's column names, or specify column aliases matching the API column ids as part of your query.

You can configure a query spanning multiple lines by ending the broken lines with a backslash character ("\").

Following are some example queries:

query = select * from users

query = SELECT \

user_id "UserId", \

user_name "UserName", \

TO_CHAR( create_date, 'YYYY-MM-DD' ) "CreateDate" \

FROM users \

WHERE user_id < 220 and user_id > 210