Error on Search on belongs_to with class_name option

[sobanakram]

Error:

Dashboard:

ATTRIBUTE_TYPES = {
  sender: Field::BelongsTo.with_options(
    class_name: "User",
    searchable: true,
    searchable_field: :phone_number,
  )
}

Model:

belongs_to :sender, class_name: 'User', foreign_key: :sender_id

[andrepcg]

Having the same issue.

ATTRIBUTE_TYPES = {
    owner: Field::BelongsTo.with_options(class_name: 'Person', searchable: true, searchable_field: :first_name),
}

PG::UndefinedTable: ERROR: missing FROM-clause entry for table "owners" LINE 1: ...name" AS CHAR(256))) LIKE '%simão%' OR LOWER(CAST("owners".."first_name"

It's trying to use the owners table but I set the class to be Person so it should use people.first_name in the query

Rails 5.1.7
Administrate 0.11.0

[andrepcg]

It might be fixed in #1264

[bjgaynor]

This is still not working to the best of my knowledge and it's a shame because I have a lot of custom class names that now can't be searchable.

[ksearfos]

Agreed -- I am still having this issue

[pablobm]

Should be fixed now. Please let us know if not.

[andrepcg]

@pablobm Still having the same issue on v0.13.

#1179 (comment)

It still tries searching in the table named owners instead of people.

In the model I have belongs_to :owner, class_name: 'Person' and in the dashboard I have owner: Field::BelongsTo.with_options(class_name: 'Person', searchable: true, searchable_field: :first_name).

Is it already on 0.13?

[sedubois]

@andrepcg release 0.13.0 was on March 13 but that PR was merged on March 21. Could you try master?