Page 1 of 1

Odata - GroupBy Lookup Fİltering

Posted: 05 Jul 2018
by bc101820
Hello ,

I created a list with the name 'EgitimKatalogu' and in this list I have a Manage plumsail lookup field with name 'Gorev' which gets data from another list's field : pozisyon. But I have some repeating datas and I don't want that repetition. I tried to write odata with groupby but I didn't get the result I wanted. Your help is appreciated.

Thank you.

Re: Odata - GroupBy Lookup Fİltering

Posted: 05 Jul 2018
by Nikita Kurguzov
Dear bc101820,
The data will be repeating as every single item you see here is unique - it has a unique ID and from the point of view of SharePoint, it's different, even if many of them share the same Title. In order for these items to not repeat, you should have a list where these values do not repeat.

Re: Odata - GroupBy Lookup Fİltering

Posted: 05 Jul 2018
by bc101820
Nikita Kurguzov wrote:
05 Jul 2018
Dear bc101820,
The data will be repeating as every single item you see here is unique - it has a unique ID and from the point of view of SharePoint, it's different, even if many of them share the same Title. In order for these items to not repeat, you should have a list where these values do not repeat.
Yes, I understand what you say but probably it is not possible for me to re-create the list because it includes many datas. Can't I just compare the value of the records' name and filter them ? I mean, if the data's name is already included, then don't add it my lookup again ?
Thank you.

Re: Odata - GroupBy Lookup Fİltering

Posted: 05 Jul 2018
by Nikita Kurguzov
Dear bc101820,
Unfortunately, no, and for good reason - this will slow down the process of filtering immensely. You can filter by pretty much any field, or even number of fields, but imagine taking every single value available in the lookup and comparing it to the requested values, and the requests are made when you type something in or just scroll down the dropdown - that's quite often.

This should be possible with a default SharePoint Lookup field, since it retrieves all values to begin with, which you can then filter for uniqueness, but this is still not a great solution.

Re: Odata - GroupBy Lookup Fİltering

Posted: 05 Jul 2018
by bc101820
Nikita Kurguzov wrote:
05 Jul 2018
Dear bc101820,
Unfortunately, no, and for good reason - this will slow down the process of filtering immensely. You can filter by pretty much any field, or even number of fields, but imagine taking every single value available in the lookup and comparing it to the requested values, and the requests are made when you type something in or just scroll down the dropdown - that's quite often.

This should be possible with a default SharePoint Lookup field, since it retrieves all values to begin with, which you can then filter for uniqueness, but this is still not a great solution.
Yes, now I exactly understand what you offer. I am going to create a new list without repetition.

Thank you so much for your help and time !