This forum has moved to a new location and is in read-only mode. Please visit talk.octobercms.com to access the new location.
Hi, I've extends the Rainlab Blog plugin, adding and extra field to the post. "teaCups" This extra fields lives on a separated table (has october documentation recommends), and works great, (this a dumb($post) from Rainlab Post Component on the function listPosts) +hasOne: array:1 [▼ "teacups" => array:1 [▼ 0 => "Test\TeaCups\Models\teacups" ] ] but, when I try to sort the results by "teacups" I get this error:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'teacups.teacups' in 'order clause' (SQL: select from rainlab_blog_posts
where published
is not null and published
= 1 and published_at
is not null and published_at
< 2016-02-11 18:40:24 and (select count() from rainlab_blog_categories
inner join rainlab_blog_posts_categories
on rainlab_blog_categories
.id
= rainlab_blog_posts_categories
.category_id
where rainlab_blog_posts_categories
.post_id
= rainlab_blog_posts
.id
and id
in (11)) >= 1 and post_type_id
in (1) order by rank
.stars
desc limit 7 offset 0)
when I use this "extra field" on the front end, I just access to this using: $this->page[ 'post' ]->teacup->teacup and works fine... so, How can I sort the results using this extra field?
Thanks a lot.
1-1 of 1