Custom options for the dynamic select filter

[CharlieWinkwaves]

By default the dynamic filter uses the column names of the model as its options.
This can be overwritten by

filter(:condition, :dynamic,
         header: _('Dynamic condition'),
         operations: %w[= =~ >= <= !=],
         select: [[_('Title'), :title],
                  [_('Text'), :text],
                  [_('Author'), 'users.screenname']])

# this fails when using associated models with the LIKE_OPERATION.
if column_type(field) == :string
  driver.contains(scope, field, value)
else
  value = Datagrid::Utils.format_date_as_timestamp(value) if date_conversion
  driver.where(scope, field, value)
end

in that case the column_type(field) returns nil and thus driver.where(scope, field, value) is called, which does not partial match.

Is it an option to also run the contain when the column_type(field) returns nil?
I tested this locally and it works

[bogdan]

The complexity of parsing `users.screenname' and guessing what table and column is it and what is its type is hard.

I found some solution.

It relays on the SQL returning a column type when a field is not directly a column of a model you are building a scope on.
As per my test this works on PostgreSQL and doesn't on SQLite3.
I am not sure about MySQL.

Can you try current main branch and test if it solves your problem?