03/00/2021 - v3.5.20.x

Updated Fields and Field Expressions

These newly added Field Expressions are complementary to the HoursInTracking() Field Expression released last week.

{STRATUS.*.TrackingStatusLogBy}

This field returns the list of user names who made each tracking status change. See an example in the TrackingStatusChange() field expression example below.

DateOffset()

This Function calculates a new date-time based on the year, day, and hour offsets.

IndexOf()

This Function returns the first character index of a search string within another string value.

LastIndexOf()

This Function returns the last character index of a search string within another string value.

TrackingStatusChange()

This Function returns a 0 or 1. As a result, it can be determined 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 following is a list of generic function arguments that provide the following:

• Tracking status applied

• Timespan to filter (optional)

• User to filter (optional)

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()