SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Salvete! I want to filter a list like this. Now, [othercolumn] is supposed to be the value of the field in the X-Field column. I want to see if the X-field column contains the text given in the othercolumn field.

enter image description here

share|improve this question
up vote 2 down vote accepted

Try to create calculated field based on your two columns that returns true if one of your columns is a substring of another and false otherwise. Use FIND function:

Then create list view filter based on the calculated column.

share|improve this answer
Since you recommend a calculated column, are you saying that what I want to do is not possible? I don't really want to create another column. I just want to do a string match on the column that already exists. If I create another column as you say, then wouldn't that just be a string match, too? – bgmCoder Nov 17 '12 at 16:04
You can not compare two columns in CAML. As a workaround I've suggested to use calculated field. – Dmitry Kozlov Nov 17 '12 at 16:26
So, the view filter can only recognize plaintext? I know it will take certain variables like [Me] and [Today]. I looked all over for a list of variables it would accept, but couldn't find one. – bgmCoder Nov 17 '12 at 16:51
In queries you can use specific values, variables like [Me], [Today] and binded parameters of XLVWP or DVWP in the following way: {Parameter name}. – Dmitry Kozlov Nov 17 '12 at 17:01
If I can use the binded parameters, is there no way to, within this filter, to look up the value of another field? (sorry for being so difficult) – bgmCoder Nov 17 '12 at 17:27

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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