LPL/Configuration Console - Substring or Left Function for Derived User Field or Instance Selection

rmbell

We would like to create a user field(derived or computed?) that returns the first 3 characters of the position short description. Ex. Left(Position.ShortDescription,3) or Substring(Position.ShortDescription,1,3), but we are unable to locate the syntax in the LPL guide. Is this even possible? This is for the potential to create actor groups based on part of a field.

Similarly, we would like to filter on the first 3 characters of a field in a list. In the Instance selection section, we would want something like this:

Instance Selection
where (TurnoverType.Transfer
and OldHROrganizationUnit != NewHROrganizationUnit
and left(OldJobShortDescription,3) = "TCH"

Substring and Left aren't working, so I wanted to see what the syntax of this would be. I couldn't find this in the LPL guide.

Derick Safarian

To obtain the first 3 characters of a field, try the following:

1. Create a Derived field, size 3

2. In the Definition box, enter: "return Position.ShortDescription"

3. Add this Derived field to your list