I want to use cursor using joined table, but it throws Unknown column 'gallery_media.score' in 'where clause'
Even if in cursor_by
i clearly choose a column from joined table seaorm is trying to use score
from orginal table not joined.
Its one to many relationship – one gallery multiple categories.
gallery_media::Entity::find()
.select_only()
.columns([gallery_media::Column::MediaId])
.filter(gallery_media::Column::GalleryId.eq(path.gallery_id))
.left_join(galleries::Entity)
.cursor_by(galleries::Column::Score)
.limit(50)
.into_model::<PartialMedia>();