Mode Differences
Data Service lets you generate APIs in wizard mode or script mode. In wizard mode, you can configure APIs visually without writing any code. In script mode, you can write your own SQL queries for APIs, and features such as multi-table joins, complex queries, and aggregate functions are supported. This topic describes the features supported when generating APIs in wizard mode and script mode.
The following are the differences between generating an API in wizard mode and generating an API in script mode:
|
Category |
Feature |
Wizard mode |
Script mode |
|
Query object |
Query a single table in a single data source |
Supported |
Supported |
|
Query joined tables in a single data source |
Not supported |
Supported |
|
|
Query condition |
Exact numeric match |
Supported |
Supported |
|
Numeric range query |
Supported |
Supported |
|
|
Exact string match |
Supported |
Supported |
|
|
Fuzzy string match |
Supported |
Supported |
|
|
Query result |
Return field values as is |
Supported |
Supported |
|
Perform mathematical operations on field values |
Not supported |
Supported |
|
|
Apply aggregate functions to field values |
Not supported |
Supported |
|
|
Paginate returned results |
Supported |
Supported |
|
|
Query logic |
MyBatis tags |
Not supported |
Supported |