Tag Info

Hot answers tagged

3

You can create/modify a view and apply the filter on the start date. To create/modify a view, go to list settings-> Scroll down to bottom and you will see a section named Views. Here you can click on exiting view or create a new view. In the view you can filter based on the start date in the Filter Section. UPDATE Based on your update in the question. This ...


3

Applying such complicated filter just isn't possible from UI. However, you can do it e.g. from SharePoint Designer or Powershell. From SharePoint Designer: Open your site in SharePoint Designer Go to Lists and Libraries Select your list There is "Views" section to the right. Find your view there and click on it. Code editor will be shown. Find ...


2

It should look something like this (don't quote me because I haven't tested this): <Where> <Or> <Eq> <FieldRef Name="File_x0020_Type" /> <ValueType="Text">pdf</ValueType> </Eq> <Eq> <FieldRef Name="ContentTypeId" /> ...


2

I can't really provide a sensible answer to why this is happening (I can confirm I'm experiencing the same weird behavior. I'm sure this is related to the fact that they cut out the designer part without properly thinking about the consequences this would have had). What I can offer is a dirty workaround that proved to be almost always working in my case. ...


2

If you want to filter it based on workflow status This list might be useful when you creates a view based on workflow status. If you are creating a view for a list filtered by the workflow status, you would need use the number rather than the words (e.g. 2 instead of In Progress, 4 instead of Cancelled etc) Status Value Not Started 0 Failed on ...


2

its long winded but,, you need to add a filterd webpart to the list page: this is a step by step guide with images! https://www.nothingbutsharepoint.com/sites/eusp/pages/sharepoint-list-filtering-by-date-range.aspx


2

Add a new field to the document library, a Yes/No field.. asking user to select whether he wants the document to advertise or not.. Add a filter in Content Query Web Part for this field.. EDIT For multiple document libraries Approach 1: Write a Powershell script to add this field to each document library.. Or using SharePoint Object Model add this field ...


2

The problem is that every list in the template get a new ID when the list is created during the template provisioning. Therefor the filter and fields reference to non existing list. While the web parts reference the list via the url. The filter web part use hard coded ID's. The only way around this is to reconfigure or add a custom code that fix the ...


2

To filter lookup field you can use SPFilterDropdown function of SPServices. This function allows you to filter lookup column using CAML Query against source list. All you have to do is download the SPServices js file and use it. One more thing jQuery reference is also needed. Hope this helps.


2

Use the following approach 1.) Create a visual webpart 2.) First add the following on the .ascx page Code for .ascx page <SharePoint:ListViewByQuery runat="server" ID="customlistview" /> 3.)Add the following code to query your list(assuming you have created the site and web objects) Code for .ascx.cs page SPList list = ...


2

Forget about any third party tools. I was able to handle this very problem by modifying the sql call in the WCF service and using filtering that's built in to the BCS via SharePoint Designer. I've blogged about it here. http://www.spcrew.com/blogs/Lists/Posts/Post.aspx?ID=47 Here are the basic steps: Create a Method in WCF Service to call the database ...


2

To query any person or group field against logged in user you can use **<UserID/>** tag in Value. if (!Page.IsPostBack) { using (SPSite mySite = new SPSite(SPContext.Current.Web.Url)) { using (SPWeb myWeb = mySite.OpenWeb()) { ...


1

There is no way OOTB to have a column filter behave like the one you have in Excel. As you already noticed, the SharePoint filter is an exact-match type of filter. There is a workaround though, which involves creating a parameter on the XsltListViewWebPart and adding either a text filter webpart or a textbox input control on the same page where the XLVWP ...


1

Create a new view for your list (either from SPDesigner or the browser UI) and make it the default. Now, in SPDesigner, go to Lists and Libraries > your list > Views > Right click on the new view and Edit file in advanced mode. In Split mode, hover the mouse over the first EmployeeID field value, then click right before it and enter some dummy text (see ...


1

If you go to your document library and go into your document library settings, you should see your column Categories. When you click on it you can change the type of the column to "Choice" and then you can define the choices the user should choose from and the way it is displayed (by default a dropdown)


1

To the best of my knowledge the REST API does not support OData filters on null date values. There is an MSDN forums post with someone having the same issue and a member of the SharePoint team mentions that it is a known issue and they are working on it. The current implementation of REST does not support null values for filtering on list item ...


1

Is simple lines you would need to: Use filter to show ONLY those titles (or group by Title to get all various "clusters") Order descendant by the Column for which you Seek the Maximum Put an Item Limit of 1. The only question I see open is related to the Clustering (e.g. if you are trying to make the solution reusable). In that situation, i could imagine ...


1

Well either you have to drop the NewForm on the "Stage" item display page.. Or you should create your own custom "Add new item" button.. which takes Stage Item Id from Query String [ID] and send it to the popup/page of New Item form! Once you have the Stage Id in Query String you can use jQuery to get the control and set its value: ...


1

You can customise the XSL of the CQWP so that when you click on an item it takes you to a custom page. Further you could add a parameter to that call to define which supplier you want displayed on the page and then filter web parts on the custom page using the parameter. There are posts on basic XSL and also how to use it with CQWP on ...


1

The [Me] reference is a type of function in SharePoint / Office. Use the following link to see the official documentation on Formulas and Functions. This isn't exactly the side-by-side comparison you are looking for but, it does detail things fairly well. ...


1

If you want to use your list as a lookup list then you can try using my free tool SharePoint 2010 Autocomplete Lookup Field However, if you want to create a webpart with textbox, you can use Jquery along with REST to search the list as shown in this example: Autocomplete TextBox using JQuery and REST


1

You can filter a list in a view based on a textbox using SharePoint Designer. The basic steps include: Add an ASP.NET textbox control to your page Add the XSLTListView webpart (if it's not already there) Click the XSLTListView webpart and click Parameters. Add a Control Parameter and find the textbox control ID from the drop-down. Name it something ...


1

You need to call it FilterOp1 in the URL. e.g. for less-than: ?FilterField1=fieldname&FilterValue1=value&FilterOp1=Lt MSDN has the full list of operators.


1

The connected web parts should still work. Have you tried selecting an alternate column first? The reason you don't see the option is because there is a data type mismatch. If you select something of the same or a compatible data type, it should let you connect the web parts. I think Project Name could be the "field with edit menu" type, you might try the ...


1

So, what we are going to do is add a short jQuery script on our page. This script will read the text in a text box and then filter all the rows in a list view and only show those rows that contain text that’s in the text box. To be more exact the script will: 1.Find the specific table we want to filter (don’t filter on EVERY row on the page, ...


1

Without knowing your site structure or the structure of the data, the only reliable way would be to create custom Search Scopes and configure them to include only the desired content for those specific categories. You would then add the proper scope to the querystring when building the link. A possible alternative is available if the desired filter can be ...


1

And if you have multiple list filter webparts in your page, here is how to access the value of each of them $("div.ms-WPBody div div:eq(0) span input").val(); for your 1st webpart $("div.ms-WPBody div div:eq(1) span input").val(); for your second webpart, and so on



Only top voted, non community-wiki answers of a minimum length are eligible