0

A rather strange request has appeared from our client, who wants to be able to search a SharePoint 2010 list for items (based on a string column) while ignoring diacritics.

A quick example, assuming this is a list with IDs and two columns:

1. Paweł | Marciniak

2. Pawel | Jankowski

then searching the first column for PAWEL (or PAWEŁ for that matter) should return both items.

Can it be done using CAML?

|improve this question
1

AFAIK it's not possible using CAML alone.

But you may create an extra hidden column FirstNameNormalized, and update that with an EventReceiver on ItemAdded/ItemUpdated using a nomalized string like the one from Stripping is an interesting job.

Then when you're filtering you can do that on FirstNameNormalized using a likewise normalized string.

|improve this answer
  • That was my initial idea, but I was hoping there was some way of making CAML do the work for me. Thanks for the answer. – Shaamaan Oct 22 '12 at 7:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.