SharePoint View


I am trying to modify a view in SharePoint Designer to only show files that DO NOT Contatin or DO NOT BEGIN with a particular string.

Anybody got any idea how to do this?

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Justin SmithSr. System EngineerCommented:
You can filter on a column in the view in the GUI, not even needing Designer.
crhitaAuthor Commented:
You can't filter on the Name Column in SHarePoint 2010, well in my doc library anyway.

It will only allow you sort ascending or descending.
Justin SmithSr. System EngineerCommented:
Can you filter on Title?  You might not have TItle filled in.  In which case, I can't help.
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

crhitaAuthor Commented:
Title is blank.

We only have file name completed.

Thanks for your help anyway.
zephyr_hex (Megan)DeveloperCommented:
you can do this with Sharepoint Data View.  link it to your library, and then create your filter.

this article shows you how to link the DVWP to your list / library, and also how to Filter.

for DOES NOT CONTAIN, use something like :
not like *STRING*

for DOES NOT BEGIN, use something like :
not like STRING*
zephyr_hex (Megan)DeveloperCommented:
those "*" may need to be "%" ... i can't remember.

i've previously used this article as a basis for modifying DVWP to enable wildcard filtering:

it shows you how to modify the SELECT statement with "contains" in order to achieve wildcard filtering.
crhitaAuthor Commented:
Thanks for this-these are for SharePoint 2007 and we are using 2010.

I will try it out and award points if I can get it working.
zephyr_hex (Megan)DeveloperCommented:
the solution would be similar.  sharepoint 2010 has a Data View web part, and it works the same way as 2007.
zephyr_hex (Megan)DeveloperCommented:
i also meant to say....  that if you put a DVWP on a page and configure it to display your list/library, and then put that page in Code View in Sharepoint Designer...  you can see the SELECT statement being used.  the second link i posted shows how to modify that SELECT statement for a wildcard - type filter.

your solution is not exactly the same, but it's similar.  you will probably want to modify  the SELECT statement in your DVWP so that it filters by a string.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.