Collapse
Submit a Service Request
Contact Information for Technical Support
My Service Notifications
How to make a case-insensitive condition for a property text format
Answer ID 12003 |
Last Review Date 08/26/2022
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".
The function is listed in Administering Oracle Field Service.
