XF 2.0 INNER JOIN in search

[CMTV]

Hi!

This link will show all user posts:

http://question.threads/index.php?search/member&user_id=1

Now how can I dispaly only posts with green diamond icon? Such "diamond" post ids are stored in xf_QT_best_answer table so I can get their ids with this query:

SELECT `xf_post`.`post_id` FROM `xf_post` INNER JOIN `xf_QT_best_answer` ON `xf_post`.`post_id` = `xf_QT_best_answer`.`post_id` WHERE `xf_post`.`user_id` = ?

The problem is: How to show only "diamond" posts in search results page?

 

[S Thomas]

I think the query you want to extend is in /XF/Pub/Controller/Search/ =>actionMember(). According to https://xenforo.com/xf2-docs/dev/entities-finders-repositories/#with-method you'd have to create a QT-Entity first and then extend that method:

        if ($content && $searcher->isValidContentType($content))
        {
            $query->inType($content)->with('QT', true);
        }

 

[CMTV]

I don't really understand how search is working in xenForo...

There is no with method in $query variable.

 

[CMTV]

I will try to explain my problem. (updated first post too).

This link will show all user posts:

http://question.threads/index.php?search/member&user_id=1

Now how can I dispaly only posts with green diamond icon? Such "diamond" post ids are stored in xf_QT_best_answer table so I can get their ids with this query:

SELECT `xf_post`.`post_id` FROM `xf_post` INNER JOIN `xf_QT_best_answer` ON `xf_post`.`post_id` = `xf_QT_best_answer`.`post_id` WHERE `xf_post`.`user_id` = ?

The problem is: How to show only "diamond" posts in search results page?

 

[S Thomas]

Yea, you're right. Neither \Query nor \Search are tied to a Finder. So basically the idea behind all that stuff is:

• Figure out who builds the query (/XF/Pub/Controller/Search/)
• Add your stuff to the builder (?)
• Run the query (/XF/Repository/Search/)

Sadly, I haven't figured out myself yet how the query is actually built. Maybe someone else can help you out there. A dirty approach whatsoever would be to override the runSearch() in /XF/Repository/Search/ method.