LookupField - values from external sql View

Support
#1

Hello,

I have a request where I have to show values from an external database(MS SQL) view and values must come to LookupField.

thanks

#2

Hi,
In CUBA you can attach an additional datastore pointing to an external MSSQL database.
After that - create or import entity living in that datastore, that is based on the database view you need.
Related documentation:
https://doc.cuba-platform.com/manual-7.0/data_store.html
https://doc.cuba-platform.com/studio/?_ga=2.37454816.1189720628.1569224134-237267920.1554359693#generate_model