I have noticed this in my own environment. The way to get the behavior you desire is to do these two things:
Ensure that the column(s) being filtered on are indexed columns
To index a column got to Library Settings --> Columns section
see Image 1 below
Here is the magic: go into the view's edit screen and explicitly set the view's Item Limit parameter ...
Have you tried TODAY() function instead? The following returns 6/2/1991.
You could modify your view using SharePoint Designer to set this filter value. It allowed me to set the filter for 30 years in SharePoint 2013 as shown below.
If first filter in your query returns more than 5000 items, you will get this error/exception.
So, try adding the filter which return less than 5000 items first in filter query.
For example: If status ne 'Closed' returns less than 5000 items, you should add it first in filter query & then other filters like:
$filter=((status ne 'Closed') and (dueDate le '...
REST API with date range parameters works for me in SPO/SPFx. Just make sure date range is formatted correctly. Here is an example:
https://MysharePoint.tenant.com/sites/siteColl/_api/web/lists/GetByTitle('myLibrary')/items?$top=5000&$Select=ID, Title, AssignedTo/Title, AssignedTo/EMail, Modified,Created&$Expand=AssignedTo/Id&$filter=(created%...
You can filter list items using CAML query when fetching list items using RenderListDataAsStream endpoint.
You can pass the CAML query to POST API like below example:
I think It is impossible to display only one item with latest Date. You can group by city on Edit view page or in the view directly.
Then you can sort by Date in descending order, the first item is the one with the latest Date.
you can apply a sort on Date column, then limit the count of the item to be show in the view. By this you can see top 5 or 10 visits.
Also you can try to group by City column so it will show top date visit per city group.
Create a new view and set the filter，Content Type is equal to Folder Or specific metadata equals value:
Then change the view in the document library web part to display that library filtered by a specific metadata and also display all the folder structure.