SQL Reserved Keywords as column names in Advanced database and database layouts - Adeptia Help

Getting error while generating Query in Adeptia database or advanced database layout.

 

Problem In Generating XSD Strings, com.adeptia.indigo.utils.IndigoException: Error in executing query = SELECT SQLID,Title,CaseStatus,Author_LookupID,Author,Attachments,Order FROM "dbo"."Cases", Error: Incorrect syntax near the keyword 'Order'.

 

This error arises because the customer is using SQL’s reserved keyword (Order) as a header name in the database table. 

 

When creating a database or advanced database layout, if any column in the selected table matches a SQL reserved keyword, the column name in the SELECT statement must be enclosed in:

1. Backticks (`) for MySQL.
eg. SELECT SQLID, Title, …, `Order` FROM "dbo"."Cases"; 

2. Double quotes (“) for SQL Server and Oracle

eg. SELECT SQLID, Title, …, "Order" FROM "dbo"."Cases";  

 

Additionally, to ensure successful execution at runtime, the reserved keyword must be added (comma-separated) to the abpm.db.reserved.words property available at Settings for Runtime microservice.