Wednesday, August 22, 2012 11:55 AM
In short: I'm trying to filter an XSLTListViewWebPart based on what is selected in another XSLTListViewWebPart. Using a String field as connection this is working fine. Using a hyperlink field no data is displayed.
In more detail: I have two lists, say
Projects. Both have a hyperlink field
accountURL. All accounts have different accountURLs. Different projects can have the same value for accountURL. Both are displayed on a page using the XSLTListViewWebPart. The simple goal is to filter the
Projectslist based on which item is selected in the
Accountslist using the
accountURLfield. So I established a web part connection using the
acountURLas a filter. Alas, when an item in the
Accountslist is selected no items are showwn in the
Projectslist although I double checked that there are matching values. When using a string field instead of a hyperlink field for
accountURLeverything works like a charm. Problem is, I need the hyperlink field.
Is this desired behaviour? Do you have any suggestions for a workaround? (I already tried converting the hyperlink field to a string field via a calculated column which did not work out either.)
All was and is to be done in the web interface or SP-Designer. Coding a WSP is not an option for this problem. As I'm not quite familiar with the correct terminus technicus I use field and column interchangeably.
All help is greatly appreciated.
Thursday, August 23, 2012 5:14 AMModerator
You may want to use a SharePoint Designer Workflow to copy the "accountURL" value to a custom text type column (Single line of text) in each list Accounts and Projects, then you can use the web part connection to filter the list according to the text type column between Accounts and Projects list web parts.
You can hide the text type field in the NewForm/EditForm via list item content type like this, and can also hide this text type column in list view via modify list view.
TechNet Community Support
Thursday, August 23, 2012 12:07 PM
thank you very much for your idea. The workaround does its job well.
Nonetheless, I still wonder whether it is possible to use hyperlink columns or other special columns for filtering.
I also had the problem that I cannot use a person column as lookup.
you or anyone else know if whether there ist some kind of overview
which column types can be used for filtering/formulas/lookup/...?
- Marked As Answer by SomeTallGuy Thursday, August 30, 2012 8:05 AM
Thursday, August 30, 2012 5:23 AMModerator
Sorry for the late reply. I find two articles about this,
column types for calculated/lookup,
supported column types for the web part conncetion filter,
TechNet Community Support
- Marked As Answer by SomeTallGuy Thursday, August 30, 2012 8:04 AM