Exten email parameters, with a field to provide "Recipient address" and/or "BCC".
The SysEmailParameters form will store the Exchange and/or SMTP settings for all outgoing e-mails. In TEST scenario's, we would like to have the option to also specify a "Recipient" address. All e-mails will then be send to this (test)address instead of to the real mail address.
...Support JOIN "ON" clause in Query processor
When writing a query in X++, the only available joins are INNER, OUTER and EXIST. The inner join is translated to a CROSS JOIN, with (optionally) a WHERE clause. In SQL we have the best practice to write relations between tables in the ON clause. This because this is executed more early in the ex...
Incremental export to BYOD with merge instead of truncate
We do have the option to export "FULL LOAD" to an external database. This will truncate the data, and re-insert a new version of all rows. For large tables, this will move A LOT of rows each day. We also have the option to export incrementally. This needs change tracking. This will read change t...
BYODb - TRUNCATE instead of DELETE from external DB, when systems has only one DATAAREAID.
When running a full export of an entity to BYOD, the process will first delete the data from the BYOD db, will then re-insert the data. The statement is: DELETE T1 FROM ***Staging T1 WHERE T1.DATAAREAID = '***' AND T1.PARTITION = 'initial'. In case of large tables, this delete is very expensive....