HI All,
while case creation user will add policy number like this 12345675-7896 but when storing to DB will remove the "-" and will store only 123456757896
but while in the home page user filtering the record using 12345675-7896 the results will display null
Could you please suggest me the better solution.
Thanks in advance.
Discussion posts and replies are publicly visible
Possible you're saving it in an integer field?
If you want to keep the dash, I would suggest changing it to a Text field.
If you can't do that, another option would be creating a custom text Record field that inserts the dash at that position and change the column and search filter to point to that new field.
Thanks Mathieu,
Yes,we are using text field for storing but not storing with "-" to DB.
Again, user will search sometimes with "-" and sometime he will search without "-" as well as and we will get 5 to 6 filed like this format while case creation time . is it only possible to achive with custom text Record field ? do we have any other alternative solution for this?
Thanks in Advance.