Make custom fields searchable

This site is best viewed in a modern browser with JavaScript enabled.

Make custom fields searchable

Cozmoz

Hi,

Would it be possible to make the custom fields searchable?

Many thanks,

Costa

Cozmoz

I have added this function by amending the file below as follows:

/anchor/models/page.php

    /*
    //Original query
    $query = static::left_join(Base::table('users'), Base::table('users.id'), '=', Base::table('posts.author'))
        ->where(Base::table('posts.status'), '=', 'published')
        ->where(Base::table('posts.title'), 'like', '%' . $term . '%')
        ->or_where(Base::table('posts.html'), 'like', '%' . $term . '%');
    */
    
    $query = static::left_join(Base::table('users'), Base::table('users.id'), '=', Base::table('posts.author'))
     ->left_join(Base::table('post_meta'), Base::table('post_meta.id'), '=', Base::table('posts.id'))
     ->where(Base::table('posts.status'), '=', 'published')
     ->where(Base::table('posts.title'), 'LIKE', '%'.$term.'%')
     ->or_where(Base::table('post_meta.data'), 'LIKE', '%'.$term.'%')
     ->or_where(Base::table('posts.html'), 'like', '%' . $term . '%');

Hope this can help others.

craig

Thanks Cozmoz

bretcamble

Minor tweak on that join: needs to be "Base::table('post_meta.post')". A good mod. It lets me set up tags for my posts!