Value Lists with DBGate

DBGate supports the following configurations:

• Validation Lists
• Selection Lists
• Parameter Values
• Value Lists with Fixed Values
• Value Lists Using Tables and Views
• Value Lists Using Stored Procedures
• Value Lists Using SQL

It automatically creates the required API, publishing configured properties in object metadata.

You can try online samples:

• https://dbgate.savetodb.com/api/mssql-023/en-us/s02/cashbook/$metadata
• https://dbgate.savetodb.com/api/mssql-023/en-us/s02/view_cashbook/$metadata
• https://dbgate.savetodb.com/api/mssql-023/en-us/s02/usp_cashbook/$metadata

The built-in JavaScript client and SaveToDB 8+ supports these features from the box.