Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Not able to update email address field in data schema as it is marked as Primary key

Avatar

Avatar
Validate 1
Level 2
nandhakumarp326
Level 2

Likes

8 likes

Total Posts

30 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Give Back 3
Give Back
Ignite 1
Boost 5
View profile

Avatar
Validate 1
Level 2
nandhakumarp326
Level 2

Likes

8 likes

Total Posts

30 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Give Back 3
Give Back
Ignite 1
Boost 5
View profile
nandhakumarp326
Level 2

11-04-2019

Hi There

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.

Thanks

Nandhakumar

Replies

Avatar

Avatar
Give Back 25
MVP
Venu_Reddy
MVP

Likes

163 likes

Total Posts

171 posts

Correct Reply

53 solutions
Top badges earned
Give Back 25
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile

Avatar
Give Back 25
MVP
Venu_Reddy
MVP

Likes

163 likes

Total Posts

171 posts

Correct Reply

53 solutions
Top badges earned
Give Back 25
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile
Venu_Reddy
MVP

11-04-2019

Hi nandhakumarp32626249​,

You can use the function lower() in the list of funtions (Expression -->> List of functions).

Regards,

Venu

Avatar

Avatar
Validate 1
Level 2
nandhakumarp326
Level 2

Likes

8 likes

Total Posts

30 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Give Back 3
Give Back
Ignite 1
Boost 5
View profile

Avatar
Validate 1
Level 2
nandhakumarp326
Level 2

Likes

8 likes

Total Posts

30 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Give Back 3
Give Back
Ignite 1
Boost 5
View profile
nandhakumarp326
Level 2

12-04-2019

Hi Venu

Thanks for your quick turnaround.

I've tried it but it is not working. Also to clarify, if that field is marked as primary key, is that stopping from update request.

Thanks

Nandha

Avatar

Avatar
Give Back 25
MVP
Venu_Reddy
MVP

Likes

163 likes

Total Posts

171 posts

Correct Reply

53 solutions
Top badges earned
Give Back 25
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile

Avatar
Give Back 25
MVP
Venu_Reddy
MVP

Likes

163 likes

Total Posts

171 posts

Correct Reply

53 solutions
Top badges earned
Give Back 25
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile
Venu_Reddy
MVP

12-04-2019

Hi Nandha,

I tried in my instance and it is working as expected.

It won't stop updating the filed even though if the field is marked as primary key.

Regards,

Venu

Avatar

Avatar
Validate 1
Level 2
nandhakumarp326
Level 2

Likes

8 likes

Total Posts

30 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Give Back 3
Give Back
Ignite 1
Boost 5
View profile

Avatar
Validate 1
Level 2
nandhakumarp326
Level 2

Likes

8 likes

Total Posts

30 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Give Back 3
Give Back
Ignite 1
Boost 5
View profile
nandhakumarp326
Level 2

12-04-2019

Thanks Venu.

Let me check again.

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

959 likes

Total Posts

1,082 posts

Correct Reply

506 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

959 likes

Total Posts

1,082 posts

Correct Reply

506 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
wodnicki
MVP

12-04-2019

Hi,

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.

Thanks,

-Jon

Avatar

Avatar
Validate 1
Level 2
nandhakumarp326
Level 2

Likes

8 likes

Total Posts

30 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Give Back 3
Give Back
Ignite 1
Boost 5
View profile

Avatar
Validate 1
Level 2
nandhakumarp326
Level 2

Likes

8 likes

Total Posts

30 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Give Back 3
Give Back
Ignite 1
Boost 5
View profile
nandhakumarp326
Level 2

10-05-2019

Hi Jon

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"/>

Thanks

Nandhakumar.P

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

959 likes

Total Posts

1,082 posts

Correct Reply

506 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

959 likes

Total Posts

1,082 posts

Correct Reply

506 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
wodnicki
MVP

10-05-2019

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)"/>.