Prepopulate Expression Grid with partially populated rows
Ideally I need to be able to do this:
- Load metadata with connection string
- Automatically add specific table to query builder
- Populate Expression Grid with rows that have no expression, but with Alias (Column name) populated. This list is unrelated to the table selected.
The idea is to help the user by supplying all aliases that will be needed instead of having them type them manually.
I looked in examples such as AlternateNames, but the rows added are related to the table selected.
Is there a way to do this?
What we can suggest is to change the Alias column from a simple text edit box to combobox and prepopulate it with the list of values you need. The weak point is that users can select duplicate values or not select them at all. Do you need such customization?