Skip Navigation
Expand
How to make a case-insensitive condition for a property text format
Answer ID 12003   |   Last Review Date 11/03/2021

Is there a way to remove the case sensitivity format for the visibility settings conditions which uses "contains" for a property?

Environment:
 
Oracle Field Service (OFS)
 
Issue:
 
We would like to confirm if there is a way to remove the case sensitivity format for the visibility settings conditions which uses "contains". Reason we asked is there is some functionality that isn't working properly because it doesn't satisfy the exact case-sensitive value listed on the condition. 
 
For example:
The technician enters a value in a property (field) as DEVICETYPE:ATA, instead of DeviceType:ATA
The activation button only appears when the value is typed in as: "DeviceType:ATA"
 
Resolution:
 
In the Visibility Settings of the property, under Conditions, use the option "Show conditions as formula", and enter the following condition: (toLowerCase(activity.<PROPERTY_NAME>) CONTAINS 'test')
This condition will take the text of the value and convert it to lowercase prior to the validation of the value. In this case the property was displayed when PROPERTY_NAME had "test" in any uppercase or lowercase configuration, like "tEST", "tesT" or "tEsT".
 
Image shows Visibility Settings screen. "Show condition as formula" is highlighted
 
The function is listed in Administering Oracle Field Service