Custom results in Selection-List (with query)

Hello,

I need when I click "Search More" in the "Assigned To" field, open the Selection-List view, but with specific users (results of a query).

I don't want filters in selection-list, I want show only the users as a result of custom query.

Thanks in advance.

Best Regards,

Rubén Recacha.
Consultant REDK Software Engineering

0 Rafael Queiroz over 10 years ago

You may use customcode to render a dropdown field with simple HTML. And then in a javascript file you call an Ajax function to load the field options based on any query result.
0 Rubén Recacha Camacho over 10 years ago

Hi Rafael,

Thanks but it no use to me, because I want to continue to maintain the functionality of the field "Assigned to", and therefore must be a relationship field.

Does anyone comes up with a way to display results based on a query without filters? :-(

Thanks.

Rubén Recacha.
Consultant REDK Software Engineering.
0 Francesca Shiekh over 10 years ago

I managed to open a selection-list with a Collection generated from the results of an API call (you can define your own API for the results you need if there isn't one that already serves your purpose)

Note that I wanted the selection-list for Accounts to open automatically when a Contact relate field was changed (we have a custom N-M Accounts-Contacts) so I open it on-change in record.js

So it's not a complete solution for you but it may give you some ideas...

See my last post here:
https://community.sugarcrm.com/thread/23392

HTH,
FrancescaS