Hello!
I have set up a lookup control for a reference but looks like it is not working when trying to filter from grid columns.
Do I need to do the change somewhere else or is this a bug?
Solved
Lookup control option for grid filter
+2- Warrior
Best answer by Tim de Lang
Hi
I understand that you’d like users to have better insight into what data is available in a lookup.
Yes, please create an idea for this.
One important consideration is that lookups can contain very large datasets. Simply showing all data is not always feasible, both from a performance perspective (e.g. millions of records) and from a usability perspective (it would overwhelm users).
It would therefore be helpful if you could include your thoughts on exactly how you’d want this to work/behave in practice.
Thank you very much.
Kind regards,
Tim de Lang
+4hi
In your example, you have a dropdown where you can type to filter on lookup values. This is the expected behavior for an excel style filter for lookups. This is what it looks like in TCP for example when I start to search:
I can add multiple items here like so because Product is filtering using the in operator:
The filter is then applied to the dataset.
This is working as expected. Could you please clarify what behavior you would expect that you’re not getting?
Kind regards,
Tim de Lang
+2- Warrior
Hi
Thanks for clarification, what we intended to achieve is to have directly the dropdown with elements to pick on filter so user can see directly on what to filter without typing it.
Indeed, how it is right now (with type to search) is working, is just that we wanted the behavior described above and we expected that it will pick the lookup control setting set up on subject (as it works for the forms).
Should this be an idea then?
+4Hi
I understand that you’d like users to have better insight into what data is available in a lookup.
Yes, please create an idea for this.
One important consideration is that lookups can contain very large datasets. Simply showing all data is not always feasible, both from a performance perspective (e.g. millions of records) and from a usability perspective (it would overwhelm users).
It would therefore be helpful if you could include your thoughts on exactly how you’d want this to work/behave in practice.
Thank you very much.
Kind regards,
Tim de Lang
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.