Bug during POST (create)

[idrenski]

Bug during POST (create)
error:
{
"originalError": {},
"_e": {},
"rawStack": ": ORA-00904: "id": invalid identifier\n",
"details": "Details: Error: ORA-00904: "id": invalid identifier\n\n",
"message": "[Error (E_UNKNOWN) Encountered an unexpected error] Details: Error: ORA-00904: "id": invalid identifier\n\n",
"stack": "Error (E_UNKNOWN) :: Encountered an unexpected error\n: ORA-00904: "id": invalid identifier\n"
}

[idrenski]

The issue is almost fixed with the following:

var selectQuery = 'select * from "'+table+'" order by "' + _getPK(connectionName, table) +'" desc';

However it returns the last record by rownum which is not always the last inserted.

The fix allows to insert but return wrong result.
It's better to use where clause in the select insted of order by desc.

var selectQuery = 'select * from "'+table+'" where '+colName+'=\''+data[colValue]+'\'';