drift icon indicating copy to clipboard operation
drift copied to clipboard

Document whether using `computedField` on a reference column will join the referenced table or not

Open AhmedLSayed9 opened this issue 1 year ago • 1 comments

At referencing-other-tables section, it has a note for Filter on foreign keys: "when filtering on a reference column, drift will apply the filter to the column itself instead of joining the referenced table."

At computed-fields section, it just mentions "You can write expressions which reference other columns in the same table or even other tables. The joins will be created automatically by the manager." But, it doesn't mention whether the computedField (on a reference column like id) will join the referenced table or not. i.e:

final todoCategoryId = db.managers.todoItems.computedField((o) => o.category.id);

AhmedLSayed9 avatar Nov 11 '24 21:11 AhmedLSayed9

cc @dickermoshe

simolus3 avatar Nov 12 '24 22:11 simolus3