Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Want to run a query to select custom field picker from another database

custom-fields

I would like to be able to select data choices for a custom field by running a query to return valid choices against a table in another database on the same server. For example, I have a database with customer orders against which I raise problem tickets. I want to be able to produce a drop down of valid order numbers for say the current day. There are too many to provide a drop down of all orders, and I don't really want to run a stored proc every minute or so in my other database to keep a table in Gemini up to date.

I've tried using a fully qualified SQL name (database | schema | table) but it didn't seem to work.

Is running a query or stored proc possible?

Better still, I'd want the query to contain selections based on other data entered into Gemini, for example a product type or the order date

cpf_jg
· 1
cpf_jg
Replies (3)
helpful
0
not helpful

You should cerate a view that looks at the other database.


Mark Wing
· 9108
Mark Wing
0
DELETED.  House Rules

cpf_jg
· 1
cpf_jg
helpful
0
not helpful

Looks a good suggestion but I have another problem when I try this.

When defining an SQL-driven custom field , Gemini won't let me not define a key field.

But to define a key field on a view, I need to use Schema Binding, and I can't use this across databases because it only supports 2-part names.


cpf_jg
· 1
cpf_jg
helpful
0
not helpful

The key field comes from the table the view is based on, so there is nothing to do but select it in the view.


Mark Wing
· 9108
Mark Wing