XF 2.0 Finder ->with command

[AndyB]

I'm trying to create a finder which searches the xf_post table.

The following $conditions variable:

$nodeRepo = $this->repository('XF:Node');
$nodes = $nodeRepo->getNodeList();
$nodeIds = $nodes->keys();

foreach ($nodeIds AS $k => $v)
{
    $conditions[] = ['xf_thread.node_id', '=', $v];
}

The finder:

$finder = \XF::finder('XF:Post');
$posts = $finder
    ->with('Thread')
    ->where('message', 'LIKE', $finder->escapeLike($keywords, '%?%'))
    ->where('message_state', '=', 'visible')
    ->whereOr($conditions)
    ->order('post_id', 'DESC')
    ->limit($limit)
    ->fetch();

Why am I getting the following error message?

LogicException: Unknown relation XF:Thread accessed on xf_post in src/XF/Mvc/Entity/Finder.php at line 630

Thank you.

 

[XenConcept]

Hello,

Try $conditions[] = ['Thread.node_id', '=', $v];

PS: I am not sure

Regards

 

[AndyB]

Thank you, XenConcept. That worked perfectly.

 

[AndyB]

Now I would like to also add Node as a relation. The reason is in my template I would like to show the forum title.

I added ->with('Node') like this:

$finder = \XF::finder('XF:Post');
$posts = $finder
    ->with('Thread')
    ->with('Node')
    ->where('message', 'LIKE', $finder->escapeLike($keywords, '%?%'))
    ->where('message_state', '=', 'visible')
    ->whereOr($conditions)
    ->order('post_id', 'DESC')
    ->limit($limit)
    ->fetch();

but I get the following error:

LogicException: Unknown relation Node accessed on xf_post in src/XF/Mvc/Entity/Finder.php at line 630

Thank you.

 

[XenConcept]

Try

$finder = \XF::finder('XF:Post');
$posts = $finder
    ->with('Thread')
    ->with('Thread.Node')
    ->where('message', 'LIKE', $finder->escapeLike($keywords, '%?%'))
    ->where('message_state', '=', 'visible')
    ->whereOr($conditions)
    ->order('post_id', 'DESC')
    ->limit($limit)
    ->fetch();

 

[AndyB]

Thank you, XenConcept. However that doesn't work, I get the following error:

LogicException: Unknown relation Node accessed on xf_thread in src/XF/Mvc/Entity/Finder.php at line 630

 

[XenConcept]

Excuse me I was wrong.

$finder = \XF::finder('XF:Post');
$posts = $finder
    ->with('Thread')
    ->with('Thread.Forum')
   ->with('Thread.Forum.Node')
    ->where('message', 'LIKE', $finder->escapeLike($keywords, '%?%'))
    ->where('message_state', '=', 'visible')
    ->whereOr($conditions)
    ->order('post_id', 'DESC')
    ->limit($limit)
    ->fetch();

 

[AndyB]

Thank you, XenConcept. The above Post #7 works perfectly.