.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

sharepoint filter properties

Posted By:      Posted Date: October 26, 2010    Points: 0   Category :SharePoint



There are 4 different studios each with their own items. All of these items go into one web part. the web part view should be filtered when different users are viewing it.


I'm trying to filter a web part using three different groups.


management level - can see all items

studio heads - can see all items if they are the owner of the item

2nd in command to studio heads - can also see items owned by the studio head. 


If this possible to do via filter.


what properties can you use other than [ME] in a filter?

If I could filter it by Owner = [Me] and studiod =[MY Studio] that would be great.

View Complete Post

More Related Resource Links

SharePoint 2010 Search mapped properties and BDC filter descriptors


Are the mapped properties in SharePoint search at all related to the BDC FilterDescriptors? I have a custom datasource crawled using a BDC which is all working fine but I want to make use of the refinements panel to do further filtering in the results set based on fields in that custom datasource. I'm wondering if filter descriptors are the place to start?


Any thoughts would be really appreciated!

create current user filter in sharepoint designer or wss3

hi, how can i create a current user filter in sharepoint designer?

Filter items with a date column with parameters start date and end date on a sharepoint list?

If I have alist with a view that has the columns Title, Status and Status Date and the view has some items. How Can I add a filter with two parameters, start date and end date, to only show records with status date equal to or greater than parameter start date and status date is less than or equal to parameter end date? This is a sharepoint online site and I can't create and deploy custom code, can use SPD though. Do I need to use SPD or is this something I can do in the list settings? Thanks in advance.   Edit: I had a look here http://www.endusersharepoint.com/2009/09/29/sharepoint-date-filter-filtering-a-list-by-greater-than-or-equal-to-date/ but I don't have the Date Filter web part.

SharePoint 2010 Mobile Page Filter Settings

hello, i want to know from where i can edit the mobile page "task" list filter settings ? thanks

Can´t get the time intelligence filter to work in PerformancePoint Services/Sharepoint

Hi all, I have created a scorecard in Dashboard Designer based on an SSAS cube which looks ok in both DD and Sharepoint. As I want to connect a time filter to this I have created a TI filter in DD. In Sharepoint I have connected the filter to the scorecard with "send performancepoint values to". In "configure connection" I set source value to "PerformancePoint Values: Formula" and Connect to to "Endpoint_TIFormula". I only need to filter on year and have set the TI properties on the cube. Selected time dimension is "Year", Hierarchy level is set to Year, Member is 2008, reference date is 1/1/2008 and I have associated member level Year to Time aggregation Year. The filter is set up like this in DD: it uses the same data source as the scorecard and I use a list view. I do get the filter to work if I specify one formula for each year (e.g. Formula: "Year" and "Display Name: "2010", "Year-1" and "2009" making up two rows) but that can´t be the right way to do it, right? What i would like is a multiselect tree view where I can choose the year I want and have them display on columns. I have tried the formula Year:Year-2 and in the preview I see [Date].[Year].&[2008],[Date].[Year].&[2009],[Date].[Year].&[2008]. However, in Sharepoint the filter only show on

Can not show image in Filter drop down menu in SPGridView - Sharepoint 2007

Hi, I can not show image in the filter drop down menu (at header) of SPGridView in Sharepoint 2007.  For example: I have 3 rows as "_layout/images/1.gif", "_layout/images/2.gif", "_layout/images/3.gif". When user click on the column's header, the SPGridView just displayed filter menu and it always displayed the text (_layout/images/1.gif) not an image as I expected. So please help me to solve this problem. Thanks a lot Dan

Unable to add filter to a sharepoint DateTime Column

Hi ,I have a DateTime column in  a List. When I try to create a view the column doesnt appear in the folter Column List.When i create a calculated column out of the DateTime Column, the new calculated column appears in the Filter Column ListCan any one explain why?ThanksSrila

modify/override properties of default sharepoint modal dialogs (ex. editview.aspx) using javascript

Hello all, I would like to know how can I modify (override) some properties of the default sharepoint modal dialogs using Javascript. Ex. the size and location of editview.aspx. I while ago I asked a question about overriding the DialogResult in the display view dialog. I got an answer from Zach which looked like this:             sb.Append("<script type=\"text/javascript\">");             sb.Append(@"window.setTimeout(function () {");             sb.Append(@"if (window.frameElement && typeof(window.frameElement.overrideDialogResult) == 'function')");             sb.Append(@"{");             sb.Append(@"SP.SOD.executeFunc('sp.ui.dialog.js', 'SP.UI.DialogResult.OK', function () {");             sb.Append(@"window.frameElement.overrideDialogResult(SP.UI.DialogResult.OK); ");             sb.Append(@"});");             sb.Append(@"}");  

Sharepoint Filter Web Part Connection to Picture Libary Web Part

It seems that a sharepoint or choice filter web part can connect to any list object in sharepoint that is displayed in a web part on a page but the picture library.  I want to allow the user to select a value so that only the image that applies is viewed (along with any correlating information stored in its library). Is there a work around for this?  I've looked all over the web and can only find where someone else has asked in another forum and has not yet received an answer.  I'm sure this isn't the first time this has come up, so what are folks doing to accomplish this?

Using managed metadata properties to drive SharePoint search

I would like to advance search box to offer option to select managed metadata for the search. Basically I need one more search element to the advanced search options. I have SharePoint 2010 Enterprise Server Farm and currently out of box search available. How to do it?Kenny_I

How to remove conflict between Sharepoint 2010 Post Cache Substitution and Response.Filter

Under SharePoint 2007 (Win Server 2008, SQL 2008) we made use of Response.Filter to meet certain requirements for accessibility to remove certain markup or add to markup that was missing attributes, etc. When we upgraded to SharePoint 2010 we get the following error message from the pages, unless we remove the use of Response.Filter: "Post cache substitution is not compatible with modules in the IIS integrated pipeline that modify the response buffers.  Either a native module in the pipeline has modified an HTTP_DATA_CHUNK structure associated with a managed post cache substitution callback, or a managed filter has modified the response." I have found several posts including this article http://support.microsoft.com/kb/2014472 that explains that it is definately a problem, but no one has an alternative solution to using the Response.Filter, and the article doesn't say how to disable the use of Post Cache Substitution. So, my question is how do I turn off the use of Post Cache Substitution in SharePoint 2010, or how can I alter the final markup of the page "After" the substitution happens?  Or, if it is a control or three that are using Post Cache Substitution, which one(s) so that I can remove them.

How to read Sharepoint profile properties using C#.NET

Hi, I need to iterate through all the profiles existed in SharePoint and read the profiles property called "workemail". I followed below link, but no use. Getting error at "uniqueId" in the code. http://www.dotnetspider.com/resources/26399-How-access-SharePoint-User-Profile-from-C-code.aspx Tried below code as well SPSite site = new SPSite(strUrl);   // strUrl = I am mentioning MySite site collection URL here. Like ex: http://servername:1111/ ServerContext context = ServerContext.GetContext(site); UserProfileManager usrPrfMngr = new UserProfileManager(context);  foreach(UserProfile profile in usrPrfMngr) {      strEmail = profile["WorkEmail"].ToString(); } The above code is only reading the property of current logged on user. It is not iterating through all the profiles. After reading the current user property it is throwing an exception at foreach loop saying "Object reference is not set to an object" Any help would be appreciated. Thanks, -Gautham

Parameter value filter based on user in SSRS (SharePoint Integration mode)


Hello..we have a reuirement where we have to filter the parameter value in the drop down based on the user who is accessing the report. We have form and Windows authenication enabled in the SharePoint site (some users will be from inside the network using windows and some will be accessing the site using internet using the Form Authentication).

Please let me know what would be the best way to handle this reuirement? Do we need to create a separate table  and store the User Information along with the parameter values they have access to, pass the userid from Report to db and then fileter the records using this table? OR Can we create a SharePoint List to maintain the user access information and then directly fetch the user information from the list using T-SQL to filter the records?

Please let me know your suggestion...


Filter and Sort on fields in a joined dataview in SharePoint Designer


I need to create a data view that joins and displays data from two lists, and to sort and group on all of the fields displayed, not just fields from the main list.

I created linked datasource from two of my lists, joined them on a common field, and first inserted fields from the main list. Then I inserted fields from the other list as a Joined Subview,  which worked just fine, but now I need to be able to sort and filter on fields in that joined list, for which there doesn't seem to be an option.

Does anybody know whether it's possible and/or any workarounds/solutions for this? Basically, Is there a way to create a joined view of two lists where all fields are displayed in separate columns, and not in a table within a cell as in a case with joined subview?

Any comments are highly appreciated.


Using Filter in SharePoint FormField Lookup Column


I have a FormField lookup column with multiselect, which is bound to a List.

I have a new requirement.. There will be a textbox and a filter button above the FormField and when ever the user enter something and click on the filter button, the FormField lookup value should be filtered depending upon the string value in the textbox.

Please help me if somebody already done something like this or if someone has some idea how to do it..

SharePoint - Item - Edit Properties - Access Denied Error

I have a SharePoint 2007 EE Site  (with patches up to version running on Windows Server 2008 & SQL Server 2008.
I ported an existing site from a different domain to this server by backing up/restoring the content database. The site is running fine.

I added a new sub-site and here is where I have the issue. If I create a document library, add a document, and then use the drop-down on the item to pick "edit properties" I bounce to the SP Error: Access Denied screen. My account is a site admin and has full access to the sub-site.
I can view the properties fine.

When I try to upload a document I get the access denied error message if some of the meta data properties are marked "required". The document is still uploaded. I also get the same error when I try to edit an item in a list.

I can view/edit the properties in Data sheet view fine. The libraries on the existing sites work fine. It only seems to be an issue on new sub-sites.

It almost seems like a permission problem generating the property edit forms. There is nothing in the SP log files.

SharePoint List Query Filter


I am writting an SSRS report where I am querying a SharePoint list and trying to filter the data through the CAML query.  In BIDS, the query returns data, but the filter where clause doesn't seem to be getting recognized as I get all of the data back.  The where clause does seems to work in the U2U CAML Query Builder tool.

Can anyone please give advice as to why my where clause isn't working?


   <Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems">
         <Parameter Name="listName">
                   <DefaultValue>Subscribe - Sales by Product Group - Wheel</DefaultValue>

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend