03/00/2021 - v3.5.20.x

Updated Fields and Field Expressions

These newly added Fields and 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.

DateOffset(DateTime, YearOffset, DayOffset, HourOffset) returns new DateTime

IndexOf() and LastIndexOf()

These functions provide a way to manipulate strings within field expressions.

• IndexOf(String1,String2) - Returns the first character index of a search string within another string value or -1 if not found.

• LastIndexOf(String1,String2) - Returns the last character index of a search string within another string value or -1 if not found.

Example

To display date-time for the most recent tracking status change for a package in the Packages Dashboard, create a Field that contains the following Field Expression and then reference the field in a report:

If(LastIndexOf(';',{STRATUS.Package.TrackingStatusLogDT}) > -1, Right({STRATUS.Package.TrackingStatusLogDT}, AsNumber(Len({STRATUS.Package.TrackingStatusLogDT})) - LastIndexOf(';',{STRATUS.Package.TrackingStatusLogDT}) - 1), {STRATUS.Package.TrackingStatusLogDT})

TrackingStatusChange()

The purpose of the function is to improve tracking metrics. The TrackingStatusChange() function can provide report data that answers questions like “How may many feet of pipe cut are cut or spools welded per day, per week, per month?

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. Return 1 if TrackingStatus has ever been applied

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

   2. Example: TrackingStatusChange({STRATUS.Package.TrackingStatusLog},'Packaged')

2. Return 1 if TrackingStatus has been applied between StartDT and EndDT. Note: It is acceptable to provide only one of the date arguments, leaving out that date time-bound check.

   1. Generic Syntax: TrackingStatusChange({STRATUS.*.TrackingStatusLog}, TrackingStatus, {STRATUS.*.TrackingStatusLogDT}, StartDT, EndDT)

   2. Example: TrackingStatusChange({STRATUS.Package.TrackingStatusLog},'Packaged',{STRATUS.Package.TrackingStatusLogDT},'09/01/2020','09/30/2020')

3. Return 1 if TrackingStatus has ever been applied by a particular station or user name.

   1. Generic Syntax: UserNameTrackingStatusChange({STRATUS.*.TrackingStatusLog}, TrackingStatus, '', '', '', {STRATUS.*.TrackingStatusLogBy}, UserName)

   2. Example: TrackingStatusChange({STRATUS.Package.TrackingStatusLog}, 'Packaged', '', '', '', '', {STRATUS.Package.TrackingStatusLogBy}, 'Kelly Demo')

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

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

   2. Example: TrackingStatusChange({STRATUS.Package.TrackingStatusLog}, 'Packaged', {STRATUS.Package.TrackingStatusLogDT}, '09/01/20','09/30/20', {STRATUS.Package.TrackingStatusLogBy}, 'Kelly Demo')

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