Tell me more ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.
up vote 1 down vote favorite

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

1 Answer

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:

http://office.microsoft.com/en-us/windows-sharepoint-services-help/examples-of-common-formulas-HA010105479.aspx

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? – BGM 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. – BGM 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}. msdn.microsoft.com/en-us/library/ff630170.aspx – 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) – BGM Nov 17 '12 at 17:27
show 5 more comments

Your Answer

 
discard

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.