03/00/2021 - v3.5.20.x

Added New Field Expression TrackingStatusChange()

Added a new Field Expression TrackingStatusChange(). This Field Expression is complementary to the HoursInTracking() Field Expression released last week. TrackingStatusChange() returns a 0 or 1, essentially whether the tracking status has been applied, given the optional filters.  By returning a 0 or 1, it can be multiplied by whatever the desired metric unit is from the part.  By building a Field with ‘Is Total’ checked and using the field in a package report, totals per package can be summarized.

The function is generic with arguments for:

• Tracking status applied

• Timespan to filter (optional)

• User to filter (optional)

The following a list of the function arguments:

TrackingStatusChange({STRATUS.*.TrackingStatusLog}, TrackingStatus, {STRATUS.*.TrackingStatusLogDT}, StartDT, EndDT, {STRATUS.*.TrackingStatusLogBy}, UserName)

Example

Below is an example of a Packages Dashboard report that uses the field expression that will display the total weld inches completed last week (in the last 7 days) by a specific weld station operator (Kelly Demo. 

TrackingStatusChange({STRATUS.Part.TrackingStatusLog},'Fabricated',{STRATUS.Part.TrackingStatusLogDT},DateOffset(Now(),0,-7,0),'',{STRATUS.Part.TrackingStatusLogBy}',Kelly Demo')*{Diameter}

Use Cases

There are 4 possible use cases, depending on optional arguments as follows:

1. TrackingStatusChange({STRATUS.*.TrackingStatusLog}, TrackingStatus)

   1. returns 1 if TrackingStatus has ever been applied

2. TrackingStatusChange({STRATUS.*.TrackingStatusLog}, TrackingStatus, {STRATUS.*.TrackingStatusLogDT}, StartDT, EndDT)

   1. returns 1 if TrackingStatus has been applied between StartDT and EndDT

   2. it is acceptable to provide only one of the date arguments, leaving out that date time bound check

3. TrackingStatusChange({STRATUS.*.TrackingStatusLog}, TrackingStatus, '', '', '', {STRATUS.*.TrackingStatusLogBy}, UserName)

   1. returns 1 if TrackingStatus has ever been applied by UserName

4. TrackingStatusChange({STRATUS.*.TrackingStatusLog}, TrackingStatus, {STRATUS.*.TrackingStatusLogDT}, StartDT, EndDT, {STRATUS.*.TrackingStatusLogBy}, UserName)

   1. returns 1 if TrackingStatus has been applied between StartDT and EndDT by UserName

Remove TimeZoneId from Expression Functions

When running reports based on the following Field Expression functions, the user's timezone will be used. As a result, the TimeZoneId field will not be needed and will be ignored if currently used.

• HoursInTracking()

• TrackingStatusChange()