Tag Info

New answers tagged

0

Even though query multi-value lookup fields is not supported as were mentioned in another answers, i assume the OP is asking about filtering by multi-value lookup fields. The following examples demonstrates how to filter by multi-value lookup fields: Assume a Projects list that contains Tasks multi-value lookup field: Title Tasks Project A 2;8 ...


2

As Pete M mentioned above you cannot filter directly on a multi-value lookup. The workaround to this is to use a CAML query via an HTTP POST. This does have the overhead of having to get the request digest, if the list doesn't have a large number of items, it may be best just to use client side filtering. var endPoint = ...


0

I feel your pain, but unfortunately this is not supported: https://msdn.microsoft.com/en-us/library/office/fp142385.aspx#sectionSection4 Because multi-value lookup fields are returned as a string of multiple values, there is no way to query for them (for example, the equivalent of an Includes element or NotIncludes element is not supported).


0

The problem stems from the list view web part itself, and the way it tries to retrieve all possible filter values for the column, which causes it to bump up against the list view threshold even when your view is able to circumvent it. One alternative is to use metadata navigation, which adds specified filtering options to the quick launch. Of course, this ...


0

In addition to approach suggested by Jeffrey, if you wish to access list exceeding threshold by code(create a web part with filtered data display), refer to link given below: Overcome list threshold


0

I've had my woes with the list view threshold being reached. Good call first off on not increasing the threshold. The best advice I have is to review the below article, which toward the bottom has tips on how to handle large lists/libraries while avoiding increasing the threshold. It explains in better detail what I'd like to tell you. Useful Link


1

I can resolve the issue , the prod environment is an "fr" site collection so the query should be ($filtre=) at the place of ($filter=) just write filter with fr language.


1

For this you have to use Calculated column. Specify a column name (use like BirthdayThismonth) For type select “Calculated based on other columns” For the formula use =IF(MONTH([Today])=MONTH([birthday date]),"Yes","No") So now your column will contain either value Yes or No based on Calculated field. Now create a new view with filter where ...


1

I would recommend to replace REST query,utilize CAML query instead of filter query option as demonstrated below: Endpoint: POST /_api/web/lists/getbytitle('<list title>')/getitems { 'query' : { '__metadata': { 'type': 'SP.CamlQuery' }, 'ViewXml' : query } } where query: <View> <Query> ...


0

SPGridView It's really painfull to work with. I have spent nearly 70 hours trying to do what are you saying. Finally I could handle multiple SpGridViews with multifiltering saving the controls in an external class and working with them using a singleton pattern. It's impossible to set multiple columns with the option "clear filter", you can just set one ...


2

I'd probably create a column (Flagged of type Yes/No) in the list to act as a field to filter on versus ORing all that together. Tick all the boxes to Yes for those items and then it becomes something like: http://mysite/_api/web/lists/getbytitle('SomeList')/items?$filter=((Flagged eq true)&$orderby=Test_x0020_Date desc&$expand=AttachmentFiles& ...


0

Using SPServices in your edit form make sure it is placed after: <asp:Content ContentPlaceHolderId="PlaceHolderAdditionalPageHead" runat="server"> In a custom form it should be located shortly after the listings of the fields in the code.


2

Tony, You can solve your task with ready-to-use solution from VirtoSoftware such as Virto Sharepoint Calendar. http://www.virtosoftware.com/products/collaboration/virto-calendar-for-microsoft-sharepoint There is also a free 30 days trial, so you can test everything.



Top 50 recent answers are included