I need to update the email address field values from uppercase to lower case to make them uniform inside the data schema but it is not happening because email address is marked as Primary key.
Please help me to achieve this or please suggest any workaround.
Update your schema attribute to dataPolicy="lowerCase" to lowercase going forward.
If possible, instead of setting properties on the field use template="xtk:common:email" for consistency with the rest of the system.
But schema is already having dataPolicy="email". Should i update my custom schema or any other workaround? This is about email address field.
<attribute dataPolicy="email" desc="Email address" label="Email" length="128"
name="email" sqlname="sEmail" type="string"/>
Oh, right. Other options are to lowercase at points of intake, i.e. update activity with lower() and form leave+set, or to instead reference a second attribute lowercasing the first, i.e. <attribute expr="lower(@email)"/>.