Addional options for the foreign key dropdown

[expired user #9283]'s profile image [expired user #9283] posted 9 years ago in Feature discussion Permalink
The foreign key drop down seems to always be sorted alphabetically. It would be nice to have some options that allows the user to select which columns appear in the drop down and how they are sorted. Perhaps this could be located near/under the "Sorting", "Columns" and "Filter" buttons.
1 attachment(s):
  • Image2
ansgar's profile image ansgar posted 9 years ago Permalink
As we can have multiple columns with a foreign key in a table, the setting for which columns to display would need to go somewhere over the dropdown itself, not in the top right corner. Now it's an ordinary combobox. A "column selector" would then be located above the selectable items somehow. Or, we just display all text/varchar columns in longer lines?
[expired user #9283]'s profile image [expired user #9283] posted 9 years ago Permalink
Alternately, you could add a button next to the combobox or to the column header - and when the user clicks the button it opens a dialog/small window with column/sorting options.
1 attachment(s):
  • Image3
[expired user #7581]'s profile image [expired user #7581] posted 8 years ago Permalink

Suggest also adding the ability to adjust the FK table limit or add a custom query/filter.

This would be an awesome addition, since often times the order of the columns is not the desired column to be displayed in the FK dropdown or adding in a JOIN to help display an associated column from another table other than the FK. As well as the ability to increase the 1,000 row limit preventing the display of the dropdown.

Please login to leave a reply, or register at first.