SharePoint Designer - Data Views - Using Server Variables as parameters

Today I have come across the task to filter a Form Library where one of the columns - which comes from InfoPath form - stores the login name of the SharePoint user. Like DOMAIN\account. I needed to filter the Form Library documents for current user.

First I tried to use the filter column = [Current User] - didn't work.

Then I have found the following article on SharePoint Designer Team Blog:
Data View / Data Form: Parameters You Don’t Know About

I have created a DataView parameter called UserLogin:

and used it to filter the Form Library:

That helped.

Comments

Setting up External Content Type for SQL Server database using SQL Server authentication - SharePoint 2010 Foundation

This post is a follow up on the issues that I have got setting up External Content Type (ECT) on SharePoint 2010 Foundation that was going to connect to remote SQL Server database for information. I cannot use my SharePoint user accounts to access SQL Server. According to the information I have discovered ECT and Business Connectivity Services are available in the SharePoint 2010 Foundation, but there are some issues if you want to use authentication methods in your external connections that are different from Windows Identity or Current User Identity. This is because there is no Secure Store Service in SharePoint 2010 Foundation which serves as an impersonation hub and is only available in SharePoint 2010 Server edition. The issues are coming from the fact that you can actually create ECT in SharePoint Designer 2010 providing just Secure Store ID and system would ask you for credentials and here you go, but when you try to use your ECT in External Lists or as a lookup columns you w...

SharePoint 2013 Development and Consulting - Laptop & Conferencing Experience with Lync

Have just jumped on a brand new SharePoint 2013 massive Intranet project and because of specific working conditions have found some items that required addressing almost immediately in order to continue the job. Maybe this will be interesting to someone else who is about to start SharePoint 2013 development to have an idea of what might be necessary. I started working with SharePoint using my own infrastructure in 2009. I used iMac with 320GB HDD and 4GB RAM running VMWare Fusion to virtualise Windows environment ( SQL Server 2008, standalone SharePoint 2007, Visual Studio 2008, Office 2007). It was all-in-one virtual machine. A bit slow, but enough for any SharePoint work that I had at that time. For communication with colleagues and partners we used GoToMeeting . Great tool that worked (and still works) without any problems. Voice, video, screen-sharing - all worked well using built-in audio/video hardware. In 2010 I got a MacBook Pro with 500GB HDD and 8GB ...

iPhone 4 Personal Hotspot on Optus Prepaid

Recently I decided to try the Personal Hotspot feature of iPhone 4, but found some obstacles. Problem When I try to activate or set up Personal Hotspot on my iPhone: I am getting the following message: "To enable Personal Hotspot on this account, contact OPTUS". It means I can't use that feature of my phone. Background I use prepaid mobile service from Optus with iPhone 4. I bought my phone directly from Apple and it's not locked to any mobile service provider. As a part of my prepaid service I have got some data which is "mobile Internet and can be used within Australia for internet browsing and downloading content" (from Optus site ). I pay for mobile services and data. I contacted Optus as per message above in Twitter. Here's the conversation I have got with Optus representatives: The details are on my Twitter account @SlavaGorbunov The http://optus.com.au says "Please note: iPhone Personal Hotspot / Tethering is not...

SharePoint etc.

Search This Blog