CC: Rakesh Roy Prasad Pise Jaideep Vinchurkar Snehal Katkar

This functionality is correct from Import side, we will need to restrict these characters through UI.

Regards,
Satya Prakash

Hi Jayshree Nagpure,

Please find below 3C's of the issue,

Concern: Special characters like semicolon, hyphen, xp_ are imported in USD, file wents to bad
Correction: Validation for user defined field .

Thanks ,
Akshay Mukkawar
---------------------------
CC:Sheetal Bodhale,Satya

Verified on LB
Company - Wheaton

Verified for all mentioned special characters
Field Value cannot contain special characters like <, > , &, ; , ` , ~ , | , ! , $ , % , ^ , * , _ , ( , ),xp_,`
System shows validation for UDF

Working fine as expected.
Marking item state as Ready for Stage

CC : Rakesh Roy Prasad Pise

Verified on Stage
Company - City of bellevue for hspl

Verified for all mentioned special characters
Field Value cannot contain special characters like <, > , &, ; , ` , ~ , | , ! , $ , % , ^ , * , _ , ( , ),xp_,`
System shows validation for UDF

Working fine as expected.
Marking item state as Ready for Production

Verified on Production
Company - Caiso for hspl

Verified for all mentioned special characters
Field Value cannot contain special characters like <, > , &, ; , ` , ~ , | , ! , $ , % , ^ , * , _ , ( , ),xp_,`
System shows validation for UDF

Working fine as expected.
Marking item state as Production complete

Thanks,
Jayshree

This patch has been reverted to solve other issue WT-11062.

Hello Jayshree Nagpure,

Concern:- Special characters like semicolon, hyphen, xp_ are imported in USD, file wents to bad.
Cause:- Regular expression wasn't in proper form.
Correction:- Changed regular expression(As per discussion with Swapnil Pandhare Only for SQL Injection character ie. ; , ' , xp_ , -- ) and message for same.

Impacted Areas:- Additional TextBox and TextArea.
Affected files:- CommonClass.cs & WorkTerraLocalization (All files)

CC: Sheetal Bodhale, Swapnil Pandhare, Satya

Thanks & Regards,
Amit Kumawat

Hi Amit Kumawat,

Verified on Lb
Company - QA city of durham for hspl

Verified User defined field with some special characters
But observe that after entering characters in text box and saving and it converts in some characters and special symbols.
Also when we add text to text box, and if there is text area, given text from text box moves to text area

PFA :

Not working as expected

Hence re-opening this jira

Thanks,
Jayshree

cc : Rakesh Roy Prasad Pise

Hello Jayshree Nagpure,

Concern:- Special characters like semicolon, hyphen, xp_ are imported in USD, file wents to bad.
Cause:-
1. Special characters - Special characters was binding in html encoding format in AdditionalTextBox.
2. AdditionalTextBox value set to AdditionalTextArea if AdditionalTextArea is empty - This issue exists at Demographics form only. AdditionalTextArea value not set empty if control is empty.
Correction:-
1. Restrict special characters like xp_, --, <, >, `, &, ~, |, !, $, %, ^, *, ?, !, ;, &, " and changed message accordingly.
2. Handled condition if there is no value in AdditionalTextArea, set it empty.

Impacted Areas:- AdditionalTextBox, AdditionalTextArea & Demographics form(For 2 no. point).
Affected files:- CommonClass.cs, WorkTerraLocalization - for key “FieldValuecannotcontainspecialcharacters”, EmployeeProfileModel.cs

CC: Swapnil Pandhare, Sheetal Bodhale, Satya

Thanks & Regards,
Amit Kumawat

Verified on Lb

Verified below scenario :
Special character in user defined textbox
Special character in user defined texarea
Restricted special characters
Verified Demographic data after saving

Issue is fixed.
Working fine

Marking item state as Ready for Stage

Thanks,
Jayshree

cc : Rakesh Roy Prasad Pise

Verified on Stage
Company - ASML for hspl

Verified below scenario :
Special character in user defined textbox
Special character in user defined texarea
Restricted special characters
Verified Demographic data after saving
Issue is fixed.
Working fine

Marking item state as Ready for Production

Thanks,
Jayshree

CC: Rakesh Roy Prasad Pise

Verified on Stage
Company - ASML for hspl

Verified below scenario :
Special character in user defined textbox
Special character in user defined texarea
Restricted special characters
Verified Demographic data after saving
Issue is fixed.

Working fine
Marking item state as Production Complete

Thanks

Hello Jayshree Nagpure,

We have reverted this patch for special characters at LB, now it will allow to save special characters in DB.
After reverting this patch I've observed-
1. If we will try to save PIPE | symbol, it will give an server error.
2. Special characters are binding in HtmlEncode format for text box.
for eg. & is binding like &.

We are looking into both. Please check for other special characters and related issue, once it's get deployed at LB.

Please also update linked tickets accordingly.

CC: Sheetal Bodhale, Swapnil Pandhare, Gaurav Sodani, Rakesh Roy, Satya

Thanks & Regards,
Amit Kumawat

Hello Jayshree Nagpure,

We have reverted patch WT-9461 from LB for special characters which is mentioned in this JIRA ticket. Now as per discussion with Jayshree Nagpure We have checked for special characters < > & |
These are still handled for AdditionalTextBox for WT-9106.

1. There is still validation exists for four special characters < > | & it will not allow to save these four characters for AdditionalTextBox.
2. PIPE | and Tild ~ characters will not save, it will through server error for PIPE | and Tild ~ will not save.
3. If we insert some special characters in AdditionalTextBox than that will be bind with AdditionalTextBox in HtmlEncode form.
for eg. " &
4. Special characters like ; ' – xp_ are not allowed in both AdditionalTextBox and AdditionalTextArea because these are SqlInjection characters.

CC: Sheetal Bodhale, Swapnil Pandhare, Rakesh Roy, Gaurav Sodani, Satya

Thanks & Regards,
Amit Kumawat

Hi Amit Kumawat,

Verified on Lb
Company - QA CAISO for hspl

Verified below scenario :
1.Special characters < > & | - Not allowing for text box
2. PIPE | and Tild ~ characters not save, it throws server error for PIPE | and Tild ~ will not save.
3.Through import - Allowing all characters except ; xp_ '
4.Employee workflow went fine, but in import when & is given - Import is done propely, but when we traverse workflow system shows validation for &
5 for ~ changes will not saved
6. EE workflow went fine when other special characters are added in User defined field with import and UI.
7.For TextArea - Allowing all special character through UI except Pipe and tild

Working fine
Marking item state as Ready for Stage

Thanks,
Jayshree

CC : Prasad Pise Rakesh Roy

Hi Amit Kumawat,

This jira Has been marked as Ready for stage.
But its status is updated to Production deployed
Could you please let us know the reason for production deployment.

Thanks,
Jayshree

cc : Swapnil Pandhare Prasad Pise

Hello Jayshree Nagpure,

Initially this ticket needs to be revert from Production, but first reverted from LB for testing purpose as per discussion with Swapnil Pandhare and Gaurav Sodani. Now special character changes are reverted from Production as well. Please check it.

CC: Sheetal Bodhale, Swapnil Pandhare, Satya

Thanks & Regards,
Amit Kumawat

Verified on Production
Company - ASML for hspl

Verified below scenario :
1.Special characters < > & | - Not allowing for text box
2. PIPE | and Tild ~ characters not save, it throws server error for PIPE | and Tild ~ will not save.
3.Through import - Allowing all characters except ; xp_ '
4.Employee workflow went fine, but in import when & is given - Import is done propely, but when we traverse workflow system shows validation for &
5 for ~ changes will not saved
6. EE workflow went fine when other special characters are added in User defined field with import and UI.
7.For TextArea - Allowing all special character through UI except Pipe and tild

Working fine

Thanks,
Jayshree

cc : Rakesh Roy Prasad Pise Swapnil Pandhare

As discussed with Swapnil Pandhare, marking jira as ready for stage.
As patch revert from stage is pending

CC : Rakesh Roy Prasad Pise

Verified on Stage
Company - Barrow for hspl

Verified below scenario :
1.Special characters < > & | - Not allowing for text box
2. PIPE | and Tild ~ characters not save, it throws server error for PIPE | and Tild ~ will not save.
3.Through import - Allowing all characters except ; xp_ '
4.Employee workflow went fine, but in import when & is given - Import is done propely, but when we traverse workflow system shows validation for &
5 for ~ changes will not saved
6. EE workflow went fine when other special characters are added in User defined field with import and UI.
7.For TextArea - Allowing all special character through UI except Pipe and tild

Working fine
Thanks,
Jayshree

As this jira is already deployed and tested on Production, marking item state as Production complete

Hello Jayshree Nagpure,

These special character changes are reverted from Azure. This patch is already has been reverted from LB, Stage and Production.
Please verify it at Azure.

CC: Sheetal Bodhale, Swapnil Pandhare, Satya

Thanks & Regards,
Amit Kumawat

Hi Swapnil Eksambekar,

Please share your finding's as you have verified this on Azure.

Thanks,
Jayshree

cc : Sachin Hingole Hrishikesh Deshpande Prasad Pise Amit Kumawat

Verified this on Codemap,It is working same as Production.
It is working as expected.

CC-Rakesh RoySachin HingoleHrishikesh DeshpandeJayshree Nagpure