Tag Info

Hot answers tagged

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 = ...


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& ...


1

Display column in descending order: Go to List Settings Modify the View In Group By >> Select column & check Show groups in descending order


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> ...



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