4.7.5

Changelog for Golden EDI version 4.7.5 that was released on 2022-11-25

Description

The focus for this release has been to work on the Workflow documentation feature. This isn't ready for everyday use yet, but many improvements have been made. We have also added a feature to generate dates/times in filters when exporting, this is useful to limit records that has been changed. Some related and unrelated bugfixes has also been made that improves the stability of the application.

Filter Functions

A new toolkit called filter functions has been added to the system. With this you can now run what we call functions before the filter is passed to "SetView" during message processing. This allows you to, for instance, get the current date and subtract two days and use that in your filter to get recently updated records.

You wrap the functions with the function block #{...} and it will be evaluated as the system processes the message. You can pipe the output of one function to the next inside the function block by using the pipe '|' symbol between calls. Functions with "Input" in the list below are the functions that can take input from a previous function call. Anything with "Param" expects input from you as the caller.

Functions

  • TODAY -> Today();

  • YESTERDAY -> CalcDate('-1', Today());

  • TOMORROW -> CalcDate('+1', Today());

  • WORKDATE -> WorkDate();

  • CURRENTDATETIME -> CurrentDateTime();

  • FORMAT -> Format(Input);

  • FORMAT(XML) -> Format(Input, 0, 9);

  • TIME -> Time();

  • DT2DATE -> DT2Date(Input);

  • DT2TIME -> DT2Time(Input);

  • <..> -> CalcDate(Param, Input);

  • TIME(HH:mm:ss.fff) -> Evaluate(Input, Param);

  • DATE(YYYY-MM-DD) -> Evaluate(Input, Param);

  • DATETIME(YYYY-MM-DDTHH:mm:ss.fffZ) -> Evaluate(Input, Param);

Examples

WHERE(SystemCreatedAt=FILTER(#{TODAY|<-2D>|TIME(00:01)})
WHERE(SystemCreatedAt=FILTER(#{CURRENTDATETIME|DT2DATE|TIME(00:01)})

Field Look Enum/Options

This release contains a small but very useful addon to the recently updated Field Selection page and that is that you can now find all values for any option or enum in the system as well. This makes it easier to write filters using the integer value of the enum or option you want instead of using the internal caption.

When viewing the field lookup page you can now click on the Type column for the row you want to inspect more and if its an Option or Enum you will see a new window open up listing all the different options.

Click the "Option"
And the secrets will be revealed!

Changelog

  • Improvements to Workflow.

  • Filter functions and support for handling those when exporting messages.

  • Improvements to Shipment and additions for future enhancements.

  • Fixed a bug in Get Purch. Line where new lines got an incorrectly calculated line number.

  • Passing RecordRef as var when generating reports in PDF report function.

  • Renamed Purchase Return Order extension file.

  • Fixed "Create Message" in Write Message so it gets the correct RecordRef passed.

  • Added Enum/Option lookup to the field selection page.

Last updated