SQL Dynamic Search - integrate services

To be able to use tables whose translation concept is based on IsRowID in the SQLs in the Dynamic Searches, you can include certain services. These ensure that the views corresponding to the user language are loaded.

For this purpose insert the following line into the SQL, enclosed in three curly braces:

Innosoft.CRM.Core.Service.DynamicObjectsService.DynamicObjects.LanguageTableService?{Tabellenname}

This "request" returns the appropriate view name. Make sure that the view is given an alias.

For some fields you need to consider, which language you are in. For these values, the following line, enclosed in three curly brackets, can be specified in the SQL:

Innosoft.CRM.Core.Service.DynamicObjectsService.DynamicObjects.LanguageTableService|GetKeyField?{Spaltenname}

This "request" returns the matching column name. Make sure that this request is preceded by the table name with a period. An alias should also be assigned here.

Example

SELECT *,
mapark.{{{Innosoft.CRM.Core.Service.DynamicObjectsService.DynamicObjects.LanguageTableService|GetKeyField?maschtyp}}} AS Maschkategorie, 
FROM {{{Innosoft.CRM.Core.Service.DynamicObjectsService.DynamicObjects.LanguageTableService?mapark}}} mapark