FIX3.04.02 · Released 2 December 2021

FIXfinPOWER Connect

Released in

3.04.02

2 December 2021

1. Opened20 Aug
2. Closed2 Sep
3. Released2 Dec

Article 18515 Job J027264

finDocumentFunctions.GetClientSqlWhereBuilder() function updated

The finDocumentFunctions.GetClientSqlWhereBuilder() may return SQL without specifiying the table, i.e. just include the column name.

For example;

SELECT [Client].[ClientId],[Account].[AccountId] FROM (([Client] INNER JOIN [AccountClient] ON [Client].[Pk]=[AccountClient].[ClientPk]) INNER JOIN [Account] ON [AccountClient].[AccountPk]=[Account].[Pk]) INNER JOIN [MonitorCategory] ON [Account].[MonitorCatAPk]=[MonitorCategory].[Pk] WHERE [Active]=1

Notice the WHERE clause is simple "WHERE [Active]=1". This will now return the WHERE clause as "WHERE [Client].[Active]=1".

Therefore, prior to this change, using this with other joins may cause an erro like "Ambiguous column name".