Tag Info

Hot answers tagged

4

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()) { ...


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

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

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

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

you can use CONTAINS operator in CAML Query. For e.g. <Where><Contains><FieldRef Name='Name'/><Value Type='Text'>Bolt</Value></Contains></Where>


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

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

I did some experimentation a while back involving CAML operators with various field types, and it seems that all external columns get passed back to SP as Strings. You can use DateValue(InsertDate) in your formula to get it as a date (possibly using a calculated column if needed).


2

You are missing ID in expand. The query should look like: _api/Web/Lists(guid'id')/items?$select=Id,Author/ID&$expand=Author/ID&$filter=(Author/ID eq 21)


2

Okay, I solved it. And you can't tell me it doesn't work, because I can see it with my own eyes :) So, that javascript you are running from that guy is unecessary, and it makes things more difficult that they should be. So you have three columns. One column has the status, one column determines the color, and the final column has the div tags. And it's ...


2

I found the answer to my problem. By default, grouped lists are set to be collapsed. If you change this to expanded by default, the list filters as expected. Another wonderful hidden feature of SharePoint maybe?


2

Use double quotes to find exact phrases. If you want to learn about "AD.300" and don't want a bunch of results that include documents that include the word. This tells the search engine to find the exact phrase inside the quotes. Look about more nice tips about search ...


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

One option you have is to implement filtering in the client side. I have done this in one of my implementation, i used to pass the values from a page using Query string and on the list view page i had another script to read the values and display only matching rows. Check jQuery Filters


1

Have you tried using [today]-180?


1

Use the date value like EndTime le datetime'2013-06-12' Note: You may need to use ListData.svc if you are on SP 2013. I started with turning on Team Collaboration Lists feature on my publishing site and creating the Calendar list. Then I have got my REST endpoint, this time around with a "greater than or equal to" filter: ...


1

Try to $expand the field, as well as $select it, like this: ?$select=*,Access/Id&$expand=Access/Id&$filter=Access/Id+eq+null


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

There is no need to use $expand operator if you don't need to return the projected fields. The following REST endpoint demonstrates how to filter by Author Id: /_api/Web/Lists/getByTitle('Tasks')/items?$filter=(AuthorId eq 12)


1

The reason why they are disabled is because the rich text fields contains html formatting, and will by default always be wrapped inside two hidden div tags and making the functions useless.


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

Umh, to be honest I don't think there is an easy way. The timeline information is stored as XML in the Task list. If you have look at the get_rootFolder().get_properties(), you'll find an item named Timeline_Timeline. From the SP.UI.Timeline.ListTimelineDatasource you'll find options for add and remove. To remove you can use: ...


1

If you mean the name that appears above the web part, then you can change it under 'Appearance' in web part properties or else change the chrome to 'None' and then you will not have a name appear at all (unless the page is in edit mode).


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

I fear that the Datasheet view doesn't support web part connections nor filtering (made exception for the manual filters a user can select from the dropdowns on the columns headers, which are a different thing).



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