List View Threshold - Related Items
Posted: 29 Jan 2018
Hi,
I have some large lists, and we have planned around these large lists with the use of indexed columns where query's need to be made but in the related items sections of our forms, despite telling forms designed to query the related items via an indexed column we get the list view threshold issue. I gather that the form is querying the entire list, and then filtering that view which creates a significant problem for us.
Being that the related items, are related to the current item, we cannot put that filter into the view used by forms designer. Is there any solution where we can build a query for that view of which the only results returned are based on the indexed columns we need to query them with?
We do not want to extend the list view threshold due to performance constraints.
Thanks,
Karl
I have some large lists, and we have planned around these large lists with the use of indexed columns where query's need to be made but in the related items sections of our forms, despite telling forms designed to query the related items via an indexed column we get the list view threshold issue. I gather that the form is querying the entire list, and then filtering that view which creates a significant problem for us.
Being that the related items, are related to the current item, we cannot put that filter into the view used by forms designer. Is there any solution where we can build a query for that view of which the only results returned are based on the indexed columns we need to query them with?
We do not want to extend the list view threshold due to performance constraints.
Thanks,
Karl