Filter by related fields

[larylinz]

Is there a way to implement filtering by related fields?
like: $filter->add('contact.lastname', 'name', 'text');
thxs.

[zofe]

updated
hi, basically not for "all" fields and not for all kind of "relation", but can be done (for some).
see below

[zofe]

it already works on belongsTo relations because internally it works on foreingKey:
see "Author" autocomplete: http://www.rapyd.com/rapyd-demo/filter
It filter by author_id, but using author.fullname as fieldname where:
"author" is the relation
"fullname" is a simple accessor (look one demo models)

to know how autocomplete works, if it's not intuitive, look on http://www.rapyd.com/rapyd-demo/advancedform

[zofe]

ok now it should work also for:
hasOne, hasMany, belongsToMany

[larylinz]

thxs! looks great! (changed to dev-master now)
got the filter and autocomplete now! :-)
but how to save realted fields? $edit->add('contact.lastname','name', 'text'); ?
it gives me the 'id' of the related row (like 'contact.id') and i'm able to change it, but i'd like to change for example 'lastname'.
how to do that?

[zofe]

I'm working on that, but basically for now to store values:

• it looks at relation-type first (so "contact."),
• if relation is a "belongsTo" it try to store the foreign key value, ".field" is used only as display value
• if relation is a "belongsToMany" it works on pivot table retrieving / storing associations, again ".field" is used only as display value
• I plan to support "hasOne" too asap. (in this case it will store "lastname" value on contact table)

these samples are on demo / datafilter adv

[zofe]

ok I close this issue because:

• datafilter now can handle HasOne, HasMany, BelongsTo, BelongsToMany
• field supported: text (HasOne, HasMany), select, radiogroup, autocomplete (BelongsTo), tags (BelongsToMany)

It's not all tested but feel free to open a new issue (but be specific: field-type relation-type).
Note: it works only for first level relationship. (you can't use 'relation.anotherrelation.field')